APPS.PSP_ENC_LIQ_TRAN dependencies on PSP_ENC_PROCESSES

Line 1490: UPDATE psp_enc_processes

1486: end loop;
1487: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated action_code to ''P'' in psp_enc_controls for control records whose enc summary lines aren''t completely liquidated count'||g_bulk_row_count);
1488:
1489:
1490: UPDATE psp_enc_processes
1491: SET process_phase = 'completed',
1492: process_status = 'P'
1493: WHERE payroll_action_id = p_payroll_action_id
1494: AND process_code = 'ST'

Line 1504: UPDATE psp_enc_processes

1500: IF (SQL%ROWCOUNT> 0) THEN
1501: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase to completed as no summarize and transfer is required');
1502: END IF;
1503:
1504: UPDATE psp_enc_processes
1505: SET process_phase = 'summarize_transfer'
1506: WHERE payroll_action_id = p_payroll_action_id
1507: AND process_code = 'ST'
1508: AND EXISTS (SELECT 1

Line 1518: UPDATE psp_enc_processes

1514: IF (SQL%ROWCOUNT> 0) THEN
1515: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Updated process_phase to summarize_transfer as there are new lines to be suimmarized and transferred');
1516: END IF;
1517:
1518: UPDATE psp_enc_processes
1519: SET process_phase = 'liquidate'
1520: WHERE payroll_action_id = p_payroll_action_id
1521: AND process_code = 'ST'
1522: AND EXISTS (SELECT 1