ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471E451A9E05362FB09050512Y select organization_name, organization_id organization_id1_parent, position_name, budget_measurement_type, budget_unit_id, pqh_mgmt_rpt_pkg.get_position_budget_amt ( null, position_id, :p_start_date_1, :p_end_date_1, budget_unit_id, :p_currency_code ) budgeted_amt, pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null, position_id, :p_start_date_1, :p_end_date_1, budget_unit_id, 'C', :p_currency_code ) committed_amt, pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null, position_id, :p_start_date_1, :p_end_date_1, budget_unit_id, 'A', :p_currency_code ) actual_amt, PQH_PQHWSOPS_XMLP_PKG.cf_act_performula(pqh_mgmt_rpt_pkg.get_position_budget_amt ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , :p_currency_code ), pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , 'A' , :p_currency_code )) CF_act_per, PQH_PQHWSOPS_XMLP_PKG.cf_com_performula(pqh_mgmt_rpt_pkg.get_position_budget_amt ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , :p_currency_code ), pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , 'C' , :p_currency_code )) CF_com_per, PQH_PQHWSOPS_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , 'C' , :p_currency_code )) cf_projected_exp, PQH_PQHWSOPS_XMLP_PKG.cf_proj_performula(pqh_mgmt_rpt_pkg.get_position_budget_amt ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , :p_currency_code ), PQH_PQHWSOPS_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , 'C' , :p_currency_code ))) CF_proj_per, PQH_PQHWSOPS_XMLP_PKG.cf_def_ex_amtformula(pqh_mgmt_rpt_pkg.get_position_budget_amt ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , :p_currency_code ), PQH_PQHWSOPS_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , 'C' , :p_currency_code ))) cf_def_ex_amt, PQH_PQHWSOPS_XMLP_PKG.cf_def_ex_performula(pqh_mgmt_rpt_pkg.get_position_budget_amt ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , :p_currency_code ), PQH_PQHWSOPS_XMLP_PKG.cf_def_ex_amtformula(pqh_mgmt_rpt_pkg.get_position_budget_amt ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , :p_currency_code ), PQH_PQHWSOPS_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , 'C' , :p_currency_code )))) CF_def_ex_per, PQH_PQHWSOPS_XMLP_PKG.cf_format_mask2(budget_unit_id) CF_Format_Mask2 from pqh_organization_budgets_v where organization_id = :p_organization_id_1 And pqh_mgmt_rpt_pkg.check_pos_type_and_variance ( null, position_id, :p_start_date_1, :p_end_date_1, budget_unit_id , :p_position_type, NVL(:p_variance_percent,0) ,:p_currency_code) = NVL(:p_position_type,'A') PQH PQHWSOPS_XML AR PQH تقرير إجمالي المناصب (بتنسيق XML) Imported from BI Publisher Application: الموارد البشرية للقطاع العام Source: تقرير إجمالي المناصب (بتنسيق XML) Short Name: PQHWSOPS_XML DB package: PQH_PQHWSOPS_XMLP_PKG D PQH Positionen - Übersicht Imported from BI Publisher Application: Public Sector HR Source: Positionen - Übersicht (XML) Short Name: PQHWSOPS_XML DB package: PQH_PQHWSOPS_XMLP_PKG E PQH Resumen de Posición Imported from BI Publisher Application: Public Sector HR Source: Resumen de Posición (XML) Short Name: PQHWSOPS_XML DB package: PQH_PQHWSOPS_XMLP_PKG F PQH Etat Synthèse des postes Imported from BI Publisher Application: Public Sector HR Source: Etat Synthèse des postes (XML) Short Name: PQHWSOPS_XML DB package: PQH_PQHWSOPS_XMLP_PKG I PQH Rapporto Sintetico posizione Imported from BI Publisher Application: Public Sector HR Source: Rapporto Sintetico posizione (XML) Short Name: PQHWSOPS_XML DB package: PQH_PQHWSOPS_XMLP_PKG JA PQH 職階要約レポート Imported from BI Publisher Application: Public Sector HR Source: 職階要約レポート(XML) Short Name: PQHWSOPS_XML DB package: PQH_PQHWSOPS_XMLP_PKG KO PQH Position 요약 보고서 Imported from BI Publisher Application: Public Sector HR Source: Position 요약 보고서(XML) Short Name: PQHWSOPS_XML DB package: PQH_PQHWSOPS_XMLP_PKG PTB PQH Relatório Sumariado da Posição Imported from BI Publisher Application: Public Sector HR Source: Relatório Sumariado da Posição (XML) Short Name: PQHWSOPS_XML DB package: PQH_PQHWSOPS_XMLP_PKG RU PQH Сводный отчет о штатных единицах Imported from BI Publisher Application: Государственный сектор: персонал Source: Сводный отчет о штатных единицах (XML) Short Name: PQHWSOPS_XML DB package: PQH_PQHWSOPS_XMLP_PKG S PQH Tjänst - översiktsrapport Imported from BI Publisher Application: Public Sector HR Source: Tjänst - översiktsrapport (XML) Short Name: PQHWSOPS_XML DB package: PQH_PQHWSOPS_XMLP_PKG TR PQH Pozisyon Özet Raporu Imported from BI Publisher Application: Kamu Sektörü İnsan Kaynakları Yönetimi Source: Pozisyon Özet Raporu (XML) Short Name: PQHWSOPS_XML DB package: PQH_PQHWSOPS_XMLP_PKG US PQH Position Summary Imported from BI Publisher Application: Public Sector HR Source: Position Summary Report (XML) Short Name: PQHWSOPS_XML DB package: PQH_PQHWSOPS_XMLP_PKG ZHS PQH 职位汇总报表 Imported from BI Publisher Application: Public Sector HR Source: 职位汇总报表 (XML) Short Name: PQHWSOPS_XML DB package: PQH_PQHWSOPS_XMLP_PKG BI Publisher :c_business_group_name :c_report_subtitle :cp_currency :cp_organization_name :cp_position_type :cp_session_dt :p_business_group_id :p_business_group_id_1 :p_conc_request_id :p_currency_code :p_effective_date :p_effective_date_1 :p_end_date :p_end_date_1 :p_organization_id :p_organization_id_1 :p_position_type :p_report_title :p_session_date :p_session_date_1 :p_start_date :p_start_date_1 :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_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 职位类型 5 40 :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 差异百分比 6 50 :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 起始日期 7 60 :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 终止日期 8 70 :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 币种