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 6896: FROM psp_enc_lines_history pelh

6892: p_element_type_id NUMBER,
6893: p_enc_begin_date DATE) IS
6894: SELECT COUNT(1),
6895: NVL(MAX(pelh.encumbrance_date),p_enc_begin_date)
6896: FROM psp_enc_lines_history pelh
6897: WHERE pelh.assignment_id = l_assignment_id
6898: AND pelh.enc_element_type_id = p_element_type_id
6899: AND pelh.payroll_id = l_payroll_id;
6900:

Line 7538: UPDATE psp_enc_lines_history pelh

7534: END IF;
7535: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Completed verify_changes for l_assignment_id: ' || l_assignment_id || ' payroll_id: ' || l_payroll_id);
7536: ELSE
7537: IF (l_liq_all_count > 0) THEN
7538: UPDATE psp_enc_lines_history pelh
7539: SET change_flag = 'N'
7540: WHERE assignment_id = l_assignment_id
7541: AND payroll_id = l_payroll_id
7542: AND change_flag = 'U'

Line 7555: UPDATE psp_enc_lines_history pelh

7551: WHERE assignment_id = l_assignment_id
7552: AND payroll_id = l_payroll_id
7553: AND change_type = 'ZZ';
7554: ELSE
7555: UPDATE psp_enc_lines_history pelh
7556: SET change_flag = 'N'
7557: WHERE assignment_id = l_assignment_id
7558: AND payroll_id = l_payroll_id
7559: AND change_flag = 'U'

Line 7571: UPDATE psp_enc_lines_history pelh

7567: -- and ptp.time_period_id = ppa.time_period_id -- Added for 11661463 -- Commented for the Bug 12647364
7568: ),l_enc_begin_date)) );
7569:
7570: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Updated lines to be liquidated by regular liquidation');
7571: UPDATE psp_enc_lines_history pelh
7572: SET change_flag = 'U'
7573: WHERE assignment_id = l_assignment_id
7574: AND payroll_id = l_payroll_id
7575: AND change_flag = 'N'

Line 8115: FROM psp_enc_lines_history pelh

8111: NVL(pelh.attribute10, 'NULL_VALUE'),
8112: NVL(pelh.default_reason_code, 'NULL'),
8113: NVL(pelh.suspense_reason_code, 'NULL'),
8114: hierarchy_code
8115: FROM psp_enc_lines_history pelh
8116: WHERE pelh.change_flag = 'U'
8117: AND payroll_id = p_payroll_id
8118: AND assignment_id = p_assignment_id;
8119:

Line 8122: FROM psp_enc_lines_history

8118: AND assignment_id = p_assignment_id;
8119:
8120: CURSOR modified_summary_lines_cur IS
8121: SELECT DISTINCT enc_summary_line_id
8122: FROM psp_enc_lines_history
8123: WHERE change_flag = 'N'
8124: AND payroll_id = p_payroll_id
8125: AND assignment_id = p_assignment_id;
8126:

Line 8136: UPDATE psp_enc_lines_history

8132: p_payroll_id: ' || p_payroll_id || ' p_assignment_id: ' || p_assignment_id || '
8133: p_business_group_id: ' || p_business_group_id || ' p_set_of_books_id: ' || p_set_of_books_id || '
8134: p_enc_line_type: ' || p_enc_line_type);
8135:
8136: UPDATE psp_enc_lines_history
8137: SET change_flag = 'N'
8138: WHERE assignment_id = p_assignment_id
8139: AND payroll_id = p_payroll_id
8140: AND change_flag = 'U'

Line 8145: UPDATE psp_enc_lines_history pelh

8141: AND status_code = 'A';
8142:
8143: IF (g_dff_grouping_option = 'N') THEN
8144: FORALL recno IN 1 .. t_enc_lines_array.r_time_period_id.COUNT
8145: UPDATE psp_enc_lines_history pelh
8146: SET change_flag='U'
8147: WHERE time_period_id = t_enc_lines_array.r_time_period_id(recno)
8148: AND change_flag = 'N'
8149: AND pelh.encumbrance_date = t_enc_lines_array.r_encumbrance_date(recno)

Line 8167: UPDATE psp_enc_lines_history pelh

8163: AND pelh.assignment_id = p_assignment_id
8164: AND pelh.payroll_id = p_payroll_id;
8165: ELSE
8166: FORALL recno IN 1 .. t_enc_lines_array.r_time_period_id.COUNT
8167: UPDATE psp_enc_lines_history pelh
8168: SET change_flag='U'
8169: WHERE time_period_id = t_enc_lines_array.r_time_period_id(recno)
8170: AND change_flag = 'N'
8171: AND pelh.encumbrance_date = t_enc_lines_array.r_encumbrance_date(recno)

Line 8207: UPDATE psp_enc_lines_history pelh

8203:
8204: hr_utility.trace('l_enc_summary_line_id_tl.COUNT: ' || l_enc_summary_line_id_tl.COUNT);
8205:
8206: FORALL recno IN 1..l_enc_summary_line_id_tl.COUNT
8207: UPDATE psp_enc_lines_history pelh
8208: SET change_flag='N'
8209: WHERE enc_summary_line_id = l_enc_summary_line_id_tl(recno)
8210: AND change_flag='U';
8211:

Line 8548: FROM psp_enc_lines_history pelh

8544: WHERE pesl.assignment_id = p_assignment_id
8545: AND pesl.payroll_id = p_payroll_id
8546: AND pesl.status_code = 'A'
8547: AND pesl.enc_summary_line_id IN (SELECT pelh.enc_summary_line_id
8548: FROM psp_enc_lines_history pelh
8549: WHERE pelh.change_flag = 'N'
8550: AND pelh.assignment_id = p_assignment_id
8551: AND pelh.payroll_id = p_payroll_id);
8552: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' No of liquidation lines created: ' || SQL%ROWCOUNT);

Line 10125: UPDATE psp_enc_lines_history

10121: FETCH superceded_line_cur BULK COLLECT INTO t_superceded_lines.enc_summary_line_id;
10122: CLOSE superceded_line_cur;
10123:
10124: FORALL recno IN 1..t_superceded_lines.enc_summary_line_id.COUNT
10125: UPDATE psp_enc_lines_history
10126: SET change_flag = 'N'
10127: WHERE enc_summary_line_id = t_superceded_lines.enc_summary_line_id(recno);
10128: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Reverted respective superceded lines in psp_enc_lines_history');
10129:

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

10124: FORALL recno IN 1..t_superceded_lines.enc_summary_line_id.COUNT
10125: UPDATE psp_enc_lines_history
10126: SET change_flag = 'N'
10127: WHERE enc_summary_line_id = t_superceded_lines.enc_summary_line_id(recno);
10128: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Reverted respective superceded lines in psp_enc_lines_history');
10129:
10130: DELETE psp_enc_summary_lines
10131: WHERE payroll_action_id = p_payroll_action_id;
10132: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Deleted respective lines in psp_enc_summary_lines');

Line 10243: UPDATE psp_enc_lines_history

10239: FETCH superceded_line_cur BULK COLLECT INTO t_superceded_lines.enc_summary_line_id;
10240: CLOSE superceded_line_cur;
10241:
10242: FORALL recno IN 1..t_superceded_lines.enc_summary_line_id.COUNT
10243: UPDATE psp_enc_lines_history
10244: SET change_flag = 'N'
10245: WHERE enc_summary_line_id = t_superceded_lines.enc_summary_line_id(recno);
10246: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Reverted respective superceded lines in psp_enc_lines_history');
10247:

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

10242: FORALL recno IN 1..t_superceded_lines.enc_summary_line_id.COUNT
10243: UPDATE psp_enc_lines_history
10244: SET change_flag = 'N'
10245: WHERE enc_summary_line_id = t_superceded_lines.enc_summary_line_id(recno);
10246: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Reverted respective superceded lines in psp_enc_lines_history');
10247:
10248: DELETE psp_enc_summary_lines
10249: WHERE payroll_action_id = p_payroll_action_id
10250: AND assignment_id = l_assignments(recno);

Line 11902: FROM psp_enc_lines_history

11898: NVL(expenditure_organization_id, -99),
11899: NVL(expenditure_type, '-99'),
11900: enc_start_date,
11901: enc_end_date
11902: FROM psp_enc_lines_history
11903: WHERE assignment_id = p_assignment_id
11904: AND payroll_id = p_payroll_id
11905: AND change_flag = 'N'
11906: ORDER BY 1, 2, 3, 4, 5, 6, 7, 8, 9, 10;

Line 12101: UPDATE psp_enc_lines_history

12097: END IF;
12098: END LOOP;
12099:
12100: FORALL recno IN 1..t_enc_nlines.element_type_id.COUNT
12101: UPDATE psp_enc_lines_history
12102: SET hierarchy_start_date = t_enc_nlines.enc_start_date(recno),
12103: hierarchy_end_date = t_enc_nlines.enc_end_date(recno)
12104: WHERE assignment_id = p_assignment_id
12105: AND payroll_id = p_payroll_id

Line 12116: UPDATE psp_enc_lines_history

12112: AND enc_start_date <= t_enc_nlines.enc_end_date(recno)
12113: AND enc_end_date >= t_enc_nlines.enc_start_date(recno);
12114:
12115: FORALL recno IN 1..t_enc_nlines.element_type_id.COUNT
12116: UPDATE psp_enc_lines_history
12117: SET hierarchy_start_date = t_enc_nlines.enc_start_date(recno),
12118: hierarchy_end_date = t_enc_nlines.enc_end_date(recno)
12119: WHERE assignment_id = p_assignment_id
12120: AND payroll_id = p_payroll_id