APPS.PSP_ADJ_DRIVER dependencies on PSP_TEMP_ORIG_SUMLINES

Line 971: insert into PSP_TEMP_ORIG_SUMLINES (

967: orig_sumline_rec.array_acct_group_id(k):= k;
968: end loop;
969:
970: forall k in 1..orig_sumline_rec.array_run_id.count
971: insert into PSP_TEMP_ORIG_SUMLINES (
972: ELEMENT_TYPE_ID,
973: GL_CODE_COMBINATION_ID,
974: PROJECT_ID,
975: EXPENDITURE_ORGANIZATION_ID,

Line 1023: from psp_temp_orig_sumlines MAS

1019: orig_sumline_rec.array_attribute10(k));
1020:
1021: Update psp_temp_orig_lines LINE
1022: set LINE.acct_group_id = (select MAS.acct_group_id
1023: from psp_temp_orig_sumlines MAS
1024: where MAS.run_id = g_run_id and
1025: nvl(MAS.element_type_id,-9) = nvl(LINE.element_type_id,-9) and
1026: -- MAS.dr_cr_flag = LINE.dr_cr_flag and Commented for Bug 3625667
1027: nvl(MAS.gl_code_combination_id,-9) =

Line 1084: insert into PSP_TEMP_ORIG_SUMLINES (

1080: orig_sumline_rec.array_acct_group_id(k):= k;
1081: end loop;
1082:
1083: forall k in 1..orig_sumline_rec.array_run_id.count
1084: insert into PSP_TEMP_ORIG_SUMLINES (
1085: ELEMENT_GROUP_ID,
1086: GL_CODE_COMBINATION_ID,
1087: PROJECT_ID,
1088: EXPENDITURE_ORGANIZATION_ID,

Line 1135: from psp_temp_orig_sumlines MAS

1131: orig_sumline_rec.array_attribute9(k),
1132: orig_sumline_rec.array_attribute10(k));
1133: Update psp_temp_orig_lines LINE
1134: set LINE.acct_group_id = (select MAS.acct_group_id
1135: from psp_temp_orig_sumlines MAS
1136: where MAS.run_id = g_run_id and
1137: nvl(MAS.element_group_id,-9) = nvl(LINE.element_group_id,-9) and
1138: -- MAS.dr_cr_flag = LINE.dr_cr_flag and Commented for Bug 3625667
1139: nvl(MAS.gl_code_combination_id,-9) =

Line 1195: insert into PSP_TEMP_ORIG_SUMLINES (

1191: orig_sumline_rec.array_acct_group_id(k):= k;
1192: end loop;
1193:
1194: forall k in 1..orig_sumline_rec.array_run_id.count
1195: insert into PSP_TEMP_ORIG_SUMLINES (
1196: GL_CODE_COMBINATION_ID,
1197: PROJECT_ID,
1198: EXPENDITURE_ORGANIZATION_ID,
1199: EXPENDITURE_TYPE,

Line 1246: from psp_temp_orig_sumlines MAS

1242:
1243:
1244: Update psp_temp_orig_lines LINE
1245: set LINE.acct_group_id = (select MAS.acct_group_id
1246: from psp_temp_orig_sumlines MAS
1247: where MAS.run_id = g_run_id and
1248: -- MAS.dr_cr_flag = LINE.dr_cr_flag and Commented for bug 3625667
1249: nvl(MAS.gl_code_combination_id,-9) =
1250: nvl(LINE.gl_code_combination_id,-9) and

Line 3950: delete from psp_temp_orig_sumlines where run_id = p_run_id;

3946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3947: END IF;
3948:
3949: delete from psp_temp_orig_lines where run_id = p_run_id;
3950: delete from psp_temp_orig_sumlines where run_id = p_run_id;
3951: delete from psp_temp_dest_sumlines where run_id = p_run_id;
3952:
3953: -- 4992668
3954: psp_wf_adj_custom.prorate_dff_hook(p_batch_name,

Line 4040: delete from psp_temp_orig_sumlines;

4036: 1) These DELETE statements donot have proper COMMIT logic.
4037: 2) Doesnt check for proper run_id.
4038: 3) Non-performant SQLs.
4039: delete from psp_temp_orig_lines;
4040: delete from psp_temp_orig_sumlines;
4041: delete from psp_temp_dest_sumlines;
4042: End of comment for bug fix 4507892 *****/
4043: g_error_api_path := 'GENERATE_LINES:'||g_error_api_path||sqlerrm;
4044: fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,