APPS.IGS_AS_PROD_DOC dependencies on IGS_AS_DOC_DETAILS

Line 683: the line item status (IGS_AS_DOC_DETAILS.ITEM_STATUS)

679: Created By : Sameer Manglm
680: Date Created By : 22-AUG-2002
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 :

Line 703: CURSOR c_doc_details (cp_item_number igs_as_doc_details.item_number%TYPE) IS

699: --
700: -- Cursor to fetch the records from Order Item Interface Table.
701: -- Discontinue automatic posting of Completion for documents having Missing Academic Records
702: --
703: CURSOR c_doc_details (cp_item_number igs_as_doc_details.item_number%TYPE) IS
704: SELECT dd.rowid, dd.*
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';

Line 705: FROM igs_as_doc_details dd

701: -- Discontinue automatic posting of Completion for documents having Missing Academic Records
702: --
703: CURSOR c_doc_details (cp_item_number igs_as_doc_details.item_number%TYPE) IS
704: SELECT dd.rowid, dd.*
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

Line 717: FROM igs_as_doc_details dd

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
719: AND dd.item_status <> 'PROCESSED');
720: --
721: l_return_status VARCHAR2(1);

Line 739: -- Update IGS_AS_DOC_DETAILS.ITEM_STATUS and date_produced to sysdate

735: WHERE item_number = p_item_number
736: AND NVL (missing_acad_record_data_ind, 'N') = 'N';
737: END LOOP;
738: --
739: -- Update IGS_AS_DOC_DETAILS.ITEM_STATUS and date_produced to sysdate
740: --
741: FOR rec_doc_details IN c_doc_details (p_item_number)
742: LOOP
743: igs_as_doc_details_pkg.update_row (

Line 743: igs_as_doc_details_pkg.update_row (

739: -- Update IGS_AS_DOC_DETAILS.ITEM_STATUS and date_produced to sysdate
740: --
741: FOR rec_doc_details IN c_doc_details (p_item_number)
742: LOOP
743: igs_as_doc_details_pkg.update_row (
744: x_rowid => rec_doc_details.rowid,
745: x_order_number => rec_doc_details.order_number,
746: x_document_type => rec_doc_details.document_type,
747: x_document_sub_type => rec_doc_details.document_sub_type,

Line 917: p_order_number igs_as_doc_details.order_number%TYPE

913: --
914: END asp_update_order_doc;
915:
916: FUNCTION get_doc_fee(
917: p_order_number igs_as_doc_details.order_number%TYPE
918: ) RETURN NUMBER
919: IS
920: /*************************************************************
921: Created By :Sandeep Waghmare

Line 933: FROM igs_as_doc_details dtl

929: l_order_fee number;
930: BEGIN
931: SELECT NVL (SUM (NVL (dtl.overridden_document_fee, dtl.doc_fee_per_copy)), 0)
932: INTO l_order_fee
933: FROM igs_as_doc_details dtl
934: WHERE order_number = p_order_number;
935: RETURN l_order_fee;
936: END get_doc_fee;
937:

Line 939: p_order_number igs_as_doc_details.order_number%TYPE

935: RETURN l_order_fee;
936: END get_doc_fee;
937:
938: FUNCTION get_del_fee(
939: p_order_number igs_as_doc_details.order_number%TYPE
940: ) RETURN NUMBER
941: IS
942: /*************************************************************
943: Created By :Sandeep Waghmare

Line 955: FROM igs_as_doc_details dtl

951: l_order_del_fee NUMBER;
952: BEGIN
953: SELECT NVL (SUM (NVL (dtl.overridden_doc_delivery_fee, dtl.delivery_fee)), 0)
954: INTO l_order_del_fee
955: FROM igs_as_doc_details dtl
956: WHERE order_number = p_order_number;
957:
958: RETURN l_order_del_fee;
959: END get_del_fee;