eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PA_INTEGRATION_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 12


SELECT DISTINCT(budget_version_id) INTO l_budget_version_id FROM pa_budget_versions

WHERE project_structure_version_id = parent_structure_version_id_in

AND fin_plan_type_id = 10;

Line: 34


SELECT pa_bill_rates_all_seq.nextval INTO bill_rates_all_seq_nextval FROM dual;

Line: 54


DELETE FROM pji_fm_xbs_accum_int;

Line: 56


SELECT Trunc(Max(END_DATE))-1 INTO l_end_date FROM pa_periods_all WHERE status <> 'C';

Line: 57


SELECT trunc(trunc(Max(END_DATE) - Sysdate - 1)) into l_add_days FROM pa_periods_all WHERE status <> 'C';

Line: 68


INSERT INTO pji_fm_xbs_accum_int
(PROJECT_ID,
 STRUCT_VERSION_ID,
 PROJECT_ELEMENT_ID,
 CALENDAR_TYPE,
 PERIOD_NAME,
 PLAN_VERSION_ID,
 RES_LIST_MEMBER_ID,
 QUANTITY,
 TXN_CURRENCY_CODE,
 TXN_RAW_COST,
 TXN_BRDN_COST,
 TXN_REVENUE,
 TXN_LABOR_RAW_COST,
 TXN_LABOR_BRDN_COST,
 TXN_EQUIP_RAW_COST,
 TXN_EQUIP_BRDN_COST,
 TXN_BASE_RAW_COST,
 TXN_BASE_BRDN_COST,
 TXN_BASE_LABOR_RAW_COST,
 TXN_BASE_LABOR_BRDN_COST,
 TXN_BASE_EQUIP_RAW_COST,
 TXN_BASE_EQUIP_BRDN_COST,
 PRJ_RAW_COST,
 PRJ_BRDN_COST,
 PRJ_REVENUE,
 PRJ_LABOR_RAW_COST,
 PRJ_LABOR_BRDN_COST,
 PRJ_EQUIP_RAW_COST,
 PRJ_EQUIP_BRDN_COST,
 PRJ_BASE_RAW_COST,
 PRJ_BASE_BRDN_COST,
 PRJ_BASE_LABOR_RAW_COST,
 PRJ_BASE_LABOR_BRDN_COST,
 PRJ_BASE_EQUIP_RAW_COST,
 PRJ_BASE_EQUIP_BRDN_COST,
 POU_RAW_COST,
 POU_BRDN_COST,
 POU_REVENUE,
 POU_LABOR_RAW_COST,
 POU_LABOR_BRDN_COST,
 POU_EQUIP_RAW_COST,
 POU_EQUIP_BRDN_COST,
 POU_BASE_RAW_COST,
 POU_BASE_BRDN_COST,
 POU_BASE_LABOR_RAW_COST,
 POU_BASE_LABOR_BRDN_COST,
 POU_BASE_EQUIP_RAW_COST,
 POU_BASE_EQUIP_BRDN_COST,
 LABOR_HOURS,
 EQUIPMENT_HOURS,
 BASE_LABOR_HOURS,
 BASE_EQUIP_HOURS,
 SOURCE_ID,
 ACT_LABOR_HRS,
 ACT_EQUIP_HRS,
 ACT_TXN_LABOR_BRDN_COST,
 ACT_TXN_EQUIP_BRDN_COST,
 ACT_TXN_BRDN_COST,
 ACT_PRJ_LABOR_BRDN_COST,
 ACT_PRJ_EQUIP_BRDN_COST,
 ACT_PRJ_BRDN_COST,
 ACT_PFC_LABOR_BRDN_COST,
 ACT_PFC_EQUIP_BRDN_COST,
 ACT_PFC_BRDN_COST,
 ETC_LABOR_HRS,
 ETC_EQUIP_HRS,
 ETC_TXNLABOR_BRDN_COST,
 ETC_TXN_EQUIP_BRDN_COST,
 ETC_TXN_BRDN_COST,
 ETC_PRJ_LABOR_BRDN_COST,
 ETC_PRJ_EQUIP_BRDN_COST,
 ETC_PRJ_BRDN_COST,
 ETC_POU_LABOR_BRDN_COST,
 ETC_POU_EQUIP_BRDN_COST,
 ETC_POU_BRDN_COST,
 ACT_TXN_RAW_COST,
 ACT_PRJ_RAW_COST,
 ACT_POU_RAW_COST,
 ETC_TXN_RAW_COST,
 ETC_PRJ_RAW_COST,
 ETC_POU_RAW_COST,
 ACT_TXN_LABOR_RAW_COST,
 ACT_TXN_EQUIP_RAW_COST,
 ACT_PRJ_LABOR_RAW_COST,
 ACT_PRJ_EQUIP_RAW_COST,
 ACT_POU_LABOR_RAW_COST,
 ACT_POU_EQUIP_RAW_COST,
 ETC_TXN_LABOR_RAW_COST,
 ETC_TXN_EQUIP_RAW_COST,
 ETC_PRJ_LABOR_RAW_COST,
 ETC_PRJ_EQUIP_RAW_COST,
 ETC_POU_LABOR_RAW_COST,
 ETC_POU_EQUIP_RAW_COST,
 ACT_POU_LABOR_BRDN_COST,
 ACT_POU_EQUIP_BRDN_COST,
 ACT_POU_BRDN_COST,
 ETC_TXN_LABOR_BRDN_COST,
 TXN_LPB_RAW_COST,
 TXN_LPB_BRDN_COST,
 TXN_LPB_LABOR_RAW_COST,
 TXN_LPB_LABOR_BRDN_COST,
 TXN_LPB_EQUIP_RAW_COST,
 TXN_LPB_EQUIP_BRDN_COST,
 PRJ_LPB_RAW_COST,
 PRJ_LPB_BRDN_COST,
 PRJ_LPB_LABOR_RAW_COST,
 PRJ_LPB_LABOR_BRDN_COST,
 PRJ_LPB_EQUIP_RAW_COST,
 PRJ_LPB_EQUIP_BRDN_COST,
 POU_LPB_RAW_COST,
 POU_LPB_BRDN_COST,
 POU_LPB_LABOR_RAW_COST,
 POU_LPB_LABOR_BRDN_COST,
 POU_LPB_EQUIP_RAW_COST,
 POU_LPB_EQUIP_BRDN_COST,
 LPB_LABOR_HOURS,
 LPB_EQUIP_HOURS,
 PERIOD_FLAG,
 MIN_START_DATE,
 MAX_END_DATE,
 P_RAW_COST,
 P_BRDN_COST,
 P_REVENUE,
 P_LBR_RAW_COST,
 P_LBR_BRDN_COST,
 P_EQP_RAW_COST,
 P_EQP_BRDN_COST,
 P_BASE_RAW_COST,
 P_BASE_BRDN_COST,
 P_BASE_LBR_RAW_COST,
 P_BASE_LBR_BRDN_COST,
 P_BASE_EQP_RAW_COST,
 P_BASE_EQP_BRDN_COST,
 P_LPB_RAW_COST,
 P_LPB_BRDN_COST,
 P_LPB_LBR_RAW_COST,
 P_LPB_LBR_BRDN_COST,
 P_LPB_EQP_RAW_COST,
 P_LPB_EQP_BRDN_COST,
 P_LBR_HOURS,
 P_EQP_HOURS,
 P_BASE_LBR_HOURS,
 P_BASE_EQP_HOURS,
 P_LPB_LBR_HOURS,
 P_LPB_EQP_HOURS,
 P_ACT_LBR_HOURS,
 P_ACT_EQP_HOURS,
 P_ACT_LBR_BRDN_COST,
 P_ACT_EQP_BRDN_COST,
 P_ACT_RAW_COST,
 P_ACT_BRDN_COST,
 P_ACT_LBR_RAW_COST,
 P_ACT_EQP_RAW_COST,
 P_ETC_EQP_HOURS,
 P_ETC_LBR_HOURS,
 P_ETC_RAW_COST,
 P_ETC_BRDN_COST,
 P_ETC_LBR_BRDN_COST,
 P_ETC_EQP_BRDN_COST,
 P_ETC_LBR_RAW_COST,
 P_ETC_EQP_RAW_COST)
 SELECT PROJECT_ID,
 STRUCT_VERSION_ID,
 PROJECT_ELEMENT_ID,
 CALENDAR_TYPE,
 PERIOD_NAME,
 PLAN_VERSION_ID,
 RES_LIST_MEMBER_ID,
 QUANTITY,
 TXN_CURRENCY_CODE,
 TXN_RAW_COST,
 TXN_BRDN_COST,
 TXN_REVENUE,
 TXN_LABOR_RAW_COST,
 TXN_LABOR_BRDN_COST,
 TXN_EQUIP_RAW_COST,
 TXN_EQUIP_BRDN_COST,
 TXN_BASE_RAW_COST,
 TXN_BASE_BRDN_COST,
 TXN_BASE_LABOR_RAW_COST,
 TXN_BASE_LABOR_BRDN_COST,
 TXN_BASE_EQUIP_RAW_COST,
 TXN_BASE_EQUIP_BRDN_COST,
 PRJ_RAW_COST,
 PRJ_BRDN_COST,
 PRJ_REVENUE,
 PRJ_LABOR_RAW_COST,
 PRJ_LABOR_BRDN_COST,
 PRJ_EQUIP_RAW_COST,
 PRJ_EQUIP_BRDN_COST,
 PRJ_BASE_RAW_COST,
 PRJ_BASE_BRDN_COST,
 PRJ_BASE_LABOR_RAW_COST,
 PRJ_BASE_LABOR_BRDN_COST,
 PRJ_BASE_EQUIP_RAW_COST,
 PRJ_BASE_EQUIP_BRDN_COST,
 POU_RAW_COST,
 POU_BRDN_COST,
 POU_REVENUE,
 POU_LABOR_RAW_COST,
 POU_LABOR_BRDN_COST,
 POU_EQUIP_RAW_COST,
 POU_EQUIP_BRDN_COST,
 POU_BASE_RAW_COST,
 POU_BASE_BRDN_COST,
 POU_BASE_LABOR_RAW_COST,
 POU_BASE_LABOR_BRDN_COST,
 POU_BASE_EQUIP_RAW_COST,
 POU_BASE_EQUIP_BRDN_COST,
 LABOR_HOURS,
 EQUIPMENT_HOURS,
 BASE_LABOR_HOURS,
 BASE_EQUIP_HOURS,
 SOURCE_ID,
 ACT_LABOR_HRS,
 ACT_EQUIP_HRS,
 ACT_TXN_LABOR_BRDN_COST,
 ACT_TXN_EQUIP_BRDN_COST,
 ACT_TXN_BRDN_COST,
 ACT_PRJ_LABOR_BRDN_COST,
 ACT_PRJ_EQUIP_BRDN_COST,
 ACT_PRJ_BRDN_COST,
 ACT_PFC_LABOR_BRDN_COST,
 ACT_PFC_EQUIP_BRDN_COST,
 ACT_PFC_BRDN_COST,
 ETC_LABOR_HRS,
 ETC_EQUIP_HRS,
 ETC_TXNLABOR_BRDN_COST,
 ETC_TXN_EQUIP_BRDN_COST,
 ETC_TXN_BRDN_COST,
 ETC_PRJ_LABOR_BRDN_COST,
 ETC_PRJ_EQUIP_BRDN_COST,
 ETC_PRJ_BRDN_COST,
 ETC_POU_LABOR_BRDN_COST,
 ETC_POU_EQUIP_BRDN_COST,
 ETC_POU_BRDN_COST,
 ACT_TXN_RAW_COST,
 ACT_PRJ_RAW_COST,
 ACT_POU_RAW_COST,
 ETC_TXN_RAW_COST,
 ETC_PRJ_RAW_COST,
 ETC_POU_RAW_COST,
 ACT_TXN_LABOR_RAW_COST,
 ACT_TXN_EQUIP_RAW_COST,
 ACT_PRJ_LABOR_RAW_COST,
 ACT_PRJ_EQUIP_RAW_COST,
 ACT_POU_LABOR_RAW_COST,
 ACT_POU_EQUIP_RAW_COST,
 ETC_TXN_LABOR_RAW_COST,
 ETC_TXN_EQUIP_RAW_COST,
 ETC_PRJ_LABOR_RAW_COST,
 ETC_PRJ_EQUIP_RAW_COST,
 ETC_POU_LABOR_RAW_COST,
 ETC_POU_EQUIP_RAW_COST,
 ACT_POU_LABOR_BRDN_COST,
 ACT_POU_EQUIP_BRDN_COST,
 ACT_POU_BRDN_COST,
 ETC_TXN_LABOR_BRDN_COST,
 TXN_LPB_RAW_COST,
 TXN_LPB_BRDN_COST,
 TXN_LPB_LABOR_RAW_COST,
 TXN_LPB_LABOR_BRDN_COST,
 TXN_LPB_EQUIP_RAW_COST,
 TXN_LPB_EQUIP_BRDN_COST,
 PRJ_LPB_RAW_COST,
 PRJ_LPB_BRDN_COST,
 PRJ_LPB_LABOR_RAW_COST,
 PRJ_LPB_LABOR_BRDN_COST,
 PRJ_LPB_EQUIP_RAW_COST,
 PRJ_LPB_EQUIP_BRDN_COST,
 POU_LPB_RAW_COST,
 POU_LPB_BRDN_COST,
 POU_LPB_LABOR_RAW_COST,
 POU_LPB_LABOR_BRDN_COST,
 POU_LPB_EQUIP_RAW_COST,
 POU_LPB_EQUIP_BRDN_COST,
 LPB_LABOR_HOURS,
 LPB_EQUIP_HOURS,
 PERIOD_FLAG,
 MIN_START_DATE,
 MAX_END_DATE,
 P_RAW_COST,
 P_BRDN_COST,
 P_REVENUE,
 P_LBR_RAW_COST,
 P_LBR_BRDN_COST,
 P_EQP_RAW_COST,
 P_EQP_BRDN_COST,
 P_BASE_RAW_COST,
 P_BASE_BRDN_COST,
 P_BASE_LBR_RAW_COST,
 P_BASE_LBR_BRDN_COST,
 P_BASE_EQP_RAW_COST,
 P_BASE_EQP_BRDN_COST,
 P_LPB_RAW_COST,
 P_LPB_BRDN_COST,
 P_LPB_LBR_RAW_COST,
 P_LPB_LBR_BRDN_COST,
 P_LPB_EQP_RAW_COST,
 P_LPB_EQP_BRDN_COST,
 P_LBR_HOURS,
 P_EQP_HOURS,
 P_BASE_LBR_HOURS,
 P_BASE_EQP_HOURS,
 P_LPB_LBR_HOURS,
 P_LPB_EQP_HOURS,
 P_ACT_LBR_HOURS,
 P_ACT_EQP_HOURS,
 P_ACT_LBR_BRDN_COST,
 P_ACT_EQP_BRDN_COST,
 P_ACT_RAW_COST,
 P_ACT_BRDN_COST,
 P_ACT_LBR_RAW_COST,
 P_ACT_EQP_RAW_COST,
 P_ETC_EQP_HOURS,
 P_ETC_LBR_HOURS,
 P_ETC_RAW_COST,
 P_ETC_BRDN_COST,
 P_ETC_LBR_BRDN_COST,
 P_ETC_EQP_BRDN_COST,
 P_ETC_LBR_RAW_COST,
 P_ETC_EQP_RAW_COST
 FROM pji_fm_xbs_accum_tmp1;

Line: 409


  insert into PJI_SYSTEM_DEBUG_MSG
      (
        MESSAGE_ID,
        MESSAGE_LEVEL,
        MESSAGE_CONTEXT,
        MESSAGE_TEXT,
        MESSAGE_TYPE,
        MODULE,
        CREATED_BY,
        CREATION_DATE
      )
      values
      (
        PJI_SYSTEM_DEBUG_MSG_S.NEXTVAL,
        1,
        'AIA',
        substr(p_msg,1,3999),
        'OUT',
        substr(p_module,1,239),
        -1,
        sysdate
      );

Line: 454


			select  PA_FIN_PLAN_UTILS.Get_Fin_Plan_Level_Code(a.budget_version_id),
							a.resource_list_id
			into  l_level_code,l_resource_list_id
			from  pa_budget_versions a , pa_proj_fp_options b
			where a.project_id = p_project_id
			and a.budget_status_code = 'W'
			and a.current_working_flag = 'Y'
			and a.fin_plan_type_id  = b.fin_plan_type_id
                        and a.budget_version_id = b.fin_plan_version_id
			and b.fin_plan_option_level_code = 'PLAN_VERSION'
			and a.project_id = b.project_id
			and b.fin_plan_preference_code like '%COST%'
			and a.fin_plan_type_id = p_fin_plan_type_id
			and a.fin_plan_type_id <> 10 ;

Line: 479


			     SELECT PA_FIN_PLAN_UTILS.GET_OPTION_PLANNING_LEVEL(proj_fp_options_id,fin_plan_preference_code),
			            DECODE(all_resource_list_id,NULL, cost_resource_list_id,all_resource_list_id)
			     INTO  l_level_code,l_resource_list_id
			     FROM pa_proj_fp_options
			     WHERE fin_plan_type_id = p_fin_plan_type_id
			     	 and project_id = p_project_id
			       and fin_plan_option_level_code = 'PLAN_TYPE';

Line: 499


		     select  b.entry_level_code
		     INTO l_level_code
		     FROM PA_BUDGET_VERSIONS a , pa_budget_entry_methods b
		     where a.fin_plan_type_id is null
		     and a.project_id = p_project_id
		     and a.budget_status_code = 'W'
		     --and a.current_working_flag = 'Y'
		     and a.budget_type_code = p_budget_type
		     and b.budget_entry_method_code = a.budget_entry_method_code ;