APPS.IGS_AS_DOCUMENTS_API dependencies on IGS_AS_ORD_ITM_INT

Line 23: FROM igs_as_ord_itm_int oii

19: item_status,
20: date_produced,
21: order_number,
22: item_number
23: FROM igs_as_ord_itm_int oii
24: WHERE item_status = 'PROCESSED'
25: ORDER BY order_number,
26: item_number
27: FOR UPDATE NOWAIT;

Line 200: DELETE igs_as_ord_itm_int

196: fnd_message.set_token ('ORDER_NUMBER', doc_details_rec.order_number);
197: fnd_message.set_token ('ITEM_NUMBER', doc_details_rec.item_number);
198: fnd_file.put_line (fnd_file.LOG, fnd_message.get);
199: --Delete the Item Number record from Interface table after updating the OSS Document Details Table
200: DELETE igs_as_ord_itm_int
201: WHERE ROWID = processed_items_rec.row_id;
202: ELSE
203: -- IF the RETURN status IS error than LOG a message AND the message
204: -- data that was retunred by the above API

Line 344: FROM igs_as_ord_itm_int

340: ORDER BY dd.item_number;
341: --
342: CURSOR cur_ord_int_details (cp_order_number NUMBER, cp_item_number NUMBER) IS
343: SELECT 'X'
344: FROM igs_as_ord_itm_int
345: WHERE order_number = cp_order_number
346: AND item_number = cp_item_number;
347: --
348: CURSOR cur_ord_int_dupl_doc (cp_order_number NUMBER, cp_item_number NUMBER) IS

Line 350: FROM igs_as_ord_itm_int intr,

346: AND item_number = cp_item_number;
347: --
348: CURSOR cur_ord_int_dupl_doc (cp_order_number NUMBER, cp_item_number NUMBER) IS
349: SELECT 'X'
350: FROM igs_as_ord_itm_int intr,
351: igs_as_dup_docs dup
352: WHERE intr.order_number = cp_order_number
353: AND intr.item_number = cp_item_number
354: AND intr.item_status = 'PROCESSED'

Line 566: INSERT INTO igs_as_ord_itm_int

562: CLOSE cur_ord_int_dupl_doc;
563: END IF;
564: IF (l_create_interface_item) THEN
565: -- Inserting the Items of Order information into Interface table.
566: INSERT INTO igs_as_ord_itm_int
567: (order_number, person_id, document_type,
568: document_sub_type, item_number, item_status,
569: date_produced, num_of_copies,
570: programs_on_file, comments, recip_pers_name,