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

Line 253: poeta dates and assignments exists in psp_enc_lines_history table.

249: Procedure Name: UPDATE_GLOBAL_EARNING_ELEMENTS
250: Purpose: This procedure is called in the main procedure and used for updating poeta
251: dates in psp_element_type_accounts for poeta CI It inserts assignments in
252: psp_enc_changed_assignments if the poeta dates are different from previous
253: poeta dates and assignments exists in psp_enc_lines_history table.
254: ****************************************************************************************************/
255:
256: PROCEDURE update_global_earning_elements (p_pre_process_mode IN VARCHAR2,
257: p_payroll_id IN NUMBER,

Line 311: FROM psp_enc_lines_history pelh

307:
308: CURSOR assignment_payroll_cur(j number) IS
309: SELECT DISTINCT pelh.assignment_id,
310: pelh.payroll_id
311: FROM psp_enc_lines_history pelh
312: WHERE pelh.element_account_id = r_global_control_rec.r_global_line_id (j)
313: AND pelh.suspense_org_account_id is NULL
314: AND pelh.change_flag = 'N';
315:

Line 417: /* Insert assignments (exists in psp_enc_lines_history and poeta dates

413: hr_utility.trace('r_asg_id_array.r_asg_id.count: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.count));
414: l_proc_step := 40;
415: -- End of bug fix 3434626
416:
417: /* Insert assignments (exists in psp_enc_lines_history and poeta dates
418: are changed) into psp_enc_changed_assignments */
419: IF r_asg_id_array.r_asg_id.count<>0 THEN
420: insert_changed_assignments (p_change_type => 'PT',
421: p_return_status => p_return_status);

Line 475: poeta dates and assignments exist in psp_enc_lines_history table.

471: Procedure Name: UPDATE_SCHEDULES
472: Purpose: This procedure is called in the main procedure and used for updating poeta
473: dates psp_schedule_lines for poeta CI. It inserts assignments in
474: psp_enc_changed_assignments if the poeta dates are different from previous
475: poeta dates and assignments exist in psp_enc_lines_history table.
476: ****************************************************************************************************/
477:
478: PROCEDURE update_schedules (p_pre_process_mode IN VARCHAR2,
479: p_payroll_id IN NUMBER,

Line 732: psp_enc_lines_history table.

728: Purpose: This procedure is called in the main procedure and used for updating poeta
729: dates in psp_org_default_labor_schedules table for poeta CI. It inserts
730: assignments in psp_enc_changed_assignments table if the poeta dates are
731: different from previous poeta dates and assignments exists in
732: psp_enc_lines_history table.
733: ****************************************************************************************************/
734:
735: PROCEDURE update_default_labor_schedules (p_pre_process_mode IN VARCHAR2,
736: p_payroll_id IN NUMBER,

Line 784: FROM psp_enc_lines_history pelh

780: ORDER BY 2,3,4,5,6;
781:
782: CURSOR assignment_payroll_cur(j number) IS
783: SELECT DISTINCT pelh.assignment_id,pelh.payroll_id
784: FROM psp_enc_lines_history pelh
785: -- Modified default_org_account_id to org_schedule_id for bug 2334434
786: WHERE pelh.org_schedule_id = r_ls_control_rec.r_org_schedule_id (j)
787: AND pelh.suspense_org_account_id IS NULL
788: AND pelh.change_flag = 'N';

Line 896: /* Insert assignments (exists in psp_enc_lines_history and poeta dates are

892: -- Introduced for bug fix 3434626
893: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));
894: l_proc_step := 40;
895: -- End of bug fix 3434626
896: /* Insert assignments (exists in psp_enc_lines_history and poeta dates are
897: changed) into psp_enc_changed_assignments table*/
898: IF r_asg_id_array.r_asg_id.count<>0 THEN
899: insert_changed_assignments (p_change_type => 'PT',
900: p_return_status => p_return_status);

Line 958: previous poeta dates and assignments exists in psp_enc_lines_history

954: Procedure Name: UPDATE_DEFAULT_SUSP_ACCOUNTS
955: Purpose: This procedure is called in the main procedure and used for updating poeta
956: dates in psp_organization_accounts for poeta CI. It inserts assignments in
957: psp_enc_changed_assignments table if the poeta dates are different from
958: previous poeta dates and assignments exists in psp_enc_lines_history
959: table.
960: ****************************************************************************************************/
961:
962: PROCEDURE update_default_susp_accounts (p_pre_process_mode IN VARCHAR2,

Line 1012: FROM psp_enc_lines_history pelh

1008:
1009: CURSOR assignment_payroll_cur(j number) IS
1010: SELECT DISTINCT pelh.assignment_id,
1011: pelh.payroll_id
1012: FROM psp_enc_lines_history pelh
1013: WHERE NVL(suspense_org_account_id, default_org_account_id) = r_susp_control_rec.r_organization_account_id (j)
1014: AND pelh.change_flag = 'N';
1015:
1016: -- Introduced for bug fix 3434626

Line 1123: /* Insert assignments (exists in psp_enc_lines_history and poeta dates are

1119: hr_utility.trace('r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));
1120: l_proc_step := 40;
1121: -- End of bug fix 3434626
1122:
1123: /* Insert assignments (exists in psp_enc_lines_history and poeta dates are
1124: changed) into psp_enc_changed_assignments table */
1125: IF r_asg_id_array.r_asg_id.count<>0 THEN
1126: insert_changed_assignments (p_change_type => 'PT',
1127: p_return_status => p_return_status);

Line 1494: FROM psp_enc_lines_history pelh

1490: /* CURSOR to find all assignments that were modified after last enc creation date in
1491: pa_transaction_controls */
1492: CURSOR tx_control_asg_cur IS
1493: SELECT pelh.assignment_id, p_payroll_id
1494: FROM psp_enc_lines_history pelh
1495: WHERE pelh.project_id = p_project_id
1496: AND pelh.payroll_id = p_payroll_id
1497: AND pelh.change_flag = 'N' --Added for bug 2334434
1498: GROUP BY pelh.assignment_id,p_payroll_id;

Line 1672: FROM psp_enc_lines_history pelh

1668: /* Following cursor finds out NOCOPY assignments affected by changes to Org Default LS */
1669: CURSOR assignment_payroll_ds_upd_cur(p_reference_id NUMBER) IS
1670: SELECT DISTINCT pelh.assignment_id,
1671: pelh.payroll_id
1672: FROM psp_enc_lines_history pelh
1673: WHERE pelh.change_flag = 'N'
1674: AND pelh.org_schedule_id = p_reference_id;
1675:
1676: /* Following cursor finds out NOCOPY assignments affected by changes to Org Default Account */

Line 1680: FROM psp_enc_lines_history pelh

1676: /* Following cursor finds out NOCOPY assignments affected by changes to Org Default Account */
1677: CURSOR assignment_payroll_da_upd_cur (p_reference_id NUMBER) IS
1678: SELECT DISTINCT pelh.assignment_id,
1679: pelh.payroll_id
1680: FROM psp_enc_lines_history pelh
1681: WHERE pelh.default_org_account_id = p_reference_id
1682: AND pelh.change_flag = 'N' ; --Added for bug 2334434;
1683:
1684: /* Following cursor finds out NOCOPY assignments affected by changes to Org Suspense Account

Line 1689: FROM psp_enc_lines_history pelh

1685: Same query is used for GS updates, hence this cursor will be reused */
1686: CURSOR assignment_payroll_sa_upd_cur (p_reference_id NUMBER) IS
1687: SELECT DISTINCT pelh.assignment_id,
1688: pelh.payroll_id
1689: FROM psp_enc_lines_history pelh
1690: WHERE pelh.change_flag = 'N'
1691: AND pelh.suspense_org_account_id = p_reference_id;
1692:
1693: /* Following cursor finds out NOCOPY assignments affected by changes to Global Earning Elements */

Line 1697: FROM psp_enc_lines_history pelh

1693: /* Following cursor finds out NOCOPY assignments affected by changes to Global Earning Elements */
1694: CURSOR assignment_payroll_ge_upd_cur (p_reference_id NUMBER) IS
1695: SELECT DISTINCT pelh.assignment_id,
1696: pelh.payroll_id
1697: FROM psp_enc_lines_history pelh
1698: WHERE pelh.change_flag = 'N'
1699: AND pelh.element_account_id = p_reference_id;
1700:
1701: /* Following cursor finds out NOCOPY assignments affected by changes to Enc Payroll Assignments */

Line 1705: FROM psp_enc_lines_history pelh

1701: /* Following cursor finds out NOCOPY assignments affected by changes to Enc Payroll Assignments */
1702: CURSOR assignment_payroll_ex_upd_cur (p_reference_id NUMBER) IS
1703: SELECT DISTINCT pelh.assignment_id,
1704: pelh.payroll_id
1705: FROM psp_enc_lines_history pelh
1706: WHERE pelh.change_flag = 'N'
1707: AND pelh.assignment_id = p_reference_id;
1708:
1709: /* Following cursor finds out NOCOPY impacted assignments for new Global Earning Elements */

Line 1713: FROM psp_enc_lines_history pelh

1709: /* Following cursor finds out NOCOPY impacted assignments for new Global Earning Elements */
1710: CURSOR global_element_insert_cur (p_reference_id NUMBER) IS
1711: SELECT DISTINCT pelh.assignment_id,
1712: pelh.payroll_id
1713: FROM psp_enc_lines_history pelh
1714: WHERE pelh.enc_element_type_id = p_reference_id
1715: AND pelh.element_account_id IS NULL
1716: AND pelh.change_flag = 'N';
1717:

Line 1722: FROM psp_enc_lines_history pelh,

1718: /* Following cursor finds all assignments impacted because of Org. Default LS Inserts */
1719: CURSOR org_ds_insert_cur (p_reference_id NUMBER) IS
1720: SELECT DISTINCT pelh.assignment_id,
1721: pelh.payroll_id
1722: FROM psp_enc_lines_history pelh,
1723: per_assignments_f paf
1724: WHERE pelh.schedule_line_id IS NULL
1725: AND pelh.element_account_id IS NULL
1726: AND pelh.change_flag = 'N'

Line 1737: FROM psp_enc_lines_history pelh,

1733: /* Following cursor would identify assignments impacted by Org. Default Account Inserts */
1734: CURSOR org_da_insert_cur (p_reference_id NUMBER) IS
1735: SELECT DISTINCT pelh.assignment_id,
1736: pelh.payroll_id
1737: FROM psp_enc_lines_history pelh,
1738: per_assignments_f paf
1739: WHERE pelh.suspense_org_account_id IS NOT NULL
1740: AND pelh.suspense_reason_code IN ('LDM_NO_CI_FOUND', 'LDM_BAL_NOT_100_PERCENT')
1741: AND paf.organization_id = p_reference_id

Line 1749: FROM psp_enc_lines_history pelh,

1745: /* Following cursor finds out NOCOPY assignments impacted because of Org. Suspense Accounts */
1746: CURSOR org_sa_insert_cur (p_reference_id NUMBER) IS
1747: SELECT DISTINCT pelh.assignment_id,
1748: pelh.payroll_id
1749: FROM psp_enc_lines_history pelh,
1750: per_assignments_f paf,
1751: psp_organization_accounts poa
1752: WHERE pelh.suspense_org_account_id = poa.organization_account_id
1753: AND poa.organization_id = l_generic_suspense

Line 1772: FROM psp_enc_lines_history pelh

1768: CURSOR default_end_date_dec_cur IS
1769: SELECT DISTINCT
1770: assignment_id,
1771: payroll_id
1772: FROM psp_enc_lines_history pelh
1773: -- psp_enc_end_dates peed Commented for bug fix 4507892
1774: WHERE pelh.change_flag = 'N'
1775: AND pelh.encumbrance_date > l_period_end_date;
1776: -- End of bug fix 3426871

Line 1785: FROM psp_enc_lines_history pelh,

1781: CURSOR default_org_end_date_asg_cur IS
1782: SELECT DISTINCT --Added distinct for bug 2664991.
1783: pelh.assignment_id,
1784: pelh.payroll_id
1785: FROM psp_enc_lines_history pelh,
1786: psp_default_labor_schedules pdls,
1787: psp_schedule_lines psl,
1788: psp_element_type_accounts peta,
1789: per_assignments_f paf

Line 1796: FROM psp_enc_lines_history pelhin

1792: WHERE pelh.assignment_id = paf.assignment_id
1793: AND pelh.change_flag = 'N'
1794: AND pelh.gl_code_combination_id IS NULL
1795: AND pelh.encumbrance_date = (SELECT MIN(pelhin.encumbrance_date)
1796: FROM psp_enc_lines_history pelhin
1797: WHERE pelhin.assignment_id = pelh.assignment_id
1798: -- AND pelhin.encumbrance_date > peed.period_end_date)
1799: -- AND pelhin.encumbrance_date > peed.prev_enc_end_date) --Added for bug 2396983. Commented for bug 3426871
1800: AND pelhin.encumbrance_date > l_prev_enc_end_date) -- Introduced for bug fix 3426871

Line 1814: FROM psp_enc_lines_history pelh

1810: --For Bug fix 2370841:Following cursor finds out NOCOPY assignments affected by Enc element Selection changes
1811: CURSOR element_ed_ins_upd_cur (p_reference_id NUMBER) IS
1812: SELECT DISTINCT pelh.assignment_id,
1813: pelh.payroll_id
1814: FROM psp_enc_lines_history pelh
1815: WHERE pelh.change_flag = 'N'
1816: AND pelh.enc_element_type_id = p_reference_id;
1817: --End of bug fix 2370841
1818: