APPS.IGS_AS_DOCUMENTS_API dependencies on IGS_AS_DOC_DETAILS

Line 35: FROM igs_as_doc_details itm

31: ord.*
32: FROM igs_as_order_hdr ord
33: WHERE order_status = 'INPROCESS'
34: AND NOT EXISTS ( SELECT item_number
35: FROM igs_as_doc_details itm
36: WHERE ord.order_number = itm.order_number
37: AND itm.item_status <> 'PROCESSED')
38: ORDER BY order_number
39: FOR UPDATE NOWAIT;

Line 42: cp_order_number igs_as_doc_details.order_number%TYPE,

38: ORDER BY order_number
39: FOR UPDATE NOWAIT;
40: --
41: CURSOR cur_doc_details (
42: cp_order_number igs_as_doc_details.order_number%TYPE,
43: cp_item_number igs_as_doc_details.item_number%TYPE
44: ) IS
45: SELECT ROWID row_id,
46: dd.*

Line 43: cp_item_number igs_as_doc_details.item_number%TYPE

39: FOR UPDATE NOWAIT;
40: --
41: CURSOR cur_doc_details (
42: cp_order_number igs_as_doc_details.order_number%TYPE,
43: cp_item_number igs_as_doc_details.item_number%TYPE
44: ) IS
45: SELECT ROWID row_id,
46: dd.*
47: FROM igs_as_doc_details dd

Line 47: FROM igs_as_doc_details dd

43: cp_item_number igs_as_doc_details.item_number%TYPE
44: ) IS
45: SELECT ROWID row_id,
46: dd.*
47: FROM igs_as_doc_details dd
48: WHERE order_number = cp_order_number
49: AND item_number = cp_item_number;
50: --
51: doc_details_rec cur_doc_details%ROWTYPE;

Line 53: CURSOR cur_doc_date (cp_order_number igs_as_doc_details.order_number%TYPE) IS

49: AND item_number = cp_item_number;
50: --
51: doc_details_rec cur_doc_details%ROWTYPE;
52: --
53: CURSOR cur_doc_date (cp_order_number igs_as_doc_details.order_number%TYPE) IS
54: SELECT MAX (date_produced)
55: FROM igs_as_doc_details
56: WHERE order_number = cp_order_number;
57: --

Line 55: FROM igs_as_doc_details

51: doc_details_rec cur_doc_details%ROWTYPE;
52: --
53: CURSOR cur_doc_date (cp_order_number igs_as_doc_details.order_number%TYPE) IS
54: SELECT MAX (date_produced)
55: FROM igs_as_doc_details
56: WHERE order_number = cp_order_number;
57: --
58: l_date_produced igs_as_doc_details.date_produced%TYPE;
59: l_return_status VARCHAR2 (1);

Line 58: l_date_produced igs_as_doc_details.date_produced%TYPE;

54: SELECT MAX (date_produced)
55: FROM igs_as_doc_details
56: WHERE order_number = cp_order_number;
57: --
58: l_date_produced igs_as_doc_details.date_produced%TYPE;
59: l_return_status VARCHAR2 (1);
60: l_msg_count NUMBER;
61: l_msg_data VARCHAR2 (2000);
62: BEGIN

Line 74: igs_as_doc_details_pkg.update_row (

70: OPEN cur_doc_details (processed_items_rec.order_number, processed_items_rec.item_number);
71: FETCH cur_doc_details INTO doc_details_rec;
72: IF cur_doc_details%FOUND THEN
73: --Update item_status, date_produced Columns of OSS Document Details table with interface table data
74: igs_as_doc_details_pkg.update_row (
75: x_mode => 'R',
76: x_rowid => doc_details_rec.row_id,
77: x_order_number => doc_details_rec.order_number,
78: x_document_type => doc_details_rec.document_type,

Line 337: FROM igs_as_doc_details dd

333: --
334: CURSOR cur_doc_details IS
335: SELECT ROWID row_id,
336: dd.*
337: FROM igs_as_doc_details dd
338: WHERE dd.order_number = p_order_number
339: AND dd.item_number = NVL (p_item_number, dd.item_number)
340: ORDER BY dd.item_number;
341: --

Line 425: igs_as_doc_details_pkg.update_row (

421: l_return_status := NULL;
422: l_msg_data := NULL;
423: l_msg_count := NULL;
424: --Update the Order's Item status to 'In Process'
425: igs_as_doc_details_pkg.update_row (
426: x_mode => 'R',
427: x_rowid => doc_details_rec.row_id,
428: x_order_number => doc_details_rec.order_number,
429: x_document_type => doc_details_rec.document_type,