APPS.HR_DU_UTILITY dependencies on HR_DU_UPLOADS

Line 536: -- Description: Reads the status of the passed phase from the hr_du_uploads

532:
533:
534:
535: -- ------------------------- get_uploads_status ------------------------
536: -- Description: Reads the status of the passed phase from the hr_du_uploads
537: -- table.
538: --
539: -- Input Parameters
540: -- p_upload_id - upload id of current uploads

Line 558: FROM hr_du_uploads

554: l_phase_status VARCHAR2(30);
555:
556: CURSOR csr_status IS
557: SELECT status
558: FROM hr_du_uploads
559: WHERE (upload_id = p_upload_id);
560:
561: --
562: BEGIN

Line 730: -- Description: Updates the status of the uploads in the hr_du_uploads

726: -- update status procedures
727: -- start
728:
729: -- ------------------------- update_uploads ------------------------
730: -- Description: Updates the status of the uploads in the hr_du_uploads
731: -- table. If the status is to be set to C then all child entries in
732: -- hr_du_headers are checked to ensure that they have completed.
733: --
734: -- Input Parameters

Line 747: -- table is hr_du_uploads

743:
744: --
745: PROCEDURE update_uploads (p_new_status IN VARCHAR2, p_id IN NUMBER) IS
746: --
747: -- table is hr_du_uploads
748: -- parent of hr_du_upload_headers
749: -- child of (none)
750:
751: l_complete VARCHAR2(30);

Line 770: UPDATE hr_du_uploads

766:
767: -- non-complete
768: IF (p_new_status IN('S', 'NS', 'E')) THEN
769: -- update the status for this row
770: UPDATE hr_du_uploads
771: SET status = p_new_status
772: WHERE upload_id = p_id;
773: COMMIT;
774: END IF;

Line 786: UPDATE hr_du_uploads

782:
783: IF (csr_child_table_complete%NOTFOUND) THEN
784: -- update the status for this row since no child rows
785: -- are incomplete
786: UPDATE hr_du_uploads
787: SET status = p_new_status
788: WHERE upload_id = p_id;
789: COMMIT;
790: END IF;

Line 901: -- child of hr_du_uploads

897: PROCEDURE update_upload_headers (p_new_status IN VARCHAR2, p_id IN NUMBER) IS
898: --
899: -- table is hr_du_upload_headers
900: -- parent of hr_du_upload_lines
901: -- child of hr_du_uploads
902:
903: l_parent_table_id NUMBER(9);
904: l_complete VARCHAR2(30);
905: l_new_status VARCHAR2(30);