APPS.PA_ORG_UTILS dependencies on PA_CC_TP_SCHEDULE_LINE_LKP

Line 334: --- Delete all rows from pa_cc_tp_schedule_line_lkp

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

Line 335: delete from pa_cc_tp_schedule_line_lkp;

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

Line 922: --- Delete all rows from pa_cc_tp_schedule_line_lkp

918: and info.org_information2 = 'Y');
919:
920: end if ;
921:
922: --- Delete all rows from pa_cc_tp_schedule_line_lkp
923: delete from pa_cc_tp_schedule_line_lkp;
924:
925: -------- for pa_org_hierarchy_denorm
926: open get_all_orgs;

Line 923: delete from pa_cc_tp_schedule_line_lkp;

919:
920: end if ;
921:
922: --- Delete all rows from pa_cc_tp_schedule_line_lkp
923: delete from pa_cc_tp_schedule_line_lkp;
924:
925: -------- for pa_org_hierarchy_denorm
926: open get_all_orgs;
927: loop

Line 1184: --- Delete all rows from pa_cc_tp_schedule_line_lkp

1180: and pa_org_use_type = 'EXPENDITURES'
1181: and inactive_date is null ; -- Bug Ref # 6367868
1182: end loop;
1183:
1184: --- Delete all rows from pa_cc_tp_schedule_line_lkp
1185: delete from pa_cc_tp_schedule_line_lkp;
1186:
1187: open c_get_all_orgs;
1188: loop

Line 1185: delete from pa_cc_tp_schedule_line_lkp;

1181: and inactive_date is null ; -- Bug Ref # 6367868
1182: end loop;
1183:
1184: --- Delete all rows from pa_cc_tp_schedule_line_lkp
1185: delete from pa_cc_tp_schedule_line_lkp;
1186:
1187: open c_get_all_orgs;
1188: loop
1189: fetch c_get_all_orgs into l_parent_org_id;

Line 1288: --- Delete all rows from pa_cc_tp_schedule_line_lkp

1284:
1285: l_parent_org_id number;
1286:
1287: Begin
1288: --- Delete all rows from pa_cc_tp_schedule_line_lkp
1289: delete from pa_cc_tp_schedule_line_lkp;
1290:
1291: if x_org_information1 = 'PA_PROJECT_ORG' AND
1292: x_org_information_context = 'CLASS' then

Line 1289: delete from pa_cc_tp_schedule_line_lkp;

1285: l_parent_org_id number;
1286:
1287: Begin
1288: --- Delete all rows from pa_cc_tp_schedule_line_lkp
1289: delete from pa_cc_tp_schedule_line_lkp;
1290:
1291: if x_org_information1 = 'PA_PROJECT_ORG' AND
1292: x_org_information_context = 'CLASS' then
1293: if x_org_information2 = 'Y' then

Line 2244: --- Delete all rows from pa_cc_tp_schedule_line_lkp

2240: x_err_code := 0;
2241: old_stack := x_err_stack;
2242: x_err_stack := x_err_stack || 'populate_hierarchy_denorm';
2243:
2244: --- Delete all rows from pa_cc_tp_schedule_line_lkp
2245: delete from pa_cc_tp_schedule_line_lkp;
2246:
2247: ------- Acquire a lock before processing ----------------
2248:

Line 2245: delete from pa_cc_tp_schedule_line_lkp;

2241: old_stack := x_err_stack;
2242: x_err_stack := x_err_stack || 'populate_hierarchy_denorm';
2243:
2244: --- Delete all rows from pa_cc_tp_schedule_line_lkp
2245: delete from pa_cc_tp_schedule_line_lkp;
2246:
2247: ------- Acquire a lock before processing ----------------
2248:
2249: if (pa_debug.acquire_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0)

Line 2583: --- Delete all rows from pa_cc_tp_schedule_line_lkp

2579: x_err_code := 0;
2580: old_stack := x_err_stack;
2581: x_err_stack := x_err_stack || 'populate_hierarchy_denorm';
2582:
2583: --- Delete all rows from pa_cc_tp_schedule_line_lkp
2584: delete from pa_cc_tp_schedule_line_lkp;
2585:
2586: ------- Acquire a lock before processing ----------------
2587:

Line 2584: delete from pa_cc_tp_schedule_line_lkp;

2580: old_stack := x_err_stack;
2581: x_err_stack := x_err_stack || 'populate_hierarchy_denorm';
2582:
2583: --- Delete all rows from pa_cc_tp_schedule_line_lkp
2584: delete from pa_cc_tp_schedule_line_lkp;
2585:
2586: ------- Acquire a lock before processing ----------------
2587:
2588: IF (pa_debug.acquire_user_lock('FCLOCK:'||to_char(p_org_version_id)) = 0) AND