[Home] [Help]
1460:
1461: /****************************************************************************************************
1462: Procedure Name: VALIDATE_TRANSACTION_CONTROLS
1463: Purpose: This Procedure is used to log assignments for those records which modified in
1464: pa_transaction_controls after the last creation date of encumbrance for a
1465: payroll.
1466: ****************************************************************************************************/
1467:
1468: PROCEDURE validate_transaction_controls (p_project_id IN NUMBER,
1481:
1482: /* CURSOR to verify modification in pa_trancation_controls after the last creation date */
1483: CURSOR patc_change_cur IS
1484: SELECT patc.project_id
1485: FROM pa_transaction_controls patc
1486: WHERE patc.project_id = p_project_id
1487: AND patc.last_update_date > l_enc_cr_date
1488: AND rownum = 1;
1489:
1487: AND patc.last_update_date > l_enc_cr_date
1488: AND rownum = 1;
1489:
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
1524:
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;