APPS.PSP_ADJ_DRIVER dependencies on PSP_TEMP_ORIG_SUMLINES

Line 965: insert into PSP_TEMP_ORIG_SUMLINES (

961: orig_sumline_rec.array_acct_group_id(k):= k;
962: end loop;
963:
964: forall k in 1..orig_sumline_rec.array_run_id.count
965: insert into PSP_TEMP_ORIG_SUMLINES (
966: ELEMENT_TYPE_ID,
967: GL_CODE_COMBINATION_ID,
968: PROJECT_ID,
969: EXPENDITURE_ORGANIZATION_ID,

Line 1017: from psp_temp_orig_sumlines MAS

1013: orig_sumline_rec.array_attribute10(k));
1014:
1015: Update psp_temp_orig_lines LINE
1016: set LINE.acct_group_id = (select MAS.acct_group_id
1017: from psp_temp_orig_sumlines MAS
1018: where MAS.run_id = g_run_id and
1019: nvl(MAS.element_type_id,-9) = nvl(LINE.element_type_id,-9) and
1020: -- MAS.dr_cr_flag = LINE.dr_cr_flag and Commented for Bug 3625667
1021: nvl(MAS.gl_code_combination_id,-9) =

Line 1078: insert into PSP_TEMP_ORIG_SUMLINES (

1074: orig_sumline_rec.array_acct_group_id(k):= k;
1075: end loop;
1076:
1077: forall k in 1..orig_sumline_rec.array_run_id.count
1078: insert into PSP_TEMP_ORIG_SUMLINES (
1079: ELEMENT_GROUP_ID,
1080: GL_CODE_COMBINATION_ID,
1081: PROJECT_ID,
1082: EXPENDITURE_ORGANIZATION_ID,

Line 1129: from psp_temp_orig_sumlines MAS

1125: orig_sumline_rec.array_attribute9(k),
1126: orig_sumline_rec.array_attribute10(k));
1127: Update psp_temp_orig_lines LINE
1128: set LINE.acct_group_id = (select MAS.acct_group_id
1129: from psp_temp_orig_sumlines MAS
1130: where MAS.run_id = g_run_id and
1131: nvl(MAS.element_group_id,-9) = nvl(LINE.element_group_id,-9) and
1132: -- MAS.dr_cr_flag = LINE.dr_cr_flag and Commented for Bug 3625667
1133: nvl(MAS.gl_code_combination_id,-9) =

Line 1189: insert into PSP_TEMP_ORIG_SUMLINES (

1185: orig_sumline_rec.array_acct_group_id(k):= k;
1186: end loop;
1187:
1188: forall k in 1..orig_sumline_rec.array_run_id.count
1189: insert into PSP_TEMP_ORIG_SUMLINES (
1190: GL_CODE_COMBINATION_ID,
1191: PROJECT_ID,
1192: EXPENDITURE_ORGANIZATION_ID,
1193: EXPENDITURE_TYPE,

Line 1240: from psp_temp_orig_sumlines MAS

1236:
1237:
1238: Update psp_temp_orig_lines LINE
1239: set LINE.acct_group_id = (select MAS.acct_group_id
1240: from psp_temp_orig_sumlines MAS
1241: where MAS.run_id = g_run_id and
1242: -- MAS.dr_cr_flag = LINE.dr_cr_flag and Commented for bug 3625667
1243: nvl(MAS.gl_code_combination_id,-9) =
1244: nvl(LINE.gl_code_combination_id,-9) and

Line 3941: delete from psp_temp_orig_sumlines where run_id = p_run_id;

3937: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3938: END IF;
3939:
3940: delete from psp_temp_orig_lines where run_id = p_run_id;
3941: delete from psp_temp_orig_sumlines where run_id = p_run_id;
3942: delete from psp_temp_dest_sumlines where run_id = p_run_id;
3943:
3944: -- 4992668
3945: psp_wf_adj_custom.prorate_dff_hook(p_batch_name,

Line 4031: delete from psp_temp_orig_sumlines;

4027: 1) These DELETE statements donot have proper COMMIT logic.
4028: 2) Doesnt check for proper run_id.
4029: 3) Non-performant SQLs.
4030: delete from psp_temp_orig_lines;
4031: delete from psp_temp_orig_sumlines;
4032: delete from psp_temp_dest_sumlines;
4033: End of comment for bug fix 4507892 *****/
4034: g_error_api_path := 'GENERATE_LINES:'||g_error_api_path||sqlerrm;
4035: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,