APPS.QA_INSPECTION_PKG dependencies on QA_INSP_COLLECTIONS_TEMP

Line 15: from qa_insp_collections_temp

11: dummy NUMBER;
12:
13: cursor qict_cur is
14: select 1
15: from qa_insp_collections_temp
16: where collection_id = p_collection_id;
17:
18: cursor qipt_cur is
19: select 1

Line 39: insert into qa_insp_collections_temp

35: open qict_cur;
36: fetch qict_cur into dummy;
37: if (qict_cur%notfound) then
38:
39: insert into qa_insp_collections_temp
40: (collection_id, lot_size, transaction_uom,lot_result)
41: values
42: (p_collection_id, p_lot_size, p_uom_name, null);
43: end if;

Line 52: delete from qa_insp_collections_temp

48: -- Delete existing rows for this collection id
49: -- and insert the values for the next item.
50: -- skolluku Wed Apr 18 03:15:08 PDT 2007
51: --
52: delete from qa_insp_collections_temp
53: where collection_id = p_collection_id;
54:
55: insert into qa_insp_collections_temp
56: (collection_id, lot_size, transaction_uom,lot_result)

Line 55: insert into qa_insp_collections_temp

51: --
52: delete from qa_insp_collections_temp
53: where collection_id = p_collection_id;
54:
55: insert into qa_insp_collections_temp
56: (collection_id, lot_size, transaction_uom,lot_result)
57: values
58: (p_collection_id, p_lot_size, p_uom_name, null);
59:

Line 88: from qa_insp_collections_temp;

84: sampling_flag,
85: skiplot_flag,
86: lot_size,
87: transaction_uom
88: from qa_insp_collections_temp;
89:
90: --
91: -- this information is needed by PO API
92: -- PO API is writen for unit-by-unit inspection

Line 188: from qa_insp_collections_temp

184: p_collection_id IN NUMBER) RETURN VARCHAR2 IS
185:
186: cursor sampling_flag (x_coll_id number) is
187: select sampling_flag
188: from qa_insp_collections_temp
189: where collection_id = x_coll_id;
190:
191: x_sampling_flag VARCHAR2(1);
192:

Line 210: from qa_insp_collections_temp

206: p_collection_id IN NUMBER) RETURN VARCHAR2 IS
207:
208: cursor skiplot_flag (x_coll_id number) is
209: select skiplot_flag
210: from qa_insp_collections_temp
211: where collection_id = x_coll_id;
212:
213: x_skiplot_flag VARCHAR2(1);
214: