APPS.IGS_AS_PROD_DOC dependencies on IGS_AS_ORDER_HDR

Line 584: FROM igs_as_order_hdr

580: -- Cursor to check if the user_name being added to the Adhoc Role is already duplicated
581: --
582: CURSOR cur_order_details (cp_order_number IN NUMBER) IS
583: SELECT request_type
584: FROM igs_as_order_hdr
585: WHERE order_number = cp_order_number;
586: --
587: l_date_prod VARCHAR2(30);
588: l_doc_type VARCHAR2(30);

Line 685: update the Order status (IGS_AS_ORDER_HDR.ORDER_STATUS)

681: Purpose : Update Order Docs interface table with the item status
682: (IGS_AS_ORD_ITM_INT.ITEM_STATUS) to PROCESSED and
683: the line item status (IGS_AS_DOC_DETAILS.ITEM_STATUS)
684: to PROCESSED. Also if all the items are processed,
685: update the Order status (IGS_AS_ORDER_HDR.ORDER_STATUS)
686: to COMPLETED.
687: Remarks :
688: Change History
689: Who When What

Line 709: -- Cursor to fetch order number from IGS_AS_ORDER_HDR and update order status

705: FROM igs_as_doc_details dd
706: WHERE dd.item_number = cp_item_number
707: AND NVL (missing_acad_record_data_ind, 'N') = 'N';
708: --
709: -- Cursor to fetch order number from IGS_AS_ORDER_HDR and update order status
710: -- to COMPLETED if all the line items are PROCESSED
711: --
712: CURSOR c_order_hdr IS
713: SELECT oh.rowid, oh.*

Line 714: FROM igs_as_order_hdr oh

710: -- to COMPLETED if all the line items are PROCESSED
711: --
712: CURSOR c_order_hdr IS
713: SELECT oh.rowid, oh.*
714: FROM igs_as_order_hdr oh
715: WHERE oh.order_status = 'INPROCESS'
716: AND NOT EXISTS (SELECT 'x'
717: FROM igs_as_doc_details dd
718: WHERE dd.order_number = oh.order_number

Line 865: -- Fetch order number from IGS_AS_ORDER_HDR and update order status

861: x_person_id => rec_doc_details.person_id
862: );
863: END LOOP;
864: --
865: -- Fetch order number from IGS_AS_ORDER_HDR and update order status
866: -- to COMPLETED if all the line items are PROCESSED
867: --
868: FOR rec_order_hdr IN c_order_hdr
869: LOOP

Line 870: igs_as_order_hdr_pkg.update_row(

866: -- to COMPLETED if all the line items are PROCESSED
867: --
868: FOR rec_order_hdr IN c_order_hdr
869: LOOP
870: igs_as_order_hdr_pkg.update_row(
871: x_msg_count => l_msg_count,
872: x_msg_data => l_msg_data,
873: x_return_status => l_return_status,
874: x_rowid => rec_order_hdr.rowid,