APPS.HR_DU_UTILITY dependencies on HR_DU_UPLOAD_LINES

Line 664: -- Description: Reads the status of the passed phase from the hr_du_upload_lines

660: END get_upload_headers_status;
661:
662:
663: -- ------------------------- get_upload_lines_status ------------------------
664: -- Description: Reads the status of the passed phase from the hr_du_upload_lines
665: -- table.
666: --
667: --
668: -- Input Parameters

Line 688: FROM hr_du_upload_lines

684: l_phase_status VARCHAR2(30);
685:
686: CURSOR csr_status IS
687: SELECT status
688: FROM hr_du_upload_lines
689: WHERE (upload_line_id = p_upload_lines_id);
690:
691: --
692: BEGIN

Line 812: -- hr_du_upload_lines table. If the status is to be set to C or E then

808:
809:
810: -- ------------------------- update_upload_lines ----------------------
811: -- Description: Updates the status of the upload lines in the
812: -- hr_du_upload_lines table. If the status is to be set to C or E then
813: -- the update status is cascaded up to the parent phase.
814: --
815: --
816: -- Input Parameters

Line 829: -- table is hr_du_upload_lines

825:
826: --
827: PROCEDURE update_upload_lines (p_new_status IN VARCHAR2, p_id IN NUMBER) IS
828: --
829: -- table is hr_du_upload_lines
830: -- parent of n/a
831: -- child of hr_du_upload_headers
832:
833: l_parent_table_id NUMBER(9);

Line 838: FROM hr_du_upload_lines

834:
835: -- find parent table id
836: CURSOR csr_parent_id IS
837: SELECT upload_header_id
838: FROM hr_du_upload_lines
839: WHERE upload_line_id = p_id;
840:
841: --
842: BEGIN

Line 850: UPDATE hr_du_upload_lines

846: message('PARA','(p_new_status - ' || p_new_status ||
847: ')(p_id - ' || p_id || ')', 10);
848:
849: -- update the status for this row
850: UPDATE hr_du_upload_lines
851: SET status = p_new_status
852: WHERE upload_line_id = p_id;
853: COMMIT;
854:

Line 882: -- the status of all the child rows in the hr_du_upload_lines are

878: -- ------------------------- update_upload_headers ----------------------
879: -- Description: Updates the status of the upload header in the
880: -- hr_du_upload_headers table. If the status is to be set to C or E then
881: -- the update status is cascaded up to the parent phase. For a C,
882: -- the status of all the child rows in the hr_du_upload_lines are
883: -- checked.
884: --
885: --
886: -- Input Parameters

Line 900: -- parent of hr_du_upload_lines

896: --
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);

Line 910: FROM hr_du_upload_lines

906:
907: -- search child table for all complete
908: CURSOR csr_child_table_complete IS
909: SELECT status
910: FROM hr_du_upload_lines
911: WHERE ((upload_header_id = p_id)
912: AND (status <> 'C'));
913:
914: -- find parent table id