DBA Data[Home] [Help]

APPS.PJI_FM_SUM_PSI dependencies on PJI_PJP_SUM_MAIN

Line 3554: PJI_PJP_SUM_MAIN.INIT_PROCESS(l_worker_id,

3550:
3551: commit;
3552:
3553: BEGIN
3554: PJI_PJP_SUM_MAIN.INIT_PROCESS(l_worker_id,
3555: 'P',
3556: l_operating_unit,
3557: null,
3558: null,

Line 3664: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;

3660: l_extraction_type varchar2(15);
3661:
3662: begin
3663:
3664: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;
3665:
3666: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_ROWID_TABLE(p_worker_id);')) then
3667: return;
3668: end if;

Line 3762: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;

3758: l_extraction_type varchar2(15);
3759:
3760: begin
3761:
3762: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;
3763:
3764: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_UPDATE_DELTA(p_worker_id);')) then
3765: return;
3766: end if;

Line 3961: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;

3957: l_extraction_type varchar2(15);
3958:
3959: begin
3960:
3961: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;
3962:
3963: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_INSERT_DELTA(p_worker_id);')) then
3964: return;
3965: end if;

Line 4130: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;

4126: l_extraction_type varchar2(15);
4127:
4128: begin
4129:
4130: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;
4131:
4132: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.PURGE_INCREMENTAL_BALANCES(p_worker_id);')) then
4133: return;
4134: end if;

Line 4174: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;

4170: l_extraction_type varchar2(30);
4171:
4172: begin
4173:
4174: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;
4175:
4176: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.PURGE_BALANCES_CMT(p_worker_id);')) then
4177: return;
4178: end if;

Line 4229: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;

4225: l_extraction_type varchar2(15);
4226:
4227: begin
4228:
4229: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;
4230:
4231: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.BALANCES_INSERT_DELTA_CMT(p_worker_id);')) then
4232: return;
4233: end if;

Line 4370: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;

4366: l_extraction_type varchar2(15);
4367:
4368: begin
4369:
4370: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;
4371:
4372: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.ACT_ROWID_TABLE(p_worker_id);')) then
4373: return;
4374: end if;

Line 4420: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;

4416: l_extraction_type varchar2(30);
4417:
4418: begin
4419:
4420: l_process := PJI_PJP_SUM_MAIN.g_process || p_worker_id;
4421:
4422: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_FM_SUM_PSI.PURGE_BALANCES_ACT(p_worker_id);')) then
4423: return;
4424: end if;