[Home] [Help]
2584: UPDATE psp_distribution_lines
2585: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
2586: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set status_code = A count: '||sql%rowcount);
2587:
2588: -- move the transferred records to psp_distribution_lines_history
2589: INSERT INTO psp_distribution_lines_history
2590: (distribution_line_id,payroll_sub_line_id,distribution_date,
2591: effective_date,distribution_amount,status_code,suspense_reason_code,
2592: effort_report_id,version_num,schedule_line_id,
2585: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
2586: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set status_code = A count: '||sql%rowcount);
2587:
2588: -- move the transferred records to psp_distribution_lines_history
2589: INSERT INTO psp_distribution_lines_history
2590: (distribution_line_id,payroll_sub_line_id,distribution_date,
2591: effective_date,distribution_amount,status_code,suspense_reason_code,
2592: effort_report_id,version_num,schedule_line_id,
2593: summary_line_id,default_org_account_id,suspense_org_account_id,
2618: FROM psp_distribution_lines
2619: WHERE status_code = 'A'
2620: AND summary_line_id = l_summary_line_id;
2621:
2622: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' inserted into psp_distribution_lines_history count: '||sql%rowcount);
2623:
2624: DELETE FROM psp_distribution_lines
2625: WHERE status_code = 'A'
2626: AND summary_line_id = l_summary_line_id;
4764:
4765: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated psp_distribution_lines set status_code A count: '||sql%rowcount);
4766: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated status_code in psp_distribution_lines to A for rowid :'||l_rowid);
4767:
4768: INSERT INTO psp_distribution_lines_history
4769: (distribution_line_id,payroll_sub_line_id,distribution_date,
4770: effective_date,distribution_amount,status_code,suspense_reason_code,
4771: effort_report_id,version_num,schedule_line_id,summary_line_id,
4772: default_org_account_id,suspense_org_account_id,
4797: FROM psp_distribution_lines
4798: WHERE status_code = 'A'
4799: AND summary_line_id = to_number(l_orig_trx_reference);
4800:
4801: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserting into psp_distribution_lines_history for summary_line_id: '||l_orig_trx_reference
4802: ||'number of rows SQL%ROWCOUNT: '||SQL%ROWCOUNT);
4803: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' after insert into dist lines');
4804:
4805: hr_utility.trace('after insert into dist lines');
5331: SET status_code = 'A' WHERE summary_line_id = l_summary_line_id;
5332: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set status_code to A count: '||sql%rowcount);
5333:
5334:
5335: -- move the transferred records to psp_distribution_lines_history
5336: INSERT INTO psp_distribution_lines_history
5337: (distribution_line_id,payroll_sub_line_id,distribution_date,
5338: effective_date,distribution_amount,status_code,suspense_reason_code,
5339: effort_report_id,version_num,schedule_line_id,summary_line_id,
5332: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' updated psp_distribution_lines set status_code to A count: '||sql%rowcount);
5333:
5334:
5335: -- move the transferred records to psp_distribution_lines_history
5336: INSERT INTO psp_distribution_lines_history
5337: (distribution_line_id,payroll_sub_line_id,distribution_date,
5338: effective_date,distribution_amount,status_code,suspense_reason_code,
5339: effort_report_id,version_num,schedule_line_id,summary_line_id,
5340: default_org_account_id,suspense_org_account_id,
5365: FROM psp_distribution_lines
5366: WHERE status_code = 'A'
5367: AND summary_line_id = l_summary_line_id;
5368:
5369: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Inserting into psp_distribution_lines_history for summary_line_id: '||l_orig_trx_reference
5370: ||'number of rows SQL%ROWCOUNT: '||SQL%ROWCOUNT);
5371:
5372: DELETE FROM psp_distribution_lines
5373: WHERE status_code = 'A'
5773: Select per.effort_report_id,
5774: per.person_id,
5775: MIN(dlh.summary_line_id) summary_line_id
5776: From psp_eff_reports per,
5777: Psp_distribution_lines_history DLH,
5778: Psp_payroll_controls ppc,
5779: psp_payroll_sub_lines psub,
5780: psp_payroll_lines ppl
5781: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
5817: Select per.effort_report_id,
5818: per.person_id,
5819: dlh.summary_line_id summary_line_id
5820: From psp_eff_reports per,
5821: Psp_distribution_lines_history DLH,
5822: Psp_payroll_controls ppc,
5823: psp_payroll_sub_lines psub,
5824: psp_payroll_lines ppl
5825: Where dlh.payroll_sub_line_id = psub.payroll_sub_line_id
5966: Select per.effort_report_id,
5967: per.person_id,
5968: MIN(dlh.summary_line_id) summary_line_id
5969: From psp_eff_reports per,
5970: Psp_distribution_lines_history DLH,
5971: Psp_payroll_controls ppc,
5972: psp_payroll_sub_lines psub,
5973: psp_payroll_lines ppl,
5974: psp_eff_report_details perd
6014: Select per.effort_report_id,
6015: per.person_id,
6016: dlh.summary_line_id summary_line_id
6017: From psp_eff_reports per,
6018: Psp_distribution_lines_history DLH,
6019: Psp_payroll_controls ppc,
6020: psp_payroll_sub_lines psub,
6021: psp_payroll_lines ppl,
6022: psp_eff_report_details perd