DBA Data[Home] [Help]

APPS.PJI_FM_SUM_ACT dependencies on PJI_UTILS

Line 29: PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),

25: 'CURRENT_BATCH'
26: );
27:
28: l_min_date := to_number(to_char(to_date(
29: PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),
30: PJI_FM_SUM_MAIN.g_date_mask), 'J'));
31:
32: insert /*+ append parallel(act1_i) */ into PJI_FM_AGGR_ACT1 act1_i
33: (

Line 821: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

817:
818: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_FM_SUM_ACT.BASE_SUMMARY(p_worker_id);');
819:
820: -- truncate intermediate tables no longer required
821: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
822: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_FUNDG' , 'NORMAL',null);
823: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DREVN' , 'NORMAL',null);
824: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVC' , 'NORMAL',null);
825: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_EXTR_DINVCITM' , 'NORMAL',null);

Line 842: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

838: l_schema varchar2(30);
839:
840: begin
841:
842: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
843:
844: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( l_schema , 'PJI_FM_AGGR_ACT1', 'NORMAL',null);
845:
846: end CLEANUP;