APPS.PSP_ENC_LIQ_TRAN dependencies on PSP_ENC_PROCESSES

Line 1447: UPDATE psp_enc_processes

1443: AND status_code = 'A');
1444:
1445: 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');
1446:
1447: UPDATE psp_enc_processes
1448: SET process_phase = 'completed',
1449: process_status = 'P'
1450: WHERE payroll_action_id = p_payroll_action_id
1451: AND process_code = 'ST'

Line 1461: UPDATE psp_enc_processes

1457: IF (SQL%ROWCOUNT> 0) THEN
1458: 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');
1459: END IF;
1460:
1461: UPDATE psp_enc_processes
1462: SET process_phase = 'summarize_transfer'
1463: WHERE payroll_action_id = p_payroll_action_id
1464: AND process_code = 'ST'
1465: AND EXISTS (SELECT 1

Line 1475: UPDATE psp_enc_processes

1471: IF (SQL%ROWCOUNT> 0) THEN
1472: 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');
1473: END IF;
1474:
1475: UPDATE psp_enc_processes
1476: SET process_phase = 'liquidate'
1477: WHERE payroll_action_id = p_payroll_action_id
1478: AND process_code = 'ST'
1479: AND EXISTS (SELECT 1