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 853: psp_Enc_lines_history pelh where

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

Line 892: psp_enc_lines_history pelh WHERE

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

Line 1379: UPDATE psp_enc_lines_history pelh

1375: FETCH enc_control_cur BULK COLLECT INTO t_enc_control_id;
1376: CLOSE enc_control_cur;
1377:
1378: FORALL recno IN 1..t_enc_control_id.COUNT
1379: UPDATE psp_enc_lines_history pelh
1380: SET change_flag = 'U'
1381: WHERE EXISTS (SELECT 1
1382: FROM psp_enc_summary_lines pesl
1383: WHERE status_code = 'A'

Line 1441: UPDATE psp_enc_lines_history pelh

1437: 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, count: '||g_bulk_row_count);
1438:
1439:
1440: FORALL recno IN 1..t_enc_control_id.COUNT
1441: UPDATE psp_enc_lines_history pelh
1442: SET change_flag = 'L'
1443: WHERE pelh.enc_summary_line_id IN (SELECT pesl.superceded_line_id
1444: FROM psp_enc_summary_lines pesl
1445: WHERE pesl.status_code = 'L'

Line 1454: 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 count: '||g_bulk_row_count);

1450: FOR bulk_idx IN 1..t_enc_control_id.COUNT
1451: loop
1452: g_bulk_row_count := g_bulk_row_count + SQL%BULK_ROWCOUNT(bulk_idx);
1453: end loop;
1454: 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 count: '||g_bulk_row_count);
1455:
1456:
1457: FORALL recno IN 1..t_enc_control_id.COUNT
1458: UPDATE psp_enc_controls

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

1793: -- for 2479579
1794: (select 1 from psp_enc_summary_lines S2
1795: where S2.status_code = 'L' and S1.enc_control_id = S2.enc_control_id
1796: and S2.superceded_line_id = l_sup_enc_summary_line_id);
1797: / * mark the change_flag in psp_Enc_lineS_history as well * /
1798: -- Update the change_flag to 'U' as per HQ review comment for Enh. 2143723
1799: / ***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation
1800: IF g_invalid_suspense ='N' THEN --Added for bug 2330057.
1801: update psp_Enc_lines_history

Line 1801: update psp_Enc_lines_history

1797: / * mark the change_flag in psp_Enc_lineS_history as well * /
1798: -- Update the change_flag to 'U' as per HQ review comment for Enh. 2143723
1799: / ***** Commented for Enh. 2768298 Removal of suspense posting in Liquidation
1800: IF g_invalid_suspense ='N' THEN --Added for bug 2330057.
1801: update psp_Enc_lines_history
1802: set change_flag= DECODE(p_action_type, 'Q', 'U', p_action_type)
1803: where enc_summary_line_id=l_sup_enc_summary_line_id
1804: and change_flag='N';
1805: END IF;

Line 1928: UPDATE psp_enc_lines_history

1924: END IF;
1925:
1926: -- After Liquidation, Identify and update the liquidated records and mark the unchanged records to 'N'
1927: -- to be picked up in a susequent update run
1928: UPDATE psp_enc_lines_history
1929: SET change_flag = 'L'
1930: WHERE change_flag = 'N'
1931: AND payroll_id = p_payroll_id;
1932:

Line 1936: UPDATE psp_enc_lines_history

1932:
1933: -- Introduced IF stmt instead of DECODE in WHERE clause for Quick Update Enh. 2143723 (perf. issue)
1934: -- As per HQ review comment, change_flag for Quick Update will be 'U' and not 'Q'
1935: IF (p_action_type = 'Q') THEN
1936: UPDATE psp_enc_lines_history
1937: SET change_flag = 'N'
1938: WHERE change_flag = 'U'
1939: AND payroll_id = p_payroll_id;
1940: ELSE

Line 1941: UPDATE psp_enc_lines_history

1937: SET change_flag = 'N'
1938: WHERE change_flag = 'U'
1939: AND payroll_id = p_payroll_id;
1940: ELSE
1941: UPDATE psp_enc_lines_history
1942: SET change_flag = 'N'
1943: WHERE change_flag = p_action_type
1944: AND payroll_id = p_payroll_id;
1945: END IF;

Line 2016: FROM psp_enc_lines_history pelh

2012: AND (pec.gl_phase IS NULL or pec.gl_phase = 'TieBack'))
2013: AND pesl.gl_project_flag = 'G'
2014: AND pesl.status_code = 'A'
2015: AND EXISTS (SELECT 1
2016: FROM psp_enc_lines_history pelh
2017: WHERE pelh.change_flag = 'N'
2018: AND pelh.enc_summary_line_id = pesl.enc_summary_line_id);
2019:
2020: CURSOR enc_upd_liq_cur IS

Line 2059: FROM psp_enc_lines_history pelh

2055: WHERE peca.assignment_id = pesl.assignment_id
2056: AND peca.request_id IS NOT NULL
2057: AND peca.payroll_id =p_payroll_id)
2058: AND EXISTS (SELECT 1
2059: FROM psp_enc_lines_history pelh
2060: WHERE pelh.change_flag = 'N'
2061: AND pelh.enc_summary_line_id = pesl.enc_summary_line_id);
2062:
2063: CURSOR enc_qupd_liq_cur IS

Line 2103: FROM psp_enc_lines_history pelh

2099: AND peca.request_id IS NOT NULL
2100: AND peca.payroll_id = p_payroll_id
2101: AND peca.change_type IN ('LS', 'ET', 'AS', 'QU'))
2102: AND EXISTS (SELECT 1
2103: FROM psp_enc_lines_history pelh
2104: WHERE pelh.change_flag = 'N'
2105: AND pelh.enc_summary_line_id = pesl.enc_summary_line_id);
2106:
2107: CURSOR emp_term_enc_liq_cur IS

Line 2143: FROM psp_enc_lines_history pelh

2139: AND gl_project_flag = 'G'
2140: AND status_code = 'A'
2141: AND person_id = g_person_id
2142: AND EXISTS (SELECT 1
2143: FROM psp_enc_lines_history pelh
2144: WHERE pelh.change_flag = 'N'
2145: AND pelh.enc_summary_line_id = pesl.enc_summary_line_id);
2146:
2147: TYPE t_number IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

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

2351: AND pesl.gl_project_flag = 'G'
2352: AND pesl.status_code = 'A'
2353: AND ((p_action_type='L' and g_person_id is null) --- g_person_id null check for 3413373
2354: OR (g_person_id is not null AND peSL.person_id = g_person_id
2355: AND EXISTS (SELECT 1 FROM PSP_ENC_LINES_HISTORY PELH WHERE PELH.ENC_SUMMARY_LINE_ID = PESL.ENC_SUMMARY_LINE_ID
2356: AND PELH.CHANGE_FLAG = 'N')
2357: AND peSL.time_period_id >= g_term_period_id)
2358: OR
2359: (p_action_type IN ('Q', 'U') AND EXISTS

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

2356: AND PELH.CHANGE_FLAG = 'N')
2357: AND peSL.time_period_id >= g_term_period_id)
2358: OR
2359: (p_action_type IN ('Q', 'U') AND EXISTS
2360: (SELECT 1 FROM PSP_ENC_LINES_HISTORY PELH WHERE PELH.ENC_SUMMARY_LINE_ID = PESL.ENC_SUMMARY_LINE_ID
2361: AND PELH.CHANGE_FLAG = 'N')
2362: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca
2363: WHERE peca.assignment_id = pesl.assignment_id
2364: AND peca.request_id IS NOT NULL

Line 2377: psp_enc_lines_history pelh, psp_enc_controls pec

2373: AND (p_action_type='L' or
2374: (p_action_type='U' and
2375: pelh.assignment_id IN
2376: (SELECT distinct pelh.assignment_id FROM
2377: psp_enc_lines_history pelh, psp_enc_controls pec
2378: WHERE pec.enc_control_id=p_enc_control_id AND
2379: pelh.time_period_id=pec.time_period_id and pelh.change_flag='N')));
2380: Above cursor modified for bug fixes 1832670 and 1776752
2381:

Line 3800: UPDATE psp_enc_lines_history

3796:
3797:
3798: IF (g_person_id IS NOT NULL) THEN
3799: FORALL recno IN 1..r_interface.enc_summary_line_id.COUNT
3800: UPDATE psp_enc_lines_history
3801: SET change_flag = 'L'
3802: WHERE enc_summary_line_id = (SELECT pesl2.superceded_line_id
3803: FROM psp_enc_summary_lines pesl2
3804: WHERE pesl2.enc_summary_line_id = r_interface.enc_summary_line_id(recno));

Line 3805: 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);

3801: SET change_flag = 'L'
3802: WHERE enc_summary_line_id = (SELECT pesl2.superceded_line_id
3803: FROM psp_enc_summary_lines pesl2
3804: WHERE pesl2.enc_summary_line_id = r_interface.enc_summary_line_id(recno));
3805: 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);
3806: END IF;
3807:
3808: FORALL recno IN 1..r_interface.enc_control_id.COUNT
3809: UPDATE psp_enc_controls pec

Line 4153: update psp_enc_lines_history

4149: and status_code = 'N';
4150:
4151: if g_person_id is not null then
4152: --- added following for 3477373
4153: update psp_enc_lines_history
4154: set change_flag = 'L'
4155: where enc_summary_line_id = ( select superceded_line_id
4156: from psp_enc_summary_lines
4157: where enc_summary_line_id = l_enc_summary_line_id);

Line 4464: FROM psp_enc_lines_history pelh

4460: AND (pec.gms_phase IS NULL or pec.gms_phase = 'TieBack'))
4461: AND gl_project_flag = 'P'
4462: AND status_code = 'A'
4463: AND EXISTS (SELECT 1
4464: FROM psp_enc_lines_history pelh
4465: WHERE pelh.change_flag = 'N'
4466: AND pelh.enc_summary_line_id = pesl.enc_summary_line_id);
4467:
4468: CURSOR enc_upd_liq_cur IS

Line 4514: FROM psp_enc_lines_history pelh

4510: WHERE peca.assignment_id = pesl.assignment_id
4511: AND peca.request_id IS NOT NULL
4512: AND peca.payroll_id = p_payroll_id)
4513: AND EXISTS (SELECT 1
4514: FROM psp_enc_lines_history pelh
4515: WHERE pelh.change_flag = 'N'
4516: AND pelh.enc_summary_line_id = pesl.enc_summary_line_id);
4517:
4518: CURSOR enc_qupd_liq_cur IS

Line 4565: FROM psp_enc_lines_history pelh

4561: AND peca.request_id IS NOT NULL
4562: AND peca.payroll_id = p_payroll_id
4563: AND peca.change_type IN ('LS', 'ET', 'AS', 'QU'))
4564: AND EXISTS (SELECT 1
4565: FROM psp_enc_lines_history pelh
4566: WHERE pelh.change_flag = 'N'
4567: AND pelh.enc_summary_line_id = pesl.enc_summary_line_id);
4568:
4569: CURSOR emp_term_enc_liq_cur IS

Line 4612: FROM psp_enc_lines_history pelh

4608: AND gl_project_flag = 'P'
4609: AND status_code = 'A'
4610: AND person_id = g_person_id
4611: AND EXISTS (SELECT 1
4612: FROM psp_enc_lines_history pelh
4613: WHERE pelh.change_flag = 'N'
4614: AND pelh.enc_summary_line_id = pesl.enc_summary_line_id);
4615:
4616: TYPE t_number IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

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

4851: AND pesl.status_code = 'A'
4852: AND pesl.gl_code_combination_id is NULL
4853: AND ( (p_action_type='L' and g_person_id is null) --- g_person_id null check for 3413373
4854: OR (g_person_id is not null AND peSL.person_id = g_person_id
4855: AND EXISTS (SELECT 1 FROM PSP_ENC_LINES_HISTORY PELH WHERE PELH.ENC_SUMMARY_LINE_ID = PESL.ENC_SUMMARY_LINE_ID
4856: AND PELH.CHANGE_FLAG = 'N')
4857: AND peSL.time_period_id >= g_term_period_id)
4858: OR
4859: (p_action_type IN ('Q', 'U') AND EXISTS

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

4856: AND PELH.CHANGE_FLAG = 'N')
4857: AND peSL.time_period_id >= g_term_period_id)
4858: OR
4859: (p_action_type IN ('Q', 'U') AND EXISTS
4860: (SELECT 1 FROM PSP_ENC_LINES_HISTORY PELH WHERE PELH.ENC_SUMMARY_LINE_ID = PESL.ENC_SUMMARY_LINE_ID
4861: AND PELH.CHANGE_FLAG = 'N')
4862: AND EXISTS (SELECT 1 FROM psp_enc_changed_assignments peca
4863: WHERE peca.assignment_id = pesl.assignment_id
4864: AND peca.request_id IS NOT NULL

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

4872: AND outer.change_flag='N';
4873:
4874: AND (p_action_type='L') or
4875: (p_action_type='U' and
4876: pesl.assignment_id in (select pelh.assignment_id FROM psp_enc_lines_history pelh,
4877: psp_enc_controls pec
4878: where pec.enc_control_id=p_enc_control_id AND
4879: pelh.time_period_id=pec.time_period_id
4880: and pelh.change_flag='N'));

Line 6564: UPDATE psp_enc_lines_history

6560: 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 count:'||g_bulk_row_count);
6561:
6562: IF (g_person_id IS NOT NULL) THEN
6563: FORALL recno IN 1..r_reject_recs.enc_summary_line_id.COUNT
6564: UPDATE psp_enc_lines_history
6565: SET change_flag = 'L'
6566: WHERE enc_summary_line_id IN (SELECT superceded_line_id
6567: FROM psp_enc_summary_lines pesl
6568: WHERE pesl.enc_summary_line_id = r_reject_recs.enc_summary_line_id(recno))

Line 6578: 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 count'||g_bulk_row_count);

6574: loop
6575: g_bulk_row_count := g_bulk_row_count + SQL%BULK_ROWCOUNT(bulk_idx);
6576: end loop;
6577:
6578: 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 count'||g_bulk_row_count);
6579: END IF;
6580:
6581: OPEN get_success_recs_cur;
6582: FETCH get_success_recs_cur BULK COLLECT INTO r_success_recs.enc_control_id, r_success_recs.enc_summary_line_id,

Line 6653: update psp_enc_lines_history

6649: -- and enc_control_id=p_enc_control_id;
6650:
6651: ---- added for 3477373
6652: if g_person_id is not null then
6653: update psp_enc_lines_history
6654: set change_flag = 'L'
6655: where enc_summary_line_id = ( select superceded_line_id
6656: from psp_enc_summary_lines
6657: where enc_summary_line_id = to_number(l_orig_trx_reference));

Line 6945: UPDATE psp_enc_lines_history

6941: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated status_code to ''L'' in psp_enc_summary_lines '||g_bulk_row_count);
6942:
6943: IF (g_person_id IS NOT NULL) THEN
6944: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT
6945: UPDATE psp_enc_lines_history
6946: SET change_flag = 'L'
6947: WHERE enc_summary_line_id IN (SELECT superceded_line_id
6948: FROM psp_enc_summary_lines pesl
6949: WHERE pesl.enc_summary_line_id = r_success_recs.enc_summary_line_id(recno));

Line 6957: 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 count'||g_bulk_row_count);

6953: loop
6954: g_bulk_row_count := g_bulk_row_count + SQL%BULK_ROWCOUNT(bulk_idx);
6955: end loop;
6956:
6957: 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 count'||g_bulk_row_count);
6958: END IF;
6959:
6960: FORALL recno IN 1..r_success_recs.enc_summary_line_id.COUNT
6961: UPDATE psp_enc_controls pec

Line 6998: update psp_enc_lines_history

6994: and status_code = 'N';
6995:
6996: ---- added for 3477373
6997: if g_person_id is not null then
6998: update psp_enc_lines_history
6999: set change_flag = 'L'
7000: where enc_summary_line_id = ( select superceded_line_id
7001: from psp_enc_summary_lines
7002: where enc_summary_line_id = l_enc_summary_line_id);

Line 7252: --- psp_enc_lines_history has index on assignment

7248: p_set_of_books_id in number,
7249: p_person_id in number,
7250: p_actual_term_date in date) is
7251: ---- there is no index on person/assignment on psp_enc_summary_lines
7252: --- psp_enc_lines_history has index on assignment
7253: cursor get_enc_hist_lines_cur is
7254: select ESL.payroll_id payroll_id,
7255: min(ESL.time_period_id) time_period_id
7256: from psp_enc_lines_history ELH,

Line 7256: from psp_enc_lines_history ELH,

7252: --- psp_enc_lines_history has index on assignment
7253: cursor get_enc_hist_lines_cur is
7254: select ESL.payroll_id payroll_id,
7255: min(ESL.time_period_id) time_period_id
7256: from psp_enc_lines_history ELH,
7257: psp_enc_summary_lines ESL,
7258: per_all_assignments_f ASG
7259: where ASG.person_id = p_person_id
7260: and ASG.assignment_id = ELH.assignment_id