APPS.PA_ORG_UTILS dependencies on PA_CC_TP_SCHEDULE_LINE_LKP

Line 337: --- Delete all rows from pa_cc_tp_schedule_line_lkp

333: )
334: );
335: end if;
336:
337: --- Delete all rows from pa_cc_tp_schedule_line_lkp
338: delete from pa_cc_tp_schedule_line_lkp;
339:
340: --- changes for pa_org_hierarchy_denorm table
341: if (nvl(x_old_proj_start_org_id,x_new_proj_start_org_id +1) <> x_new_proj_start_org_id ) then

Line 338: delete from pa_cc_tp_schedule_line_lkp;

334: );
335: end if;
336:
337: --- Delete all rows from pa_cc_tp_schedule_line_lkp
338: delete from pa_cc_tp_schedule_line_lkp;
339:
340: --- changes for pa_org_hierarchy_denorm table
341: if (nvl(x_old_proj_start_org_id,x_new_proj_start_org_id +1) <> x_new_proj_start_org_id ) then
342: ---- start org is changed, update only if org is moved up

Line 1050: --- Delete all rows from pa_cc_tp_schedule_line_lkp

1046: and info.org_information2 = 'Y');
1047:
1048: end if ;
1049:
1050: --- Delete all rows from pa_cc_tp_schedule_line_lkp
1051: delete from pa_cc_tp_schedule_line_lkp;
1052:
1053: -------- for pa_org_hierarchy_denorm
1054: /* open get_all_orgs;

Line 1051: delete from pa_cc_tp_schedule_line_lkp;

1047:
1048: end if ;
1049:
1050: --- Delete all rows from pa_cc_tp_schedule_line_lkp
1051: delete from pa_cc_tp_schedule_line_lkp;
1052:
1053: -------- for pa_org_hierarchy_denorm
1054: /* open get_all_orgs;
1055: loop

Line 1390: --- Delete all rows from pa_cc_tp_schedule_line_lkp

1386: and pa_org_use_type = 'EXPENDITURES'
1387: and inactive_date is null ; -- Bug Ref # 6367868
1388: end loop;
1389:
1390: --- Delete all rows from pa_cc_tp_schedule_line_lkp
1391: delete from pa_cc_tp_schedule_line_lkp;
1392:
1393: open c_get_all_orgs;
1394: loop

Line 1391: delete from pa_cc_tp_schedule_line_lkp;

1387: and inactive_date is null ; -- Bug Ref # 6367868
1388: end loop;
1389:
1390: --- Delete all rows from pa_cc_tp_schedule_line_lkp
1391: delete from pa_cc_tp_schedule_line_lkp;
1392:
1393: open c_get_all_orgs;
1394: loop
1395: fetch c_get_all_orgs into l_parent_org_id;

Line 1494: --- Delete all rows from pa_cc_tp_schedule_line_lkp

1490:
1491: l_parent_org_id number;
1492:
1493: Begin
1494: --- Delete all rows from pa_cc_tp_schedule_line_lkp
1495: delete from pa_cc_tp_schedule_line_lkp;
1496:
1497: if x_org_information1 = 'PA_PROJECT_ORG' AND
1498: x_org_information_context = 'CLASS' then

Line 1495: delete from pa_cc_tp_schedule_line_lkp;

1491: l_parent_org_id number;
1492:
1493: Begin
1494: --- Delete all rows from pa_cc_tp_schedule_line_lkp
1495: delete from pa_cc_tp_schedule_line_lkp;
1496:
1497: if x_org_information1 = 'PA_PROJECT_ORG' AND
1498: x_org_information_context = 'CLASS' then
1499: if x_org_information2 = 'Y' then

Line 2451: --- Delete all rows from pa_cc_tp_schedule_line_lkp

2447: x_err_code := 0;
2448: old_stack := x_err_stack;
2449: x_err_stack := x_err_stack || 'populate_hierarchy_denorm';
2450:
2451: --- Delete all rows from pa_cc_tp_schedule_line_lkp
2452: delete from pa_cc_tp_schedule_line_lkp;
2453:
2454: ------- Acquire a lock before processing ----------------
2455:

Line 2452: delete from pa_cc_tp_schedule_line_lkp;

2448: old_stack := x_err_stack;
2449: x_err_stack := x_err_stack || 'populate_hierarchy_denorm';
2450:
2451: --- Delete all rows from pa_cc_tp_schedule_line_lkp
2452: delete from pa_cc_tp_schedule_line_lkp;
2453:
2454: ------- Acquire a lock before processing ----------------
2455:
2456: if (pa_debug.acquire_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0)

Line 2790: --- Delete all rows from pa_cc_tp_schedule_line_lkp

2786: x_err_code := 0;
2787: old_stack := x_err_stack;
2788: x_err_stack := x_err_stack || 'populate_hierarchy_denorm';
2789:
2790: --- Delete all rows from pa_cc_tp_schedule_line_lkp
2791: delete from pa_cc_tp_schedule_line_lkp;
2792:
2793: ------- Acquire a lock before processing ----------------
2794:

Line 2791: delete from pa_cc_tp_schedule_line_lkp;

2787: old_stack := x_err_stack;
2788: x_err_stack := x_err_stack || 'populate_hierarchy_denorm';
2789:
2790: --- Delete all rows from pa_cc_tp_schedule_line_lkp
2791: delete from pa_cc_tp_schedule_line_lkp;
2792:
2793: ------- Acquire a lock before processing ----------------
2794:
2795: IF (pa_debug.acquire_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0) AND