APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PJI_PJP_SUM_MAIN

Line 241: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(g_worker_id);

237: RETURN;
238: END IF;
239:
240: /* Added for bug#5728852 - START */
241: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(g_worker_id);
242: l_rbs_header_id := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,'RBS_HEADER_ID');
243: /* Added for bug#5728852 - END */
244:
245: IF (p_context = 'RBS' AND p_rbs_version_id IS NULL) THEN

Line 504: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(g_worker_id); -- Bug#5099574

500: ELSIF (p_context = 'PLANTYPE') THEN
501:
502: l_plan_type_id := p_plan_type_id;
503: l_rbs_version_id := NULL;
504: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(g_worker_id); -- Bug#5099574
505: l_refresh_code := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER (l_process, 'REFRESH_CODE'); -- Bug#5099574
506:
507: -- Bug# 5208322 : the workplan plan_type_id is stored in l_workplan_type_id
508: begin

Line 5459: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(g_worker_id);

5455: ( p_package_name => g_package_name
5456: , x_return_status => x_return_status ) ;
5457:
5458: --Bug 6047966.
5459: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(g_worker_id);
5460: l_plan_ver_type_code := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'PLAN_VERSION');
5461:
5462: DELETE FROM pji_fm_extr_plan_lines
5463: WHERE (project_id, plan_version_id) IN

Line 12652: l_process := PJI_PJP_SUM_MAIN.g_process || g_worker_id; /* Added for bug 7551819 */

12648: else
12649:
12650: print_time ( 'SAM MERGE_INTO_FP_FACTS worker id..' || g_worker_id || ' sysdate ' || sysdate) ;
12651:
12652: l_process := PJI_PJP_SUM_MAIN.g_process || g_worker_id; /* Added for bug 7551819 */
12653:
12654: select count(*) into l_rec_exist -- Start for bug 14636607
12655: from pji_fp_xbs_accum_f
12656: where rownum=1;

Line 13240: l_process := PJI_PJP_SUM_MAIN.g_process || g_worker_id; /* Added for bug 7551819 */

13236: where worker_id = g_worker_id;
13237: BEGIN
13238:
13239: print_time ( 'SAM INSERT_INTO_FP_FACTS worker id..' || g_worker_id || ' sysdate ' || sysdate) ;
13240: l_process := PJI_PJP_SUM_MAIN.g_process || g_worker_id; /* Added for bug 7551819 */
13241:
13242: open c1;
13243: loop
13244:

Line 13616: l_process := PJI_PJP_SUM_MAIN.g_process || g_worker_id; /* Added for bug 8416116 */

13612: where batch_id = x_batch_id;
13613:
13614: BEGIN
13615:
13616: l_process := PJI_PJP_SUM_MAIN.g_process || g_worker_id; /* Added for bug 8416116 */
13617:
13618: MERGE INTO PJI_FP_XBS_ACCUM_F fact
13619: USING ( SELECT
13620: tmp.worker_id