ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471E551A9E05362FB09050512Y select organization_name, position_name, budget_measurement_type, element_name, budget_unit_id, pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null, position_id, element_type_id, :p_start_date, :p_end_date, budget_unit_id, :p_currency_code ) budgeted_amt, pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null, position_id, element_type_id, :p_start_date, :p_end_date, budget_unit_id, 'C', :p_currency_code ) committed_amt, pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null, position_id, element_type_id, :p_start_date, :p_end_date, budget_unit_id, 'A', :p_currency_code ) actual_amt, PQH_PQHWSPBD_XMLP_PKG.cf_act_performula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code )) CF_act_per, PQH_PQHWSPBD_XMLP_PKG.cf_com_performula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )) CF_com_per, PQH_PQHWSPBD_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )) cf_projected_exp, PQH_PQHWSPBD_XMLP_PKG.cf_proj_performula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSPBD_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ))) CF_proj_per, PQH_PQHWSPBD_XMLP_PKG.cf_def_ex_amtformula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSPBD_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ))) cf_def_ex_amt, PQH_PQHWSPBD_XMLP_PKG.cf_def_ex_performula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSPBD_XMLP_PKG.cf_def_ex_amtformula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSPBD_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )))) CF_def_ex_per, PQH_PQHWSPBD_XMLP_PKG.cf_format_mask(budget_unit_id) CF_Format_Mask from pqh_position_budgets_v where position_id = NVL(:p_position_id,position_id) and organization_id = NVL(:p_organization_id,organization_id) and pqh_mgmt_rpt_pkg.check_pos_type_and_variance ( null, position_id, :p_start_date, :p_end_date, budget_unit_id , :p_position_type, NVL(:p_variance_percent,0) , :p_currency_code ) = NVL(:p_position_type,'A') PQH PQHWSPBD_XML AR PQH تقرير تفاصيل عناصر المناصب (بتنسيق XML) Imported from BI Publisher Application: الموارد البشرية للقطاع العام Source: تقرير تفاصيل عناصر المناصب (بتنسيق XML) Short Name: PQHWSPBD_XML DB package: PQH_PQHWSPBD_XMLP_PKG D PQH Positionen - Elementdetails Imported from BI Publisher Application: Public Sector HR Source: Positionen - Elementdetails (XML) Short Name: PQHWSPBD_XML DB package: PQH_PQHWSPBD_XMLP_PKG E PQH Detalles de Elemento de Posición Imported from BI Publisher Application: Public Sector HR Source: Detalles de Elemento de Posición (XML) Short Name: PQHWSPBD_XML DB package: PQH_PQHWSPBD_XMLP_PKG F PQH Etat Détails des éléments de poste Imported from BI Publisher Application: Public Sector HR Source: Etat Détails des éléments de poste (XML) Short Name: PQHWSPBD_XML DB package: PQH_PQHWSPBD_XMLP_PKG I PQH Rapporto Dettagli elemento posizione Imported from BI Publisher Application: Public Sector HR Source: Rapporto Dettagli elemento posizione (XML) Short Name: PQHWSPBD_XML DB package: PQH_PQHWSPBD_XMLP_PKG JA PQH 職階エレメント詳細レポート Imported from BI Publisher Application: Public Sector HR Source: 職階エレメント詳細レポート(XML) Short Name: PQHWSPBD_XML DB package: PQH_PQHWSPBD_XMLP_PKG KO PQH Position 항목 상세내역 보고서 Imported from BI Publisher Application: Public Sector HR Source: Position 항목 상세내역 보고서(XML) Short Name: PQHWSPBD_XML DB package: PQH_PQHWSPBD_XMLP_PKG PTB PQH Relatório Detalhado do Elemento da Posição Imported from BI Publisher Application: Public Sector HR Source: Relatório Detalhado do Elemento da Posição (XML) Short Name: PQHWSPBD_XML DB package: PQH_PQHWSPBD_XMLP_PKG RU PQH Подробный отчет об элементах штат.единиц Imported from BI Publisher Application: Государственный сектор: персонал Source: Подробный отчет об элементах штат.единиц (XML) Short Name: PQHWSPBD_XML DB package: PQH_PQHWSPBD_XMLP_PKG S PQH Löneart för tjänst - detaljrapport Imported from BI Publisher Application: Public Sector HR Source: Löneart för tjänst - detaljrapport (XML) Short Name: PQHWSPBD_XML DB package: PQH_PQHWSPBD_XMLP_PKG TR PQH Pozisyon Kalemi Detay Raporu Imported from BI Publisher Application: Kamu Sektörü İnsan Kaynakları Yönetimi Source: Pozisyon Kalemi Detay Raporu (XML) Short Name: PQHWSPBD_XML DB package: PQH_PQHWSPBD_XMLP_PKG US PQH Position Element Detail Imported from BI Publisher Application: Public Sector HR Source: Position Element Detail Report (XML) Short Name: PQHWSPBD_XML DB package: PQH_PQHWSPBD_XMLP_PKG ZHS PQH 职位要素明细报表 Imported from BI Publisher Application: Public Sector HR Source: 职位要素明细报表 (XML) Short Name: PQHWSPBD_XML DB package: PQH_PQHWSPBD_XMLP_PKG BI Publisher :c_business_group_name :c_report_subtitle :cp_currency :cp_organization_name :cp_position_name :cp_position_type :cp_session_dt :p_business_group_id :p_conc_request_id :p_currency_code :p_effective_date :p_end_date :p_organization_id :p_position_id :p_position_type :p_report_title :p_session_date :p_start_date :p_variance_percent 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') US P_business_group_id 2 10 :p_effective_date Date Y AR تاريخ الفعالية D Gültigkeitsdatum E Fecha en Vigor F Date de début de validité I Data validità JA 有効日 KO 유효 일자 PTB Data de Efetivação RU Дата действия S Giltighetsdatum TR Geçerlilik Tarihi US Effective Date ZHS 有效日期 3 20 :p_organization_id LOV Oracle PQH_ORGANIZATIONS Y select organization_id id, name value, null description from hr_all_organization_units_vl where organization_id in (select distinct organization_id from pqh_budget_details) and business_group_id=hr_general.get_business_group_id order by name Y AR اسم المنشأة D Organisationsbezeichnung E Nombre de Organización F Nom de l'organisation I Nome organizzazione JA 組織名 KO 조직명 PTB Nome da Organização RU Название организации S Organisation TR Organizasyon Adı US Organization Name ZHS 组织名 4 30 :p_position_id LOV Oracle PQH_ORG_POSITIONS Y select position_id id, name value, null description from per_positions pp,fnd_sessions fs where pp.business_group_id=fnd_global.per_business_group_id and fs.session_id=userenv('sessionid') and fs.effective_date between pp.date_effective and nvl(pp.date_end,to_date('31/12/4712','DD/MM/YYYY')) order by value,description AR اسم المنصب D Positionsbezeichnung E Nombre de Posición F Nom du poste I Nome posizione JA 職階名 KO Position명 PTB Nome da Posição RU Название штатной единицы S Tjänst TR Pozisyon Adı US Position Name ZHS 职位名称 5 40 :p_position_type LOV Oracle PQH_POSITION_BUDGET_TYPE Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='PQH_POSITION_TYPE' order by value,description Y AR نوع المنصب D Positionsart E Tipo de Posición F Type de poste I Tipo di posizione JA 職階タイプ KO Position 유형 PTB Tipo de Posição RU Тип штатной единицы S Tjänstetyp TR Pozisyon Tipi US Position Type ZHS 职位类型 6 50 :p_variance_percent Number AR نسبة التباين D Prozentuale Abweichung E Porcentaje de Desviación F Ecarts en pourcentage I Percentuale scostamento JA 差異パーセント KO 차이 퍼센트 PTB Percentual de Variação RU Процент расхождения S Avvikelse i procent TR Fark Yüzdesi US Variance Percent ZHS 差异百分比 7 60 :p_start_date Date sysdate Y AR تاريخ البداية D Startdatum E Fecha de Inicio F Date de début I Data inizio JA 開始日 KO 시작 일자 PTB Data Inicial RU Начальная дата S Startdatum TR Başlangıç Tarihi US Start Date ZHS 起始日期 8 70 :p_end_date Date sysdate Y AR تاريخ النهاية D Enddatum E Fecha de Finalización F Date de fin I Data fine JA 終了日 KO 종료 일자 PTB Data Final RU Конечная дата S Slutdatum TR Bitiş Tarihi US End Date ZHS 终止日期 9 80 :p_currency_code LOV Oracle PQH_CURRENCY Y select currency_code id, name value, null description from fnd_currencies_active_v where currency_code!='STAT' order by name Y AR العملة D Währung E Divisa F Devise I Divisa JA 通貨 KO 통화 PTB Moeda RU Валюта S Valuta TR Para Birimi US Currency ZHS 币种