eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PSP_SUM_TRANS dependencies on PSP_PRE_GEN_DIST_LINES

Line 532: DELETE FROM psp_pre_gen_dist_lines

528: END IF;
529: ELSIF payroll_control_rec.source_type = 'P' THEN
530:
531: -- delete the zero amount reversal lines
532: DELETE FROM psp_pre_gen_dist_lines
533: WHERE distribution_amount = 0
534: AND reversal_entry_flag = 'Y'
535: AND payroll_control_id = payroll_control_rec.payroll_control_id;
536:

Line 539: FROM psp_pre_gen_dist_lines ppgd

535: AND payroll_control_id = payroll_control_rec.payroll_control_id;
536:
537: SELECT count(*)
538: INTO l_line_counter
539: FROM psp_pre_gen_dist_lines ppgd
540: WHERE ppgd.payroll_control_id = payroll_control_rec.payroll_control_id;
541:
542: IF l_line_counter = 0 THEN
543: /* commented for 2445196

Line 679: FROM psp_pre_gen_dist_lines ppg,

675: DECODE(g_dff_grouping_option, 'Y', DECODE(ppg.suspense_org_account_id, NULL, ppg.attribute8, pos.attribute8), NULL) attribute8,
676: DECODE(g_dff_grouping_option, 'Y', DECODE(ppg.suspense_org_account_id, NULL, ppg.attribute9, pos.attribute9), NULL) attribute9,
677: DECODE(g_dff_grouping_option, 'Y', DECODE(ppg.suspense_org_account_id, NULL, ppg.attribute10, pos.attribute10), NULL) attribute10
678: ---decode(ppg.suspense_org_Account_id, NULL, 'N', 'Y') Suspense_Flag commented for 2663344
679: FROM psp_pre_gen_dist_lines ppg,
680: psp_organization_accounts pos,
681: psp_payroll_controls ppc
682: WHERE ppg.status_code = 'N'
683: /* changed following condition for bug 2007521 */

Line 930: UPDATE psp_pre_gen_dist_lines

926: IF gl_sum_lines_rec.tab_flag = 'D' THEN
927: UPDATE psp_distribution_lines
928: SET summary_line_id = l_summary_line_id WHERE distribution_line_id = l_dist_line_id;
929: ELSIF gl_sum_lines_rec.tab_flag = 'P' THEN
930: UPDATE psp_pre_gen_dist_lines
931: SET summary_line_id = l_summary_line_id WHERE pre_gen_dist_line_id = l_dist_line_id;
932: END IF;
933: END LOOP;
934:

Line 1022: UPDATE psp_pre_gen_dist_lines

1018: SET summary_line_id = l_summary_line_id,
1019: status_code = 'N'
1020: WHERE distribution_line_id = l_dist_line_id;
1021: ELSIF gl_sum_lines_rec.tab_flag = 'P' THEN
1022: UPDATE psp_pre_gen_dist_lines
1023: SET summary_line_id = l_summary_line_id,
1024: status_code = 'N'
1025: WHERE pre_gen_dist_line_id = l_dist_line_id;
1026: END IF;

Line 1737: FROM psp_pre_gen_dist_lines ppgd

1733: ppgd.distribution_date,
1734: ppgd.suspense_org_account_id,
1735: ppgd.reversal_entry_flag,
1736: ppgd.effective_date -- Bug 7040943 Added
1737: FROM psp_pre_gen_dist_lines ppgd
1738: WHERE ppgd.summary_line_id = p_summary_line_id;
1739:
1740: -- Get the Organization details ...
1741:

Line 1769: psp_pre_gen_dist_lines ppgd

1765: UNION
1766: SELECT hou.organization_id, hou.name
1767: FROM hr_all_organization_units hou,
1768: per_assignments_f paf,
1769: psp_pre_gen_dist_lines ppgd
1770: WHERE ppgd.pre_gen_dist_line_id = p_line_id
1771: AND ppgd.assignment_id = paf.assignment_id
1772: AND ppgd.distribution_date BETWEEN paf.effective_start_date AND paf.effective_end_date
1773: AND paf.organization_id = hou.organization_id;

Line 1892: from psp_pre_gen_dist_lines ppg

1888: union all
1889: select ppg.element_type_id,
1890: ppg.assignment_id,
1891: ppg.person_id
1892: from psp_pre_gen_dist_lines ppg
1893: where pre_gen_dist_line_id = x_line_id;
1894:
1895: cursor get_asg_details is
1896: select ppf.full_name,

Line 2228: UPDATE psp_pre_gen_dist_lines

2224: suspense_auto_glccid = l_new_glccid, --- added suspense_auto for 5080403
2225: suspense_auto_exp_type = l_new_expenditure_type
2226: WHERE rowid = l_rowid;
2227: ELSIF p_source_type = 'P' THEN
2228: UPDATE psp_pre_gen_dist_lines
2229: SET suspense_org_account_id = l_organization_account_id,
2230: suspense_reason_code = 'ST:' || l_status,
2231: status_code = 'N',
2232: effective_date = l_effective_date, --- for Bug 2663344

Line 2282: UPDATE psp_pre_gen_dist_lines

2278: FROM psp_summary_lines
2279: WHERE payroll_control_id = p_payroll_control_id);
2280: ELSIF p_source_type = 'P' THEN
2281:
2282: UPDATE psp_pre_gen_dist_lines
2283: SET suspense_org_account_id = NULL,
2284: suspense_reason_code = NULL,
2285: effective_date = decode(NVL(gl_code_combination_id,-999),gl_code_combination_id,
2286: p_period_end_date,distribution_date)

Line 2339: UPDATE psp_pre_gen_dist_lines

2335: IN (SELECT summary_line_id
2336: FROM psp_summary_lines
2337: WHERE payroll_control_id = p_payroll_control_id );
2338: ELSIF p_source_type = 'P' THEN
2339: UPDATE psp_pre_gen_dist_lines
2340: SET suspense_org_account_id = NULL,
2341: suspense_reason_code = NULL,
2342: effective_date = decode(NVL(gl_code_combination_id,-999),gl_code_combination_id,
2343: p_period_end_date,distribution_date)

Line 2464: UPDATE psp_pre_gen_dist_lines

2460: AND summary_line_id = l_summary_line_id;
2461:
2462: ELSIF p_source_type = 'P' THEN
2463:
2464: UPDATE psp_pre_gen_dist_lines
2465: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
2466:
2467: -- move the transferred records to psp_pre_gen_dist_lines_history
2468: -- Introduced DFF columns for bug fix 2908859

Line 2467: -- move the transferred records to psp_pre_gen_dist_lines_history

2463:
2464: UPDATE psp_pre_gen_dist_lines
2465: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
2466:
2467: -- move the transferred records to psp_pre_gen_dist_lines_history
2468: -- Introduced DFF columns for bug fix 2908859
2469: INSERT INTO psp_pre_gen_dist_lines_history
2470: (pre_gen_dist_line_id,distribution_interface_id,person_id,assignment_id,
2471: element_type_id,distribution_date,effective_date,distribution_amount,

Line 2469: INSERT INTO psp_pre_gen_dist_lines_history

2465: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
2466:
2467: -- move the transferred records to psp_pre_gen_dist_lines_history
2468: -- Introduced DFF columns for bug fix 2908859
2469: INSERT INTO psp_pre_gen_dist_lines_history
2470: (pre_gen_dist_line_id,distribution_interface_id,person_id,assignment_id,
2471: element_type_id,distribution_date,effective_date,distribution_amount,
2472: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,
2473: batch_name,status_code,set_of_books_id,

Line 2494: FROM psp_pre_gen_dist_lines

2490: attribute_category, attribute1, attribute2, attribute3,
2491: attribute4, attribute5, attribute6, attribute7,
2492: attribute8, attribute9, attribute10,
2493: suspense_auto_exp_type, suspense_auto_glccid
2494: FROM psp_pre_gen_dist_lines
2495: WHERE status_code = 'A'
2496: AND summary_line_id = l_summary_line_id;
2497:
2498: DELETE FROM psp_pre_gen_dist_lines

Line 2498: DELETE FROM psp_pre_gen_dist_lines

2494: FROM psp_pre_gen_dist_lines
2495: WHERE status_code = 'A'
2496: AND summary_line_id = l_summary_line_id;
2497:
2498: DELETE FROM psp_pre_gen_dist_lines
2499: WHERE status_code = 'A'
2500: AND summary_line_id = l_summary_line_id;
2501:
2502: END IF;

Line 2595: FROM psp_pre_gen_dist_lines ppgd,

2591: ppgd.batch_name,
2592: ppgd.set_of_books_id,
2593: ppgd.business_group_id,
2594: round(sum(ppgd.distribution_amount), p_precision) reversal_dist_amount -- For Bug 2916848 changed to p_precision
2595: FROM psp_pre_gen_dist_lines ppgd,
2596: psp_organization_accounts pos
2597: WHERE ppgd.payroll_control_id = p_payroll_control_id
2598: AND nvl(ppgd.reversal_entry_flag,'N') = 'N'
2599: AND ((ppgd.gl_code_combination_id IS NOT NULL and pos.project_id is null ) OR -- Bug 2007521 Changed condn

Line 2695: delete from psp_pre_gen_dist_lines

2691: fnd_msg_pub.add;
2692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2693: END;
2694:
2695: delete from psp_pre_gen_dist_lines
2696: where reversal_entry_flag = 'Y'
2697: and status_code = 'N'
2698: and source_type = 'P'
2699: and payroll_control_id = p_payroll_control_id;

Line 2711: -- UPDATE psp_pre_gen_dist_lines

2707: EXIT;
2708: END IF;
2709:
2710: -- Bug# 1140217
2711: -- UPDATE psp_pre_gen_dist_lines
2712: -- SET distribution_amount = pg_reversal_entry_rec.reversal_dist_amount
2713: -- WHERE distribution_interface_id = pg_reversal_entry_rec.distribution_interface_id
2714: -- AND reversal_entry_flag = 'Y';
2715:

Line 2717: insert into psp_pre_gen_dist_lines

2713: -- WHERE distribution_interface_id = pg_reversal_entry_rec.distribution_interface_id
2714: -- AND reversal_entry_flag = 'Y';
2715:
2716:
2717: insert into psp_pre_gen_dist_lines
2718: (pre_gen_dist_line_id, distribution_interface_id, person_id, assignment_id,
2719: element_type_id, distribution_date, effective_date, distribution_amount,
2720: dr_cr_flag, payroll_control_id, source_type, source_code, time_period_id,
2721: batch_name, status_code, set_of_books_id, business_group_id, gl_code_combination_id,

Line 2737: from psp_pre_gen_dist_lines ppgd, psp_organization_accounts pos

2733:
2734: select sum(decode(reversal_entry_flag, 'Y', distribution_amount, 0)),
2735: sum(decode(reversal_entry_flag, 'Y', 0, distribution_amount))
2736: into l_cr_amount, l_dr_amount
2737: from psp_pre_gen_dist_lines ppgd, psp_organization_accounts pos
2738: where payroll_control_id = p_payroll_control_id
2739: and ppgd.status_code = 'N'
2740: and ppgd.suspense_org_account_id = pos.organization_account_id(+)
2741: AND ((ppgd.gl_code_combination_id IS NOT NULL and ppgd.suspense_org_account_id is null ) OR

Line 3072: FROM psp_pre_gen_dist_lines ppg,

3068: DECODE(g_dff_grouping_option, 'Y', DECODE(ppg.suspense_org_account_id, NULL, ppg.attribute8, pos.attribute8), NULL) attribute8,
3069: DECODE(g_dff_grouping_option, 'Y', DECODE(ppg.suspense_org_account_id, NULL, ppg.attribute9, pos.attribute9), NULL) attribute9,
3070: DECODE(g_dff_grouping_option, 'Y', DECODE(ppg.suspense_org_account_id, NULL, ppg.attribute10, pos.attribute10), NULL) attribute10
3071: ---decode(ppg.suspense_org_Account_id, NULL, 'N', 'Y') Suspense_Flag commented for 2663344
3072: FROM psp_pre_gen_dist_lines ppg,
3073: psp_organization_accounts pos,
3074: psp_payroll_controls ppc
3075: WHERE ppg.status_code = 'N'
3076: /* changed following condn. First Pass can have suspense: Bug 2007521 */

Line 3335: UPDATE psp_pre_gen_dist_lines

3331: IF gms_sum_lines_rec.tab_flag = 'D' THEN
3332: UPDATE psp_distribution_lines
3333: SET summary_line_id = l_summary_line_id WHERE distribution_line_id = l_dist_line_id;
3334: ELSIF gms_sum_lines_rec.tab_flag = 'P' THEN
3335: UPDATE psp_pre_gen_dist_lines
3336: SET summary_line_id = l_summary_line_id WHERE pre_gen_dist_line_id = l_dist_line_id;
3337: END IF;
3338: END LOOP;
3339:

Line 3438: UPDATE psp_pre_gen_dist_lines

3434: SET summary_line_id = l_summary_line_id,
3435: status_code = 'N'
3436: WHERE distribution_line_id = l_dist_line_id;
3437: ELSIF gms_sum_lines_rec.tab_flag = 'P' THEN
3438: UPDATE psp_pre_gen_dist_lines
3439: SET summary_line_id = l_summary_line_id,
3440: status_code = 'N'
3441: WHERE pre_gen_dist_line_id = l_dist_line_id;
3442: END IF;

Line 4080: FROM psp_pre_gen_dist_lines ppgd

4076: SELECT ppgd.rowid,
4077: ppgd.pre_gen_dist_line_id line_id,
4078: ppgd.distribution_date,
4079: ppgd.suspense_org_account_id
4080: FROM psp_pre_gen_dist_lines ppgd
4081: WHERE ppgd.summary_line_id = p_summary_line_id;
4082:
4083: CURSOR get_susp_org_cur1 (P_ORG_ID IN VARCHAR2) IS
4084: SELECT hou.organization_id, hou.name

Line 4108: psp_pre_gen_dist_lines ppgdl

4104: UNION
4105: SELECT hou.organization_id, hou.name
4106: FROM hr_all_organization_units hou,
4107: per_assignments_f paf,
4108: psp_pre_gen_dist_lines ppgdl
4109: WHERE paf.assignment_id = ppgdl.assignment_id
4110: AND hou.organization_id = paf.organization_id
4111: AND ppgdl.pre_gen_dist_line_id = p_line_id
4112: AND ppgdl.distribution_date between paf.effective_start_date and paf.effective_end_date;

Line 4233: from psp_pre_gen_dist_lines ppg

4229: union all
4230: select ppg.element_type_id,
4231: ppg.assignment_id,
4232: ppg.person_id
4233: from psp_pre_gen_dist_lines ppg
4234: where pre_gen_dist_line_id = x_line_id;
4235:
4236: cursor get_asg_details is
4237: select ppf.full_name,

Line 4499: UPDATE psp_pre_gen_dist_lines

4495:
4496: --moved the two del stmnts above for 2445196
4497:
4498: ELSIF p_source_type = 'P' THEN
4499: UPDATE psp_pre_gen_dist_lines
4500: SET status_code = 'A'
4501: WHERE rowid = l_rowid;
4502:
4503: -- move the transferred records to psp_pre_gen_dist_lines_history

Line 4503: -- move the transferred records to psp_pre_gen_dist_lines_history

4499: UPDATE psp_pre_gen_dist_lines
4500: SET status_code = 'A'
4501: WHERE rowid = l_rowid;
4502:
4503: -- move the transferred records to psp_pre_gen_dist_lines_history
4504: INSERT INTO psp_pre_gen_dist_lines_history
4505: (pre_gen_dist_line_id,distribution_interface_id,person_id,assignment_id,
4506: element_type_id,distribution_date,effective_date,distribution_amount,
4507: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,

Line 4504: INSERT INTO psp_pre_gen_dist_lines_history

4500: SET status_code = 'A'
4501: WHERE rowid = l_rowid;
4502:
4503: -- move the transferred records to psp_pre_gen_dist_lines_history
4504: INSERT INTO psp_pre_gen_dist_lines_history
4505: (pre_gen_dist_line_id,distribution_interface_id,person_id,assignment_id,
4506: element_type_id,distribution_date,effective_date,distribution_amount,
4507: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,
4508: batch_name,status_code,set_of_books_id,

Line 4529: FROM psp_pre_gen_dist_lines

4525: attribute_category, attribute1, attribute2, attribute3,
4526: attribute4, attribute5, attribute6, attribute7,
4527: attribute8, attribute9, attribute10,
4528: suspense_auto_exp_type, suspense_auto_glccid
4529: FROM psp_pre_gen_dist_lines
4530: WHERE status_code = 'A'
4531: AND summary_line_id = to_number(l_orig_trx_reference);
4532:
4533: hr_utility.trace('after insert into pregen lines');

Line 4534: DELETE FROM psp_pre_gen_dist_lines

4530: WHERE status_code = 'A'
4531: AND summary_line_id = to_number(l_orig_trx_reference);
4532:
4533: hr_utility.trace('after insert into pregen lines');
4534: DELETE FROM psp_pre_gen_dist_lines
4535: WHERE status_code = 'A'
4536: AND summary_line_id = to_number(l_orig_trx_reference);
4537: END IF;
4538: --- moved the two del stmnts below for 2445196, earlier commented for 2290051

Line 4564: UPDATE psp_pre_gen_dist_lines

4560: SET suspense_reason_code = l_trx_reject_code,
4561: status_code = 'N'
4562: WHERE rowid = l_rowid;
4563: ELSIF p_source_type = 'P' THEN
4564: UPDATE psp_pre_gen_dist_lines
4565: SET suspense_reason_code = l_trx_reject_code,
4566: status_code = 'N'
4567: WHERE rowid = l_rowid;
4568: END IF; Enf of commenting for BUg 3065866 */

Line 4745: UPDATE psp_pre_gen_dist_lines

4741: suspense_auto_glccid = l_new_glccid, --- added suspense_auto for 5080403
4742: suspense_auto_exp_type = l_new_expenditure_type
4743: WHERE rowid = l_rowid;
4744: ELSIF p_source_type = 'P' THEN
4745: UPDATE psp_pre_gen_dist_lines
4746: SET suspense_org_account_id = l_organization_account_id,
4747: suspense_reason_code = 'ST:' || l_trx_reject_code,
4748: status_code = 'N',
4749: effective_date = l_effective_date, ---uncommented this line for Bug 2663344

Line 4806: UPDATE psp_pre_gen_dist_lines

4802: IN ( SELECT summary_line_id
4803: FROM psp_summary_lines
4804: WHERE payroll_control_id = p_payroll_control_id);
4805: ELSIF p_source_type = 'P' THEN
4806: UPDATE psp_pre_gen_dist_lines
4807: SET suspense_org_account_id = NULL,
4808: suspense_reason_code = NULL,
4809: effective_date = decode(NVL(gl_code_combination_id,-999),gl_code_combination_id,
4810: p_period_end_date,distribution_date)

Line 4853: UPDATE psp_pre_gen_dist_lines

4849: IN( SELECT summary_line_id
4850: FROM psp_summary_lines
4851: WHERE payroll_control_id = p_payroll_control_id);
4852: ELSIF p_source_type = 'P' THEN
4853: UPDATE psp_pre_gen_dist_lines
4854: SET suspense_org_account_id = NULL,
4855: suspense_reason_code = NULL
4856: WHERE suspense_reason_code like 'ST:%'
4857: AND summary_line_id

Line 4989: UPDATE psp_pre_gen_dist_lines

4985: AND summary_line_id = l_summary_line_id;
4986: -- Moved the purging of xface lines from here below LOOP, for Bug 2445196
4987: ELSIF p_source_type = 'P' THEN
4988:
4989: UPDATE psp_pre_gen_dist_lines
4990: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
4991:
4992: -- move the transferred records to psp_pre_gen_dist_lines_history
4993: INSERT INTO psp_pre_gen_dist_lines_history

Line 4992: -- move the transferred records to psp_pre_gen_dist_lines_history

4988:
4989: UPDATE psp_pre_gen_dist_lines
4990: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
4991:
4992: -- move the transferred records to psp_pre_gen_dist_lines_history
4993: INSERT INTO psp_pre_gen_dist_lines_history
4994: (pre_gen_dist_line_id,distribution_interface_id,person_id,assignment_id,
4995: element_type_id,distribution_date,effective_date,distribution_amount,
4996: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,

Line 4993: INSERT INTO psp_pre_gen_dist_lines_history

4989: UPDATE psp_pre_gen_dist_lines
4990: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
4991:
4992: -- move the transferred records to psp_pre_gen_dist_lines_history
4993: INSERT INTO psp_pre_gen_dist_lines_history
4994: (pre_gen_dist_line_id,distribution_interface_id,person_id,assignment_id,
4995: element_type_id,distribution_date,effective_date,distribution_amount,
4996: dr_cr_flag,payroll_control_id,source_type,source_code,time_period_id,
4997: batch_name,status_code,set_of_books_id,

Line 5018: FROM psp_pre_gen_dist_lines

5014: attribute_category, attribute1, attribute2, attribute3,
5015: attribute4, attribute5, attribute6, attribute7,
5016: attribute8, attribute9, attribute10,
5017: suspense_auto_exp_type, suspense_auto_glccid
5018: FROM psp_pre_gen_dist_lines
5019: WHERE status_code = 'A'
5020: AND summary_line_id = l_summary_line_id;
5021:
5022: DELETE FROM psp_pre_gen_dist_lines

Line 5022: DELETE FROM psp_pre_gen_dist_lines

5018: FROM psp_pre_gen_dist_lines
5019: WHERE status_code = 'A'
5020: AND summary_line_id = l_summary_line_id;
5021:
5022: DELETE FROM psp_pre_gen_dist_lines
5023: WHERE status_code = 'A'
5024: AND summary_line_id = l_summary_line_id;
5025: --Moved delete xface stmnts from here to below for bug 2445196:
5026: END IF;

Line 5317: From psp_pre_gen_dist_lines_history pregen,

5313: cursor pregen_er_supercede is
5314: Select per.effort_report_id,
5315: per.person_id,
5316: min(pregen.summary_line_id)
5317: From psp_pre_gen_dist_lines_history pregen,
5318: Psp_eff_reports per,
5319: Psp_payroll_controls ppc
5320: Where pregen.distribution_date between per.start_date and per.end_date
5321: And per.request_id in (select -person_id from psp_supercede_persons_gt where person_id < 0)

Line 5435: From psp_pre_gen_dist_lines_history pregen,

5431: UNION ALL
5432: Select per.effort_report_id,
5433: per.person_id,
5434: pregen.summary_line_id summary_line_id
5435: From psp_pre_gen_dist_lines_history pregen,
5436: Psp_eff_reports per,
5437: Psp_payroll_controls ppc
5438: Where pregen.distribution_date between per.start_date and per.end_date
5439: And per.request_id in ( select -person_id from psp_supercede_persons_gt )

Line 5507: From psp_pre_gen_dist_lines_history pregen,

5503: cursor pregen_asg_er_supercede is
5504: Select per.effort_report_id,
5505: per.person_id,
5506: min(pregen.summary_line_id)
5507: From psp_pre_gen_dist_lines_history pregen,
5508: Psp_eff_reports per,
5509: Psp_payroll_controls ppc,
5510: psp_eff_report_details perd
5511: Where pregen.distribution_date between per.start_date and per.end_date

Line 5635: From psp_pre_gen_dist_lines_history pregen,

5631: UNION ALL
5632: Select per.effort_report_id,
5633: per.person_id,
5634: pregen.summary_line_id summary_line_id
5635: From psp_pre_gen_dist_lines_history pregen,
5636: Psp_eff_reports per,
5637: Psp_payroll_controls ppc,
5638: psp_eff_report_details perd
5639: Where pregen.distribution_date between per.start_date and per.end_date