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

Line 851: psp_Enc_lines_history pelh where

847: / * Commented the following for Enh. 2143723 as Super Summarization is obsolete
848: Includes Restart Update process fix.
849: AND EXISTS
850: (SELECT pelh.assignment_id from psp_enc_summary_lines pesl,
851: psp_Enc_lines_history pelh where
852: pelh.enc_control_id=pec.enc_control_id and
853: pelh.enc_summary_line_id=pesl.enc_summary_line_id
854: AND pesl.enc_control_id=pec.enc_control_id AND
855: pesl.status_code='A');

Line 890: psp_enc_lines_history pelh WHERE

886: and payroll_id = p_payroll_id);
887: / * Commented the following for Enh. 2143723 as Super Summarization is obsolete
888: Includes Restart Update process fix.
889: AND EXISTS (SELECT pelh.assignment_id from psp_enc_summary_lines pesl,
890: psp_enc_lines_history pelh WHERE
891: pelh.enc_control_id=pec.enc_control_id AND
892: pelh.enc_summary_line_id =pesl.enc_summary_line_id AND
893: pesl.enc_control_id=pec.enc_control_id AND
894: pesl.status_code='A' and

Line 1370: UPDATE psp_enc_lines_history pelh

1366: FETCH enc_control_cur BULK COLLECT INTO t_enc_control_id;
1367: CLOSE enc_control_cur;
1368:
1369: FORALL recno IN 1..t_enc_control_id.COUNT
1370: UPDATE psp_enc_lines_history pelh
1371: SET change_flag = 'U'
1372: WHERE EXISTS (SELECT 1
1373: FROM psp_enc_summary_lines pesl
1374: WHERE status_code = 'A'

Line 1415: UPDATE psp_enc_lines_history pelh

1411:
1412: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated status_code to ''A'' in psp_enc_summary_lines for lines rejected or not imported into target systems, SQL%ROWCOUNT: ' || SQL%ROWCOUNT);
1413:
1414: FORALL recno IN 1..t_enc_control_id.COUNT
1415: UPDATE psp_enc_lines_history pelh
1416: SET change_flag = 'L'
1417: WHERE pelh.enc_summary_line_id IN (SELECT pesl.superceded_line_id
1418: FROM psp_enc_summary_lines pesl
1419: WHERE pesl.status_code = 'L'

Line 1423: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated change_flag to ''L'' in psp_enc_lines_history for lines that are liquidated');

1419: WHERE pesl.status_code = 'L'
1420: AND pesl.enc_control_id = t_enc_control_id(recno))
1421: AND pelh.enc_control_id = t_enc_control_id(recno);
1422:
1423: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated change_flag to ''L'' in psp_enc_lines_history for lines that are liquidated');
1424:
1425: FORALL recno IN 1..t_enc_control_id.COUNT
1426: UPDATE psp_enc_controls
1427: SET action_code = 'L'

Line 1745: / * mark the change_flag in psp_Enc_lineS_history as well * /

1741: -- for 2479579
1742: (select 1 from psp_enc_summary_lines S2
1743: where S2.status_code = 'L' and S1.enc_control_id = S2.enc_control_id
1744: and S2.superceded_line_id = l_sup_enc_summary_line_id);
1745: / * mark the change_flag in psp_Enc_lineS_history as well * /
1746: -- Update the change_flag to 'U' as per HQ review comment for Enh. 2143723
1747: / ***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation
1748: IF g_invalid_suspense ='N' THEN --Added for bug 2330057.
1749: update psp_Enc_lines_history

Line 1749: update psp_Enc_lines_history

1745: / * mark the change_flag in psp_Enc_lineS_history as well * /
1746: -- Update the change_flag to 'U' as per HQ review comment for Enh. 2143723
1747: / ***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation
1748: IF g_invalid_suspense ='N' THEN --Added for bug 2330057.
1749: update psp_Enc_lines_history
1750: set change_flag= DECODE(p_action_type, 'Q', 'U', p_action_type)
1751: where enc_summary_line_id=l_sup_enc_summary_line_id
1752: and change_flag='N';
1753: END IF;

Line 1876: UPDATE psp_enc_lines_history

1872: END IF;
1873:
1874: -- After Liquidation, Identify and update the liquidated records and mark the unchanged records to 'N'
1875: -- to be picked up in a susequent update run
1876: UPDATE psp_enc_lines_history
1877: SET change_flag = 'L'
1878: WHERE change_flag = 'N'
1879: AND payroll_id = p_payroll_id;
1880:

Line 1884: UPDATE psp_enc_lines_history

1880:
1881: -- Introduced IF stmt instead of DECODE in WHERE clause for Quick Update Enh. 2143723 (perf. issue)
1882: -- As per HQ review comment, change_flag for Quick Update will be 'U' and not 'Q'
1883: IF (p_action_type = 'Q') THEN
1884: UPDATE psp_enc_lines_history
1885: SET change_flag = 'N'
1886: WHERE change_flag = 'U'
1887: AND payroll_id = p_payroll_id;
1888: ELSE

Line 1889: UPDATE psp_enc_lines_history

1885: SET change_flag = 'N'
1886: WHERE change_flag = 'U'
1887: AND payroll_id = p_payroll_id;
1888: ELSE
1889: UPDATE psp_enc_lines_history
1890: SET change_flag = 'N'
1891: WHERE change_flag = p_action_type
1892: AND payroll_id = p_payroll_id;
1893: END IF;

Line 1964: FROM psp_enc_lines_history pelh

1960: AND (pec.gl_phase IS NULL or pec.gl_phase = 'TieBack'))
1961: AND pesl.gl_project_flag = 'G'
1962: AND pesl.status_code = 'A'
1963: AND EXISTS (SELECT 1
1964: FROM psp_enc_lines_history pelh
1965: WHERE pelh.change_flag = 'N'
1966: AND pelh.enc_summary_line_id = pesl.enc_summary_line_id);
1967:
1968: CURSOR enc_upd_liq_cur IS

Line 2007: FROM psp_enc_lines_history pelh

2003: WHERE peca.assignment_id = pesl.assignment_id
2004: AND peca.request_id IS NOT NULL
2005: AND peca.payroll_id =p_payroll_id)
2006: AND EXISTS (SELECT 1
2007: FROM psp_enc_lines_history pelh
2008: WHERE pelh.change_flag = 'N'
2009: AND pelh.enc_summary_line_id = pesl.enc_summary_line_id);
2010:
2011: CURSOR enc_qupd_liq_cur IS

Line 2051: FROM psp_enc_lines_history pelh

2047: AND peca.request_id IS NOT NULL
2048: AND peca.payroll_id = p_payroll_id
2049: AND peca.change_type IN ('LS', 'ET', 'AS', 'QU'))
2050: AND EXISTS (SELECT 1
2051: FROM psp_enc_lines_history pelh
2052: WHERE pelh.change_flag = 'N'
2053: AND pelh.enc_summary_line_id = pesl.enc_summary_line_id);
2054:
2055: CURSOR emp_term_enc_liq_cur IS

Line 2091: FROM psp_enc_lines_history pelh

2087: AND gl_project_flag = 'G'
2088: AND status_code = 'A'
2089: AND person_id = g_person_id
2090: AND EXISTS (SELECT 1
2091: FROM psp_enc_lines_history pelh
2092: WHERE pelh.change_flag = 'N'
2093: AND pelh.enc_summary_line_id = pesl.enc_summary_line_id);
2094:
2095: TYPE t_number IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 2302: AND EXISTS (SELECT 1 FROM PSP_ENC_LINES_HISTORY PELH WHERE PELH.ENC_SUMMARY_LINE_ID = PESL.ENC_SUMMARY_LINE_ID

2298: AND pesl.gl_project_flag = 'G'
2299: AND pesl.status_code = 'A'
2300: AND ((p_action_type='L' and g_person_id is null) --- g_person_id null check for 3413373
2301: OR (g_person_id is not null AND peSL.person_id = g_person_id
2302: AND EXISTS (SELECT 1 FROM PSP_ENC_LINES_HISTORY PELH WHERE PELH.ENC_SUMMARY_LINE_ID = PESL.ENC_SUMMARY_LINE_ID
2303: AND PELH.CHANGE_FLAG = 'N')
2304: AND peSL.time_period_id >= g_term_period_id)
2305: OR
2306: (p_action_type IN ('Q', 'U') AND EXISTS

Line 2307: (SELECT 1 FROM PSP_ENC_LINES_HISTORY PELH WHERE PELH.ENC_SUMMARY_LINE_ID = PESL.ENC_SUMMARY_LINE_ID

2303: AND PELH.CHANGE_FLAG = 'N')
2304: AND peSL.time_period_id >= g_term_period_id)
2305: OR
2306: (p_action_type IN ('Q', 'U') AND EXISTS
2307: (SELECT 1 FROM PSP_ENC_LINES_HISTORY PELH WHERE PELH.ENC_SUMMARY_LINE_ID = PESL.ENC_SUMMARY_LINE_ID
2308: AND PELH.CHANGE_FLAG = 'N')
2309: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca
2310: WHERE peca.assignment_id = pesl.assignment_id
2311: AND peca.request_id IS NOT NULL

Line 2324: psp_enc_lines_history pelh, psp_enc_controls pec

2320: AND (p_action_type='L' or
2321: (p_action_type='U' and
2322: pelh.assignment_id IN
2323: (SELECT distinct pelh.assignment_id FROM
2324: psp_enc_lines_history pelh, psp_enc_controls pec
2325: WHERE pec.enc_control_id=p_enc_control_id AND
2326: pelh.time_period_id=pec.time_period_id and pelh.change_flag='N')));
2327: Above cursor modified for bug fixes 1832670 and 1776752
2328:

Line 3737: UPDATE psp_enc_lines_history

3733: AND status_code = 'N';
3734:
3735: IF (g_person_id IS NOT NULL) THEN
3736: FORALL recno IN 1..r_interface.enc_summary_line_id.COUNT
3737: UPDATE psp_enc_lines_history
3738: SET change_flag = 'L'
3739: WHERE enc_summary_line_id = (SELECT pesl2.superceded_line_id
3740: FROM psp_enc_summary_lines pesl2
3741: WHERE pesl2.enc_summary_line_id = r_interface.enc_summary_line_id(recno));

Line 3742: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated respective lines in psp_enc_lines_history to ''L'' status SQL%ROWCOUNT: ' || SQL%ROWCOUNT);

3738: SET change_flag = 'L'
3739: WHERE enc_summary_line_id = (SELECT pesl2.superceded_line_id
3740: FROM psp_enc_summary_lines pesl2
3741: WHERE pesl2.enc_summary_line_id = r_interface.enc_summary_line_id(recno));
3742: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated respective lines in psp_enc_lines_history to ''L'' status SQL%ROWCOUNT: ' || SQL%ROWCOUNT);
3743: END IF;
3744:
3745: FORALL recno IN 1..r_interface.enc_control_id.COUNT
3746: UPDATE psp_enc_controls pec

Line 4090: update psp_enc_lines_history

4086: and status_code = 'N';
4087:
4088: if g_person_id is not null then
4089: --- added following for 3477373
4090: update psp_enc_lines_history
4091: set change_flag = 'L'
4092: where enc_summary_line_id = ( select superceded_line_id
4093: from psp_enc_summary_lines
4094: where enc_summary_line_id = l_enc_summary_line_id);

Line 4400: FROM psp_enc_lines_history pelh

4396: AND (pec.gms_phase IS NULL or pec.gms_phase = 'TieBack'))
4397: AND gl_project_flag = 'P'
4398: AND status_code = 'A'
4399: AND EXISTS (SELECT 1
4400: FROM psp_enc_lines_history pelh
4401: WHERE pelh.change_flag = 'N'
4402: AND pelh.enc_summary_line_id = pesl.enc_summary_line_id);
4403:
4404: CURSOR enc_upd_liq_cur IS

Line 4450: FROM psp_enc_lines_history pelh

4446: WHERE peca.assignment_id = pesl.assignment_id
4447: AND peca.request_id IS NOT NULL
4448: AND peca.payroll_id = p_payroll_id)
4449: AND EXISTS (SELECT 1
4450: FROM psp_enc_lines_history pelh
4451: WHERE pelh.change_flag = 'N'
4452: AND pelh.enc_summary_line_id = pesl.enc_summary_line_id);
4453:
4454: CURSOR enc_qupd_liq_cur IS

Line 4501: FROM psp_enc_lines_history pelh

4497: AND peca.request_id IS NOT NULL
4498: AND peca.payroll_id = p_payroll_id
4499: AND peca.change_type IN ('LS', 'ET', 'AS', 'QU'))
4500: AND EXISTS (SELECT 1
4501: FROM psp_enc_lines_history pelh
4502: WHERE pelh.change_flag = 'N'
4503: AND pelh.enc_summary_line_id = pesl.enc_summary_line_id);
4504:
4505: CURSOR emp_term_enc_liq_cur IS

Line 4548: FROM psp_enc_lines_history pelh

4544: AND gl_project_flag = 'P'
4545: AND status_code = 'A'
4546: AND person_id = g_person_id
4547: AND EXISTS (SELECT 1
4548: FROM psp_enc_lines_history pelh
4549: WHERE pelh.change_flag = 'N'
4550: AND pelh.enc_summary_line_id = pesl.enc_summary_line_id);
4551:
4552: TYPE t_number IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 4790: AND EXISTS (SELECT 1 FROM PSP_ENC_LINES_HISTORY PELH WHERE PELH.ENC_SUMMARY_LINE_ID = PESL.ENC_SUMMARY_LINE_ID

4786: AND pesl.status_code = 'A'
4787: AND pesl.gl_code_combination_id is NULL
4788: AND ( (p_action_type='L' and g_person_id is null) --- g_person_id null check for 3413373
4789: OR (g_person_id is not null AND peSL.person_id = g_person_id
4790: AND EXISTS (SELECT 1 FROM PSP_ENC_LINES_HISTORY PELH WHERE PELH.ENC_SUMMARY_LINE_ID = PESL.ENC_SUMMARY_LINE_ID
4791: AND PELH.CHANGE_FLAG = 'N')
4792: AND peSL.time_period_id >= g_term_period_id)
4793: OR
4794: (p_action_type IN ('Q', 'U') AND EXISTS

Line 4795: (SELECT 1 FROM PSP_ENC_LINES_HISTORY PELH WHERE PELH.ENC_SUMMARY_LINE_ID = PESL.ENC_SUMMARY_LINE_ID

4791: AND PELH.CHANGE_FLAG = 'N')
4792: AND peSL.time_period_id >= g_term_period_id)
4793: OR
4794: (p_action_type IN ('Q', 'U') AND EXISTS
4795: (SELECT 1 FROM PSP_ENC_LINES_HISTORY PELH WHERE PELH.ENC_SUMMARY_LINE_ID = PESL.ENC_SUMMARY_LINE_ID
4796: AND PELH.CHANGE_FLAG = 'N')
4797: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca
4798: WHERE peca.assignment_id = pesl.assignment_id
4799: AND peca.request_id IS NOT NULL

Line 4811: pesl.assignment_id in (select pelh.assignment_id FROM psp_enc_lines_history pelh,

4807: AND outer.change_flag='N';
4808:
4809: AND (p_action_type='L') or
4810: (p_action_type='U' and
4811: pesl.assignment_id in (select pelh.assignment_id FROM psp_enc_lines_history pelh,
4812: psp_enc_controls pec
4813: where pec.enc_control_id=p_enc_control_id AND
4814: pelh.time_period_id=pec.time_period_id
4815: and pelh.change_flag='N'));

Line 6363: UPDATE psp_enc_lines_history

6359: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated status_code to ''L'' for accepted records in psp_enc_summary_lines');
6360:
6361: IF (g_person_id IS NOT NULL) THEN
6362: FORALL recno IN 1..r_reject_recs.enc_summary_line_id.COUNT
6363: UPDATE psp_enc_lines_history
6364: SET change_flag = 'L'
6365: WHERE enc_summary_line_id IN (SELECT superceded_line_id
6366: FROM psp_enc_summary_lines pesl
6367: WHERE pesl.enc_summary_line_id = r_reject_recs.enc_summary_line_id(recno))

Line 6369: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated change_flag to ''L'' in psp_enc_lines_history for employee level encumbrance liquidation');

6365: WHERE enc_summary_line_id IN (SELECT superceded_line_id
6366: FROM psp_enc_summary_lines pesl
6367: WHERE pesl.enc_summary_line_id = r_reject_recs.enc_summary_line_id(recno))
6368: AND r_reject_recs.txn_status_code(recno) = 'A';
6369: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated change_flag to ''L'' in psp_enc_lines_history for employee level encumbrance liquidation');
6370: END IF;
6371:
6372: OPEN get_success_recs_cur;
6373: FETCH get_success_recs_cur BULK COLLECT INTO r_success_recs.enc_control_id, r_success_recs.enc_summary_line_id,

Line 6436: update psp_enc_lines_history

6432: -- and enc_control_id=p_enc_control_id;
6433:
6434: ---- added for 3477373
6435: if g_person_id is not null then
6436: update psp_enc_lines_history
6437: set change_flag = 'L'
6438: where enc_summary_line_id = ( select superceded_line_id
6439: from psp_enc_summary_lines
6440: where enc_summary_line_id = to_number(l_orig_trx_reference));

Line 6720: UPDATE psp_enc_lines_history

6716: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated status_code to ''L'' in psp_enc_summary_lines');
6717:
6718: IF (g_person_id IS NOT NULL) THEN
6719: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT
6720: UPDATE psp_enc_lines_history
6721: SET change_flag = 'L'
6722: WHERE enc_summary_line_id IN (SELECT superceded_line_id
6723: FROM psp_enc_summary_lines pesl
6724: WHERE pesl.enc_summary_line_id = r_success_recs.enc_summary_line_id(recno));

Line 6725: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated change_flag to ''L'' in psp_enc_lines_history for employee level liquidation');

6721: SET change_flag = 'L'
6722: WHERE enc_summary_line_id IN (SELECT superceded_line_id
6723: FROM psp_enc_summary_lines pesl
6724: WHERE pesl.enc_summary_line_id = r_success_recs.enc_summary_line_id(recno));
6725: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated change_flag to ''L'' in psp_enc_lines_history for employee level liquidation');
6726: END IF;
6727:
6728: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT
6729: UPDATE psp_enc_controls pec

Line 6761: update psp_enc_lines_history

6757: and status_code = 'N';
6758:
6759: ---- added for 3477373
6760: if g_person_id is not null then
6761: update psp_enc_lines_history
6762: set change_flag = 'L'
6763: where enc_summary_line_id = ( select superceded_line_id
6764: from psp_enc_summary_lines
6765: where enc_summary_line_id = l_enc_summary_line_id);

Line 7014: --- psp_enc_lines_history has index on assignment

7010: p_set_of_books_id in number,
7011: p_person_id in number,
7012: p_actual_term_date in date) is
7013: ---- there is no index on person/assignment on psp_enc_summary_lines
7014: --- psp_enc_lines_history has index on assignment
7015: cursor get_enc_hist_lines_cur is
7016: select ESL.payroll_id payroll_id,
7017: min(ESL.time_period_id) time_period_id
7018: from psp_enc_lines_history ELH,

Line 7018: from psp_enc_lines_history ELH,

7014: --- psp_enc_lines_history has index on assignment
7015: cursor get_enc_hist_lines_cur is
7016: select ESL.payroll_id payroll_id,
7017: min(ESL.time_period_id) time_period_id
7018: from psp_enc_lines_history ELH,
7019: psp_enc_summary_lines ESL,
7020: per_all_assignments_f ASG
7021: where ASG.person_id = p_person_id
7022: and ASG.assignment_id = ELH.assignment_id