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

Line 6630: FROM psp_enc_lines_history pelh

6626: p_element_type_id NUMBER,
6627: p_enc_begin_date DATE) IS
6628: SELECT COUNT(1),
6629: NVL(MAX(pelh.encumbrance_date),p_enc_begin_date)
6630: FROM psp_enc_lines_history pelh
6631: WHERE pelh.assignment_id = l_assignment_id
6632: AND pelh.enc_element_type_id = p_element_type_id
6633: AND pelh.payroll_id = l_payroll_id;
6634:

Line 7213: UPDATE psp_enc_lines_history pelh

7209: END IF;
7210: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed verify_changes for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id);
7211: ELSE
7212: IF (l_liq_all_count > 0) THEN
7213: UPDATE psp_enc_lines_history pelh
7214: SET change_flag = 'N'
7215: WHERE assignment_id = l_assignment_id
7216: AND payroll_id = l_payroll_id
7217: AND change_flag = 'U'

Line 7230: UPDATE psp_enc_lines_history pelh

7226: WHERE assignment_id = l_assignment_id
7227: AND payroll_id = l_payroll_id
7228: AND change_type = 'ZZ';
7229: ELSE
7230: UPDATE psp_enc_lines_history pelh
7231: SET change_flag = 'N'
7232: WHERE assignment_id = l_assignment_id
7233: AND payroll_id = l_payroll_id
7234: AND change_flag = 'U'

Line 7253: UPDATE psp_enc_lines_history pelh

7249: and ppa.date_earned between ptp.start_date and ptp.end_date
7250: and ptp.payroll_id = ppa.payroll_id),l_enc_begin_date)) );
7251:
7252: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Updated lines to be liquidated by regular liquidation');
7253: UPDATE psp_enc_lines_history pelh
7254: SET change_flag = 'U'
7255: WHERE assignment_id = l_assignment_id
7256: AND payroll_id = l_payroll_id
7257: AND change_flag = 'N'

Line 7795: FROM psp_enc_lines_history pelh

7791: NVL(pelh.attribute10, 'NULL_VALUE'),
7792: NVL(pelh.default_reason_code, 'NULL'),
7793: NVL(pelh.suspense_reason_code, 'NULL'),
7794: hierarchy_code
7795: FROM psp_enc_lines_history pelh
7796: WHERE pelh.change_flag = 'U'
7797: AND payroll_id = p_payroll_id
7798: AND assignment_id = p_assignment_id;
7799:

Line 7802: FROM psp_enc_lines_history

7798: AND assignment_id = p_assignment_id;
7799:
7800: CURSOR modified_summary_lines_cur IS
7801: SELECT DISTINCT enc_summary_line_id
7802: FROM psp_enc_lines_history
7803: WHERE change_flag = 'N'
7804: AND payroll_id = p_payroll_id
7805: AND assignment_id = p_assignment_id;
7806:

Line 7816: UPDATE psp_enc_lines_history

7812: p_payroll_id: ' || p_payroll_id || ' p_assignment_id: ' || p_assignment_id || '
7813: p_business_group_id: ' || p_business_group_id || ' p_set_of_books_id: ' || p_set_of_books_id || '
7814: p_enc_line_type: ' || p_enc_line_type);
7815:
7816: UPDATE psp_enc_lines_history
7817: SET change_flag = 'N'
7818: WHERE assignment_id = p_assignment_id
7819: AND payroll_id = p_payroll_id
7820: AND change_flag = 'U'

Line 7825: UPDATE psp_enc_lines_history pelh

7821: AND status_code = 'A';
7822:
7823: IF (g_dff_grouping_option = 'N') THEN
7824: FORALL recno IN 1 .. t_enc_lines_array.r_time_period_id.COUNT
7825: UPDATE psp_enc_lines_history pelh
7826: SET change_flag='U'
7827: WHERE time_period_id = t_enc_lines_array.r_time_period_id(recno)
7828: AND change_flag = 'N'
7829: AND pelh.encumbrance_date = t_enc_lines_array.r_encumbrance_date(recno)

Line 7847: UPDATE psp_enc_lines_history pelh

7843: AND pelh.assignment_id = p_assignment_id
7844: AND pelh.payroll_id = p_payroll_id;
7845: ELSE
7846: FORALL recno IN 1 .. t_enc_lines_array.r_time_period_id.COUNT
7847: UPDATE psp_enc_lines_history pelh
7848: SET change_flag='U'
7849: WHERE time_period_id = t_enc_lines_array.r_time_period_id(recno)
7850: AND change_flag = 'N'
7851: AND pelh.encumbrance_date = t_enc_lines_array.r_encumbrance_date(recno)

Line 7887: UPDATE psp_enc_lines_history pelh

7883:
7884: hr_utility.trace('l_enc_summary_line_id_tl.COUNT: ' || l_enc_summary_line_id_tl.COUNT);
7885:
7886: FORALL recno IN 1..l_enc_summary_line_id_tl.COUNT
7887: UPDATE psp_enc_lines_history pelh
7888: SET change_flag='N'
7889: WHERE enc_summary_line_id = l_enc_summary_line_id_tl(recno)
7890: AND change_flag='U';
7891:

Line 8227: FROM psp_enc_lines_history pelh

8223: WHERE pesl.assignment_id = p_assignment_id
8224: AND pesl.payroll_id = p_payroll_id
8225: AND pesl.status_code = 'A'
8226: AND pesl.enc_summary_line_id IN (SELECT pelh.enc_summary_line_id
8227: FROM psp_enc_lines_history pelh
8228: WHERE pelh.change_flag = 'N'
8229: AND pelh.assignment_id = p_assignment_id
8230: AND pelh.payroll_id = p_payroll_id);
8231: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' No of liquidation lines created: ' || SQL%ROWCOUNT);

Line 9496: UPDATE psp_enc_lines_history

9492: FETCH superceded_line_cur BULK COLLECT INTO t_superceded_lines.enc_summary_line_id;
9493: CLOSE superceded_line_cur;
9494:
9495: FORALL recno IN 1..t_superceded_lines.enc_summary_line_id.COUNT
9496: UPDATE psp_enc_lines_history
9497: SET change_flag = 'N'
9498: WHERE enc_summary_line_id = t_superceded_lines.enc_summary_line_id(recno);
9499: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Reverted respective superceded lines in psp_enc_lines_history');
9500:

Line 9499: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Reverted respective superceded lines in psp_enc_lines_history');

9495: FORALL recno IN 1..t_superceded_lines.enc_summary_line_id.COUNT
9496: UPDATE psp_enc_lines_history
9497: SET change_flag = 'N'
9498: WHERE enc_summary_line_id = t_superceded_lines.enc_summary_line_id(recno);
9499: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Reverted respective superceded lines in psp_enc_lines_history');
9500:
9501: DELETE psp_enc_summary_lines
9502: WHERE payroll_action_id = p_payroll_action_id;
9503: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_summary_lines');

Line 9614: UPDATE psp_enc_lines_history

9610: FETCH superceded_line_cur BULK COLLECT INTO t_superceded_lines.enc_summary_line_id;
9611: CLOSE superceded_line_cur;
9612:
9613: FORALL recno IN 1..t_superceded_lines.enc_summary_line_id.COUNT
9614: UPDATE psp_enc_lines_history
9615: SET change_flag = 'N'
9616: WHERE enc_summary_line_id = t_superceded_lines.enc_summary_line_id(recno);
9617: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Reverted respective superceded lines in psp_enc_lines_history');
9618:

Line 9617: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Reverted respective superceded lines in psp_enc_lines_history');

9613: FORALL recno IN 1..t_superceded_lines.enc_summary_line_id.COUNT
9614: UPDATE psp_enc_lines_history
9615: SET change_flag = 'N'
9616: WHERE enc_summary_line_id = t_superceded_lines.enc_summary_line_id(recno);
9617: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Reverted respective superceded lines in psp_enc_lines_history');
9618:
9619: DELETE psp_enc_summary_lines
9620: WHERE payroll_action_id = p_payroll_action_id
9621: AND assignment_id = l_assignments(recno);

Line 11271: FROM psp_enc_lines_history

11267: NVL(expenditure_organization_id, -99),
11268: NVL(expenditure_type, '-99'),
11269: enc_start_date,
11270: enc_end_date
11271: FROM psp_enc_lines_history
11272: WHERE assignment_id = p_assignment_id
11273: AND payroll_id = p_payroll_id
11274: AND change_flag = 'N'
11275: ORDER BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10;

Line 11470: UPDATE psp_enc_lines_history

11466: END IF;
11467: END LOOP;
11468:
11469: FORALL recno IN 1..t_enc_nlines.element_type_id.COUNT
11470: UPDATE psp_enc_lines_history
11471: SET hierarchy_start_date = t_enc_nlines.enc_start_date(recno),
11472: hierarchy_end_date = t_enc_nlines.enc_end_date(recno)
11473: WHERE assignment_id = p_assignment_id
11474: AND payroll_id = p_payroll_id

Line 11485: UPDATE psp_enc_lines_history

11481: AND enc_start_date <= t_enc_nlines.enc_end_date(recno)
11482: AND enc_end_date >= t_enc_nlines.enc_start_date(recno);
11483:
11484: FORALL recno IN 1..t_enc_nlines.element_type_id.COUNT
11485: UPDATE psp_enc_lines_history
11486: SET hierarchy_start_date = t_enc_nlines.enc_start_date(recno),
11487: hierarchy_end_date = t_enc_nlines.enc_end_date(recno)
11488: WHERE assignment_id = p_assignment_id
11489: AND payroll_id = p_payroll_id