[Home] [Help]
375: DECODE(g_dff_grouping_option, 'Y', attribute7, NULL) attribute7,
376: DECODE(g_dff_grouping_option, 'Y', attribute8, NULL) attribute8,
377: DECODE(g_dff_grouping_option, 'Y', attribute9, NULL) attribute9,
378: DECODE(g_dff_grouping_option, 'Y', attribute10, NULL) attribute10
379: from PSP_TEMP_ORIG_LINES
380: where RUN_ID = g_run_id
381: group by RUN_ID,
382: SET_OF_BOOKS_ID,
383: BUSINESS_GROUP_ID,
425: DECODE(g_dff_grouping_option, 'Y', attribute7, NULL) attribute7,
426: DECODE(g_dff_grouping_option, 'Y', attribute8, NULL) attribute8,
427: DECODE(g_dff_grouping_option, 'Y', attribute9, NULL) attribute9,
428: DECODE(g_dff_grouping_option, 'Y', attribute10, NULL) attribute10
429: from PSP_TEMP_ORIG_LINES
430: where RUN_ID = g_run_id
431: and element_group_id IS NOT NULL
432: group by RUN_ID,
433: SET_OF_BOOKS_ID,
475: DECODE(g_dff_grouping_option, 'Y', attribute7, NULL) attribute7,
476: DECODE(g_dff_grouping_option, 'Y', attribute8, NULL) attribute8,
477: DECODE(g_dff_grouping_option, 'Y', attribute9, NULL) attribute9,
478: DECODE(g_dff_grouping_option, 'Y', attribute10, NULL) attribute10
479: from PSP_TEMP_ORIG_LINES
480: where RUN_ID = g_run_id
481: group by RUN_ID,
482: SET_OF_BOOKS_ID,
483: BUSINESS_GROUP_ID,
573:
574: if orig_line_rec.array_distribution_line_id.count > 0 then
575: l_loop_count := l_loop_count + orig_line_rec.array_distribution_line_id.count;
576: FORALL i IN 1..orig_line_rec.array_distribution_line_id.count
577: insert into psp_temp_orig_lines(
578: element_type_id,
579: element_group_id,
580: gl_code_combination_id,
581: project_id,
701:
702: if orig_line_rec.array_distribution_line_id.count > 0 then
703: l_loop_count := l_loop_count + orig_line_rec.array_distribution_line_id.count;
704: FORALL i IN 1..orig_line_rec.array_distribution_line_id.count
705: insert into psp_temp_orig_lines(
706: element_type_id,
707: element_group_id,
708: gl_code_combination_id,
709: project_id,
829:
830: if orig_line_rec.array_distribution_line_id.count > 0 then
831: l_loop_count := l_loop_count + orig_line_rec.array_distribution_line_id.count;
832: FORALL i IN 1..orig_line_rec.array_distribution_line_id.count
833: insert into psp_temp_orig_lines(
834: element_type_id,
835: element_group_id,
836: gl_code_combination_id,
837: project_id,
1011: orig_sumline_rec.array_attribute8(k),
1012: orig_sumline_rec.array_attribute9(k),
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
1123: orig_sumline_rec.array_attribute7(k),
1124: orig_sumline_rec.array_attribute8(k),
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
1234: orig_sumline_rec.array_attribute9(k),
1235: orig_sumline_rec.array_attribute10(k));
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
2840: PTOS.time_period_id,
2841: Sum(decode (PTOS.dr_cr_flag, 'D', PTOS.distribution_amount,
2842: -PTOS.distribution_amount))
2843: from psp_temp_dest_sumlines PTDS,
2844: psp_temp_orig_lines PTOS
2845: where PTDS.original_line_flag = 'Y'
2846: and PTDS.acct_group_id = PTOS.acct_group_id
2847: and PTDS.run_id = g_run_id
2848: and PTOS.run_id = g_run_id
3237: ptds.attribute7,
3238: ptds.attribute8,
3239: ptds.attribute9,
3240: ptds.attribute10
3241: from psp_temp_orig_lines ptol, psp_temp_dest_sumlines ptds
3242: where ptol.business_group_id = p_business_group_id
3243: and ptol.set_of_books_id = p_set_of_books_id
3244: and ptol.business_group_id = ptds.business_group_id
3245: and ptol.set_of_books_id = ptds.set_of_books_id
3417: dest.attribute9,
3418: dest.attribute10
3419: from psp_temp_dest_sumlines ORIG,
3420: psp_temp_dest_sumlines DEST,
3421: psp_temp_orig_lines LINES,
3422: -- Introduced the following for bug fix 3892097
3423: per_time_periods ptp,
3424: (SELECT adj_set_number,
3425: COUNT(DISTINCT DECODE(gl_code_combination_id, NULL, 'P', 'G')) transaction_type_count
3936: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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
4026: /***** Commented the following DELETE statements for the following reasons as part of R12 performance fixes (bug 4507892)
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;
4450: r_eff_date_record eff_date_rec_type;
4451:
4452: CURSOR c_orig_values IS
4453: SELECT MAX(ptol.effective_date)
4454: FROM psp_temp_orig_lines ptol
4455: WHERE ptol.acct_group_id = p_acct_group_id
4456: AND ptol.run_id = p_run_id
4457: GROUP BY payroll_control_id,
4458: dr_cr_flag;