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_CHANGED_ASSIGNMENTS

Line 150: delete from psp_enc_changed_assignments a

146: -- End of changes for bug fix 3434626
147:
148: -- Code chages for bug 4203036
149: -- To delete all the unwanted records in poeta pre-process
150: delete from psp_enc_changed_assignments a
151: where exists
152: (select 1 from per_all_assignments_f b
153: where b.assignment_id = a.assignment_id
154: and b.effective_end_date = to_date('31-12-4712','DD-MM-RRRR'))

Line 252: psp_enc_changed_assignments if the poeta dates are different from previous

248: /****************************************************************************************************
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,

Line 418: are changed) into psp_enc_changed_assignments */

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);
422: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

Line 474: psp_enc_changed_assignments if the poeta dates are different from previous

470: /****************************************************************************************************
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,

Line 699: /* Inserting into psp_enc_changed_assignments */

695: l_proc_step := 80;
696: -- End of bug fix 3434626
697:
698: IF (p_pre_process_mode = 'R') THEN
699: /* Inserting into psp_enc_changed_assignments */
700: IF j> 1 then -- bug fix 2597666
701: insert_changed_assignments (p_change_type => 'PT',
702: p_return_status => p_return_status);
703: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

Line 730: assignments in psp_enc_changed_assignments table if the poeta dates are

726: /****************************************************************************************************
727: Procedure Name: update_default_labor_schedules
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:

Line 897: changed) into psp_enc_changed_assignments table*/

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);
901: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

Line 957: psp_enc_changed_assignments table if the poeta dates are different from

953: /****************************************************************************************************
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:

Line 1124: changed) into psp_enc_changed_assignments table */

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);
1128: IF (p_return_status <> fnd_api.g_ret_sts_success) THEN

Line 1529: last creation date will logged into psp_enc_changed_assignments for a particular payroll; */

1525: l_proc_step := 20;
1526: -- End of bug fix 3434626
1527:
1528: /* All the assignments for which records are modified in pa_transaction_controls after the
1529: last creation date will logged into psp_enc_changed_assignments for a particular payroll; */
1530:
1531: IF l_enc_cr_date IS NOT NULL THEN
1532: OPEN patc_change_cur;
1533: FETCH patc_change_cur INTO l_project_id;

Line 1587: Purpose: This Procedure inserts identified assignments into psp_enc_changed_assignments

1583: END validate_transaction_controls;
1584:
1585: /****************************************************************************************************
1586: Procedure Name: INSERT_CHANGED_ASSIGNMENTS
1587: Purpose: This Procedure inserts identified assignments into psp_enc_changed_assignments
1588: table.
1589: ****************************************************************************************************/
1590:
1591: PROCEDURE insert_changed_assignments (p_change_type IN VARCHAR2,

Line 1609: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS

1605: ' r_asg_id_array.r_asg_id.COUNT: ' || fnd_number.number_to_canonical(r_asg_id_array.r_asg_id.COUNT));
1606: -- End of bug fix 3434626
1607:
1608: FORALL k in 1 .. r_asg_id_array.r_asg_id.count
1609: INSERT INTO PSP_ENC_CHANGED_ASSIGNMENTS
1610: (request_id, assignment_id, payroll_id,
1611: change_type, processed_flag, reference_id, action_type)
1612: VALUES (g_request_id, r_asg_id_array.r_asg_id(k), r_asg_id_array.r_payroll_id(k),
1613: p_change_type, NULL, p_reference_id, p_action_type);

Line 1832: UPDATE psp_enc_changed_assignments peca

1828: l_proc_step := 10;
1829: -- End of bug fix 3434626
1830:
1831: IF (p_enc_line_type = 'Q') THEN
1832: UPDATE psp_enc_changed_assignments peca
1833: SET request_id = g_request_id
1834: WHERE peca.payroll_id = p_payroll_id
1835: AND change_type IN ('AS', 'ET', 'LS', 'QU');
1836:

Line 1844: UPDATE psp_enc_changed_assignments peca

1840: -- End of changed for bug fix 3434626
1841:
1842: RETURN;
1843: ELSE
1844: UPDATE psp_enc_changed_assignments peca
1845: SET request_id = g_request_id
1846: WHERE peca.payroll_id = p_payroll_id;
1847:
1848: -- Introduced the following for bug fix 3434626