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_ENC_SUM_TRAN dependencies on PSP_ENC_LINES_HISTORY

Line 3253: -- move the transferred records to psp_enc_lines_history

3249: AND suspense_reason_code LIKE 'ES:%';
3250: / * End of code Changes for Bug fix 3194807 * /
3251:
3252:
3253: -- move the transferred records to psp_enc_lines_history
3254: -- Added enc_start_date ,enc_end_date columns for Enh. Enc Redesign Prorata,Bug #2259310.
3255: -- Introduced DFF columns for bug fix 2908859
3256: INSERT INTO psp_enc_lines_history
3257: (enc_line_id,business_group_id,enc_element_type_id,encumbrance_date,

Line 3256: INSERT INTO psp_enc_lines_history

3252:
3253: -- move the transferred records to psp_enc_lines_history
3254: -- Added enc_start_date ,enc_end_date columns for Enh. Enc Redesign Prorata,Bug #2259310.
3255: -- Introduced DFF columns for bug fix 2908859
3256: INSERT INTO psp_enc_lines_history
3257: (enc_line_id,business_group_id,enc_element_type_id,encumbrance_date,
3258: dr_cr_flag,encumbrance_amount,status_code,enc_line_type,schedule_line_id,org_schedule_id,
3259: default_org_account_id,suspense_org_account_id,element_account_id,gl_project_flag,
3260: enc_summary_line_id,person_id,assignment_id,award_id,task_id,expenditure_type,

Line 3811: INSERT INTO psp_enc_lines_history

3807:
3808: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated status_code to ''A'' in psp_enc_summary_lines count: '||g_bulk_row_count);
3809:
3810: FORALL recno IN 1..r_interface.enc_summary_line_id.COUNT
3811: INSERT INTO psp_enc_lines_history
3812: (enc_line_id, business_group_id, enc_element_type_id, encumbrance_date,
3813: dr_cr_flag, encumbrance_amount, status_code, enc_line_type,
3814: schedule_line_id, org_schedule_id, default_org_account_id, suspense_org_account_id,
3815: element_account_id, gl_project_flag, enc_summary_line_id, person_id,

Line 3851: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied successfully summarized and transferred lines into psp_enc_lines_history count: '||g_bulk_row_count);

3847: loop
3848: g_bulk_row_count := g_bulk_row_count + SQL%BULK_ROWCOUNT(bulk_idx);
3849: end loop;
3850:
3851: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied successfully summarized and transferred lines into psp_enc_lines_history count: '||g_bulk_row_count);
3852:
3853: FORALL recno IN 1..r_interface.enc_summary_line_id.COUNT
3854: DELETE FROM psp_enc_lines
3855: WHERE enc_summary_line_id = r_interface.enc_summary_line_id(recno);

Line 5526: -- move the transferred records to psp_enc_lines_history

5522: UPDATE psp_enc_lines
5523: SET status_code = 'A'
5524: WHERE rowid = l_rowid;
5525:
5526: -- move the transferred records to psp_enc_lines_history
5527: -- Added enc_start_date ,enc_end_date columns for Enh. Enc Redesign Prorata,Bug #2259310
5528: --dbms_output.put_line('moving rec into enc lines hist');
5529: --insert_into_psp_stout( 'moving rec into enc lines hist');
5530: -- Introduced DFF columns for bug fix 2908859

Line 5531: INSERT INTO psp_enc_lines_history

5527: -- Added enc_start_date ,enc_end_date columns for Enh. Enc Redesign Prorata,Bug #2259310
5528: --dbms_output.put_line('moving rec into enc lines hist');
5529: --insert_into_psp_stout( 'moving rec into enc lines hist');
5530: -- Introduced DFF columns for bug fix 2908859
5531: INSERT INTO psp_enc_lines_history
5532: (enc_line_id,business_group_id,enc_element_type_id,encumbrance_date,
5533: dr_cr_flag,encumbrance_amount,status_code,enc_line_type,schedule_line_id,org_schedule_id,
5534: default_org_account_id,suspense_org_account_id,element_account_id,gl_project_flag,
5535: enc_summary_line_id,person_id,assignment_id,award_id,task_id,expenditure_type,

Line 5819: -- move the transferred records to psp_enc_lines_history

5815:
5816: / * End of code Changes for Bug fix 3194807 * /
5817:
5818:
5819: -- move the transferred records to psp_enc_lines_history
5820: -- Added enc_start_date ,enc_end_date columns for Enh. Enc Redesign Prorata,Bug #2259310
5821: -- Introduced DFF columns for bug fix 2908859
5822: INSERT INTO psp_enc_lines_history
5823: (enc_line_id,business_group_id,enc_element_type_id,encumbrance_date,

Line 5822: INSERT INTO psp_enc_lines_history

5818:
5819: -- move the transferred records to psp_enc_lines_history
5820: -- Added enc_start_date ,enc_end_date columns for Enh. Enc Redesign Prorata,Bug #2259310
5821: -- Introduced DFF columns for bug fix 2908859
5822: INSERT INTO psp_enc_lines_history
5823: (enc_line_id,business_group_id,enc_element_type_id,encumbrance_date,
5824: dr_cr_flag,encumbrance_amount,status_code,enc_line_type,schedule_line_id,org_schedule_id,
5825: default_org_account_id,suspense_org_account_id,element_account_id,gl_project_flag,
5826: enc_summary_line_id,person_id,assignment_id,award_id,task_id,expenditure_type,

Line 6241: INSERT INTO psp_enc_lines_history

6237:
6238: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' r_success_recs.enc_summary_line_id.COUNT: ' || r_success_recs.enc_summary_line_id.COUNT);
6239:
6240: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT
6241: INSERT INTO psp_enc_lines_history
6242: (enc_line_id, business_group_id, enc_element_type_id, encumbrance_date,
6243: dr_cr_flag, encumbrance_amount, status_code, enc_line_type,
6244: schedule_line_id, org_schedule_id, default_org_account_id, suspense_org_account_id,
6245: element_account_id, gl_project_flag, enc_summary_line_id, person_id,

Line 6274: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied successfully summarized and transferred lines into psp_enc_lines_history');

6270: orig_gl_code_combination_id, orig_project_id, orig_task_id, orig_award_id,
6271: orig_expenditure_org_id, orig_expenditure_type
6272: FROM psp_enc_lines
6273: WHERE enc_summary_line_id = r_success_recs.enc_summary_line_id(recno);
6274: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied successfully summarized and transferred lines into psp_enc_lines_history');
6275:
6276:
6277: g_bulk_row_count :=0;
6278: FOR bulk_idx IN 1..r_success_recs.enc_summary_line_id.COUNT

Line 6606: INSERT INTO psp_enc_lines_history

6602:
6603:
6604:
6605: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT
6606: INSERT INTO psp_enc_lines_history
6607: (enc_line_id, business_group_id, enc_element_type_id, encumbrance_date,
6608: dr_cr_flag, encumbrance_amount, status_code, enc_line_type,
6609: schedule_line_id, org_schedule_id, default_org_account_id, suspense_org_account_id,
6610: element_account_id, gl_project_flag, enc_summary_line_id, person_id,

Line 6642: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied successfully summarized and transferred lines into psp_enc_lines_history count: '||g_bulk_row_count);

6638: loop
6639: g_bulk_row_count := g_bulk_row_count + SQL%BULK_ROWCOUNT(bulk_idx);
6640: end loop;
6641:
6642: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Copied successfully summarized and transferred lines into psp_enc_lines_history count: '||g_bulk_row_count);
6643:
6644: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT
6645: DELETE FROM psp_enc_lines
6646: WHERE enc_summary_line_id = r_success_recs.enc_summary_line_id(recno);

Line 6941: FROM psp_enc_lines_history pelh

6937: NVL(expenditure_organization_id, -99),
6938: NVL(expenditure_type, '-99'),
6939: enc_start_date,
6940: enc_end_date
6941: FROM psp_enc_lines_history pelh
6942: WHERE change_flag = 'N'
6943: AND assignment_id = p_assignment_id
6944: AND payroll_id = p_payroll_id
6945: ORDER BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10;

Line 6954: UPDATE psp_enc_lines_history pelh

6950: l_nlines_counter := 0;
6951:
6952: FOR asg_no IN 1..l_asgs.payroll_id.COUNT
6953: LOOP
6954: UPDATE psp_enc_lines_history pelh
6955: SET change_flag = 'N'
6956: WHERE EXISTS (SELECT 1
6957: FROM psp_enc_summary_lines pesl
6958: WHERE pesl.enc_summary_line_id = pelh.enc_summary_line_id

Line 6963: UPDATE psp_enc_lines_history pelh

6959: AND status_code = 'A')
6960: AND assignment_id = l_asgs.assignment_id(asg_no)
6961: AND payroll_id = l_asgs.payroll_id(asg_no);
6962:
6963: UPDATE psp_enc_lines_history pelh
6964: SET hierarchy_code = 'SA'
6965: WHERE change_flag = 'N'
6966: AND hierarchy_code <> 'SA'
6967: AND suspense_org_account_id IS NOT NULL

Line 7051: UPDATE psp_enc_lines_history

7047: END IF;
7048: END LOOP;
7049:
7050: FORALL recno IN 1..t_enc_nlines.element_type_id.COUNT
7051: UPDATE psp_enc_lines_history
7052: SET hierarchy_start_date = t_enc_nlines.enc_start_date(recno),
7053: hierarchy_end_date = t_enc_nlines.enc_end_date(recno)
7054: WHERE assignment_id = t_enc_nlines.assignment_id(recno)
7055: AND payroll_id = t_enc_nlines.payroll_id(recno)