eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QA_SS_SHIP dependencies on QA_SS_CONST

Line 26: Ctx qa_ss_const.Ctx_Table;

22: -- This needs change to view icx_pos_qa_shipments_V to pass extra argument
23: Return VARCHAR2
24:
25: IS
26: Ctx qa_ss_const.Ctx_Table;
27: l_organization_id NUMBER := NULL;
28: p_category_id NUMBER;
29: p_category VARCHAR2(240);
30:

Line 51: Ctx(qa_ss_const.Po_Number) := P_Po_Number;

47: -- dont think icx validate session is needed here, becos this is
48: -- a function called as part of po view definition
49: -- check the above
50:
51: Ctx(qa_ss_const.Po_Number) := P_Po_Number;
52: Ctx(qa_ss_const.Po_Line_Num) := P_Po_Line_Num;
53: Ctx(qa_ss_const.Po_Release_Num) := P_Po_Release_Num;
54: Ctx(qa_ss_const.Po_Shipment_Num) := P_Shipment_Num;
55: Ctx(qa_ss_const.Ship_To_Location) := P_Location;

Line 52: Ctx(qa_ss_const.Po_Line_Num) := P_Po_Line_Num;

48: -- a function called as part of po view definition
49: -- check the above
50:
51: Ctx(qa_ss_const.Po_Number) := P_Po_Number;
52: Ctx(qa_ss_const.Po_Line_Num) := P_Po_Line_Num;
53: Ctx(qa_ss_const.Po_Release_Num) := P_Po_Release_Num;
54: Ctx(qa_ss_const.Po_Shipment_Num) := P_Shipment_Num;
55: Ctx(qa_ss_const.Ship_To_Location) := P_Location;
56: Ctx(qa_ss_const.Vender_Item_Number) := P_Supplier_Item;

Line 53: Ctx(qa_ss_const.Po_Release_Num) := P_Po_Release_Num;

49: -- check the above
50:
51: Ctx(qa_ss_const.Po_Number) := P_Po_Number;
52: Ctx(qa_ss_const.Po_Line_Num) := P_Po_Line_Num;
53: Ctx(qa_ss_const.Po_Release_Num) := P_Po_Release_Num;
54: Ctx(qa_ss_const.Po_Shipment_Num) := P_Shipment_Num;
55: Ctx(qa_ss_const.Ship_To_Location) := P_Location;
56: Ctx(qa_ss_const.Vender_Item_Number) := P_Supplier_Item;
57: Ctx(qa_ss_const.Ordered_Quantity) := P_Ord_Qty;

Line 54: Ctx(qa_ss_const.Po_Shipment_Num) := P_Shipment_Num;

50:
51: Ctx(qa_ss_const.Po_Number) := P_Po_Number;
52: Ctx(qa_ss_const.Po_Line_Num) := P_Po_Line_Num;
53: Ctx(qa_ss_const.Po_Release_Num) := P_Po_Release_Num;
54: Ctx(qa_ss_const.Po_Shipment_Num) := P_Shipment_Num;
55: Ctx(qa_ss_const.Ship_To_Location) := P_Location;
56: Ctx(qa_ss_const.Vender_Item_Number) := P_Supplier_Item;
57: Ctx(qa_ss_const.Ordered_Quantity) := P_Ord_Qty;
58: Ctx(qa_ss_const.UOM_Name) := P_Uom_Name;

Line 55: Ctx(qa_ss_const.Ship_To_Location) := P_Location;

51: Ctx(qa_ss_const.Po_Number) := P_Po_Number;
52: Ctx(qa_ss_const.Po_Line_Num) := P_Po_Line_Num;
53: Ctx(qa_ss_const.Po_Release_Num) := P_Po_Release_Num;
54: Ctx(qa_ss_const.Po_Shipment_Num) := P_Shipment_Num;
55: Ctx(qa_ss_const.Ship_To_Location) := P_Location;
56: Ctx(qa_ss_const.Vender_Item_Number) := P_Supplier_Item;
57: Ctx(qa_ss_const.Ordered_Quantity) := P_Ord_Qty;
58: Ctx(qa_ss_const.UOM_Name) := P_Uom_Name;
59: Ctx(qa_ss_const.Vendor_Name) := P_Vendor;

Line 56: Ctx(qa_ss_const.Vender_Item_Number) := P_Supplier_Item;

52: Ctx(qa_ss_const.Po_Line_Num) := P_Po_Line_Num;
53: Ctx(qa_ss_const.Po_Release_Num) := P_Po_Release_Num;
54: Ctx(qa_ss_const.Po_Shipment_Num) := P_Shipment_Num;
55: Ctx(qa_ss_const.Ship_To_Location) := P_Location;
56: Ctx(qa_ss_const.Vender_Item_Number) := P_Supplier_Item;
57: Ctx(qa_ss_const.Ordered_Quantity) := P_Ord_Qty;
58: Ctx(qa_ss_const.UOM_Name) := P_Uom_Name;
59: Ctx(qa_ss_const.Vendor_Name) := P_Vendor;
60: Ctx(qa_ss_const.Vendor_Site_code) := P_vendor_site;

Line 57: Ctx(qa_ss_const.Ordered_Quantity) := P_Ord_Qty;

53: Ctx(qa_ss_const.Po_Release_Num) := P_Po_Release_Num;
54: Ctx(qa_ss_const.Po_Shipment_Num) := P_Shipment_Num;
55: Ctx(qa_ss_const.Ship_To_Location) := P_Location;
56: Ctx(qa_ss_const.Vender_Item_Number) := P_Supplier_Item;
57: Ctx(qa_ss_const.Ordered_Quantity) := P_Ord_Qty;
58: Ctx(qa_ss_const.UOM_Name) := P_Uom_Name;
59: Ctx(qa_ss_const.Vendor_Name) := P_Vendor;
60: Ctx(qa_ss_const.Vendor_Site_code) := P_vendor_site;
61: Ctx(qa_ss_const.Ship_To) := P_Organization;

Line 58: Ctx(qa_ss_const.UOM_Name) := P_Uom_Name;

54: Ctx(qa_ss_const.Po_Shipment_Num) := P_Shipment_Num;
55: Ctx(qa_ss_const.Ship_To_Location) := P_Location;
56: Ctx(qa_ss_const.Vender_Item_Number) := P_Supplier_Item;
57: Ctx(qa_ss_const.Ordered_Quantity) := P_Ord_Qty;
58: Ctx(qa_ss_const.UOM_Name) := P_Uom_Name;
59: Ctx(qa_ss_const.Vendor_Name) := P_Vendor;
60: Ctx(qa_ss_const.Vendor_Site_code) := P_vendor_site;
61: Ctx(qa_ss_const.Ship_To) := P_Organization;
62: Ctx(qa_ss_const.Item) := P_Item;

Line 59: Ctx(qa_ss_const.Vendor_Name) := P_Vendor;

55: Ctx(qa_ss_const.Ship_To_Location) := P_Location;
56: Ctx(qa_ss_const.Vender_Item_Number) := P_Supplier_Item;
57: Ctx(qa_ss_const.Ordered_Quantity) := P_Ord_Qty;
58: Ctx(qa_ss_const.UOM_Name) := P_Uom_Name;
59: Ctx(qa_ss_const.Vendor_Name) := P_Vendor;
60: Ctx(qa_ss_const.Vendor_Site_code) := P_vendor_site;
61: Ctx(qa_ss_const.Ship_To) := P_Organization;
62: Ctx(qa_ss_const.Item) := P_Item;
63: Ctx(qa_ss_const.Revision) := P_Item_Rev;

Line 60: Ctx(qa_ss_const.Vendor_Site_code) := P_vendor_site;

56: Ctx(qa_ss_const.Vender_Item_Number) := P_Supplier_Item;
57: Ctx(qa_ss_const.Ordered_Quantity) := P_Ord_Qty;
58: Ctx(qa_ss_const.UOM_Name) := P_Uom_Name;
59: Ctx(qa_ss_const.Vendor_Name) := P_Vendor;
60: Ctx(qa_ss_const.Vendor_Site_code) := P_vendor_site;
61: Ctx(qa_ss_const.Ship_To) := P_Organization;
62: Ctx(qa_ss_const.Item) := P_Item;
63: Ctx(qa_ss_const.Revision) := P_Item_Rev;
64:

Line 61: Ctx(qa_ss_const.Ship_To) := P_Organization;

57: Ctx(qa_ss_const.Ordered_Quantity) := P_Ord_Qty;
58: Ctx(qa_ss_const.UOM_Name) := P_Uom_Name;
59: Ctx(qa_ss_const.Vendor_Name) := P_Vendor;
60: Ctx(qa_ss_const.Vendor_Site_code) := P_vendor_site;
61: Ctx(qa_ss_const.Ship_To) := P_Organization;
62: Ctx(qa_ss_const.Item) := P_Item;
63: Ctx(qa_ss_const.Revision) := P_Item_Rev;
64:
65: If (P_Organization is NOT NULL) THEN

Line 62: Ctx(qa_ss_const.Item) := P_Item;

58: Ctx(qa_ss_const.UOM_Name) := P_Uom_Name;
59: Ctx(qa_ss_const.Vendor_Name) := P_Vendor;
60: Ctx(qa_ss_const.Vendor_Site_code) := P_vendor_site;
61: Ctx(qa_ss_const.Ship_To) := P_Organization;
62: Ctx(qa_ss_const.Item) := P_Item;
63: Ctx(qa_ss_const.Revision) := P_Item_Rev;
64:
65: If (P_Organization is NOT NULL) THEN
66: OPEN org_cur(P_Organization);

Line 63: Ctx(qa_ss_const.Revision) := P_Item_Rev;

59: Ctx(qa_ss_const.Vendor_Name) := P_Vendor;
60: Ctx(qa_ss_const.Vendor_Site_code) := P_vendor_site;
61: Ctx(qa_ss_const.Ship_To) := P_Organization;
62: Ctx(qa_ss_const.Item) := P_Item;
63: Ctx(qa_ss_const.Revision) := P_Item_Rev;
64:
65: If (P_Organization is NOT NULL) THEN
66: OPEN org_cur(P_Organization);
67: FETCH org_cur INTO l_organization_id;

Line 84: Ctx(qa_ss_const.Item_Category) := p_category;

80: p_org_id => l_Organization_Id,
81: p_item_val => P_Item,
82: x_category_val => p_category,
83: x_category_id => p_category_id);
84: Ctx(qa_ss_const.Item_Category) := p_category;
85:
86: IF ( qa_ss_core.any_applicable_plans( Ctx, 110, l_Organization_Id))
87: THEN
88: return 'Y'; -- there are applicable plans

Line 140: procedure default_ship_values (Ctx IN OUT NOCOPY qa_ss_const.Ctx_Table,

136: END ship_to_quality;
137:
138: ------------------------------------------------------------------------------------------
139:
140: procedure default_ship_values (Ctx IN OUT NOCOPY qa_ss_const.Ctx_Table,
141: Txn_Num IN NUMBER DEFAULT NULL,
142: PK1 IN VARCHAR2 DEFAULT NULL,
143: PK2 IN VARCHAR2 DEFAULT NULL,
144: PK3 IN VARCHAR2 DEFAULT NULL,

Line 211: INTO Ctx(qa_ss_const.Po_Number),

207: BEGIN
208:
209: OPEN def_ship_cur;
210: FETCH def_ship_cur
211: INTO Ctx(qa_ss_const.Po_Number),
212: Ctx(qa_ss_const.Po_Line_Num),
213: Ctx(qa_ss_const.Po_Release_Num),
214: Ctx(qa_ss_const.Po_Shipment_Num),
215: Ctx(qa_ss_const.Ship_To_Location),

Line 212: Ctx(qa_ss_const.Po_Line_Num),

208:
209: OPEN def_ship_cur;
210: FETCH def_ship_cur
211: INTO Ctx(qa_ss_const.Po_Number),
212: Ctx(qa_ss_const.Po_Line_Num),
213: Ctx(qa_ss_const.Po_Release_Num),
214: Ctx(qa_ss_const.Po_Shipment_Num),
215: Ctx(qa_ss_const.Ship_To_Location),
216: Ctx(qa_ss_const.Vender_Item_Number),

Line 213: Ctx(qa_ss_const.Po_Release_Num),

209: OPEN def_ship_cur;
210: FETCH def_ship_cur
211: INTO Ctx(qa_ss_const.Po_Number),
212: Ctx(qa_ss_const.Po_Line_Num),
213: Ctx(qa_ss_const.Po_Release_Num),
214: Ctx(qa_ss_const.Po_Shipment_Num),
215: Ctx(qa_ss_const.Ship_To_Location),
216: Ctx(qa_ss_const.Vender_Item_Number),
217: Ctx(qa_ss_const.Ordered_Quantity),

Line 214: Ctx(qa_ss_const.Po_Shipment_Num),

210: FETCH def_ship_cur
211: INTO Ctx(qa_ss_const.Po_Number),
212: Ctx(qa_ss_const.Po_Line_Num),
213: Ctx(qa_ss_const.Po_Release_Num),
214: Ctx(qa_ss_const.Po_Shipment_Num),
215: Ctx(qa_ss_const.Ship_To_Location),
216: Ctx(qa_ss_const.Vender_Item_Number),
217: Ctx(qa_ss_const.Ordered_Quantity),
218: Ctx(qa_ss_const.UOM_Name),

Line 215: Ctx(qa_ss_const.Ship_To_Location),

211: INTO Ctx(qa_ss_const.Po_Number),
212: Ctx(qa_ss_const.Po_Line_Num),
213: Ctx(qa_ss_const.Po_Release_Num),
214: Ctx(qa_ss_const.Po_Shipment_Num),
215: Ctx(qa_ss_const.Ship_To_Location),
216: Ctx(qa_ss_const.Vender_Item_Number),
217: Ctx(qa_ss_const.Ordered_Quantity),
218: Ctx(qa_ss_const.UOM_Name),
219: Ctx(qa_ss_const.Vendor_Name),

Line 216: Ctx(qa_ss_const.Vender_Item_Number),

212: Ctx(qa_ss_const.Po_Line_Num),
213: Ctx(qa_ss_const.Po_Release_Num),
214: Ctx(qa_ss_const.Po_Shipment_Num),
215: Ctx(qa_ss_const.Ship_To_Location),
216: Ctx(qa_ss_const.Vender_Item_Number),
217: Ctx(qa_ss_const.Ordered_Quantity),
218: Ctx(qa_ss_const.UOM_Name),
219: Ctx(qa_ss_const.Vendor_Name),
220: Ctx(qa_ss_const.Vendor_Site_code),

Line 217: Ctx(qa_ss_const.Ordered_Quantity),

213: Ctx(qa_ss_const.Po_Release_Num),
214: Ctx(qa_ss_const.Po_Shipment_Num),
215: Ctx(qa_ss_const.Ship_To_Location),
216: Ctx(qa_ss_const.Vender_Item_Number),
217: Ctx(qa_ss_const.Ordered_Quantity),
218: Ctx(qa_ss_const.UOM_Name),
219: Ctx(qa_ss_const.Vendor_Name),
220: Ctx(qa_ss_const.Vendor_Site_code),
221: Ctx(qa_ss_const.Ship_To),

Line 218: Ctx(qa_ss_const.UOM_Name),

214: Ctx(qa_ss_const.Po_Shipment_Num),
215: Ctx(qa_ss_const.Ship_To_Location),
216: Ctx(qa_ss_const.Vender_Item_Number),
217: Ctx(qa_ss_const.Ordered_Quantity),
218: Ctx(qa_ss_const.UOM_Name),
219: Ctx(qa_ss_const.Vendor_Name),
220: Ctx(qa_ss_const.Vendor_Site_code),
221: Ctx(qa_ss_const.Ship_To),
222: Ctx(qa_ss_const.Item),

Line 219: Ctx(qa_ss_const.Vendor_Name),

215: Ctx(qa_ss_const.Ship_To_Location),
216: Ctx(qa_ss_const.Vender_Item_Number),
217: Ctx(qa_ss_const.Ordered_Quantity),
218: Ctx(qa_ss_const.UOM_Name),
219: Ctx(qa_ss_const.Vendor_Name),
220: Ctx(qa_ss_const.Vendor_Site_code),
221: Ctx(qa_ss_const.Ship_To),
222: Ctx(qa_ss_const.Item),
223: Ctx(qa_ss_const.Revision),

Line 220: Ctx(qa_ss_const.Vendor_Site_code),

216: Ctx(qa_ss_const.Vender_Item_Number),
217: Ctx(qa_ss_const.Ordered_Quantity),
218: Ctx(qa_ss_const.UOM_Name),
219: Ctx(qa_ss_const.Vendor_Name),
220: Ctx(qa_ss_const.Vendor_Site_code),
221: Ctx(qa_ss_const.Ship_To),
222: Ctx(qa_ss_const.Item),
223: Ctx(qa_ss_const.Revision),
224: Ctx(qa_ss_const.Item_Category),

Line 221: Ctx(qa_ss_const.Ship_To),

217: Ctx(qa_ss_const.Ordered_Quantity),
218: Ctx(qa_ss_const.UOM_Name),
219: Ctx(qa_ss_const.Vendor_Name),
220: Ctx(qa_ss_const.Vendor_Site_code),
221: Ctx(qa_ss_const.Ship_To),
222: Ctx(qa_ss_const.Item),
223: Ctx(qa_ss_const.Revision),
224: Ctx(qa_ss_const.Item_Category),
225: l_po_header_id, X_Item_Id,

Line 222: Ctx(qa_ss_const.Item),

218: Ctx(qa_ss_const.UOM_Name),
219: Ctx(qa_ss_const.Vendor_Name),
220: Ctx(qa_ss_const.Vendor_Site_code),
221: Ctx(qa_ss_const.Ship_To),
222: Ctx(qa_ss_const.Item),
223: Ctx(qa_ss_const.Revision),
224: Ctx(qa_ss_const.Item_Category),
225: l_po_header_id, X_Item_Id,
226: X_Po_Line_Id, X_Po_Shipment_Id, X_Organization_Id;

Line 223: Ctx(qa_ss_const.Revision),

219: Ctx(qa_ss_const.Vendor_Name),
220: Ctx(qa_ss_const.Vendor_Site_code),
221: Ctx(qa_ss_const.Ship_To),
222: Ctx(qa_ss_const.Item),
223: Ctx(qa_ss_const.Revision),
224: Ctx(qa_ss_const.Item_Category),
225: l_po_header_id, X_Item_Id,
226: X_Po_Line_Id, X_Po_Shipment_Id, X_Organization_Id;
227:

Line 224: Ctx(qa_ss_const.Item_Category),

220: Ctx(qa_ss_const.Vendor_Site_code),
221: Ctx(qa_ss_const.Ship_To),
222: Ctx(qa_ss_const.Item),
223: Ctx(qa_ss_const.Revision),
224: Ctx(qa_ss_const.Item_Category),
225: l_po_header_id, X_Item_Id,
226: X_Po_Line_Id, X_Po_Shipment_Id, X_Organization_Id;
227:
228: -- Assign l_po_release_id

Line 229: l_po_release_id := Ctx(qa_ss_const.Po_Release_Num);

225: l_po_header_id, X_Item_Id,
226: X_Po_Line_Id, X_Po_Shipment_Id, X_Organization_Id;
227:
228: -- Assign l_po_release_id
229: l_po_release_id := Ctx(qa_ss_const.Po_Release_Num);
230: -- Dont change this. We do X_po_release_id assignment
231: -- below
232: X_Po_Header_ID := l_po_header_id; -- for sake of out variable
233: X_Po_Release_ID := l_po_release_id;

Line 244: IF ( Ctx(qa_ss_const.Po_Release_Num) is NOT NULL) Then

240: X_Wip_Line_Id := NULL;
241:
242: CLOSE def_ship_cur;
243: -- now ctx(release_num) actually has release id. lets get release num
244: IF ( Ctx(qa_ss_const.Po_Release_Num) is NOT NULL) Then
245: OPEN rel_num_cur( Ctx(qa_ss_const.Po_Release_Num) );
246: FETCH rel_num_cur INTO Ctx(qa_ss_const.Po_Release_Num);
247: CLOSE rel_num_cur;
248: END IF;

Line 245: OPEN rel_num_cur( Ctx(qa_ss_const.Po_Release_Num) );

241:
242: CLOSE def_ship_cur;
243: -- now ctx(release_num) actually has release id. lets get release num
244: IF ( Ctx(qa_ss_const.Po_Release_Num) is NOT NULL) Then
245: OPEN rel_num_cur( Ctx(qa_ss_const.Po_Release_Num) );
246: FETCH rel_num_cur INTO Ctx(qa_ss_const.Po_Release_Num);
247: CLOSE rel_num_cur;
248: END IF;
249:

Line 246: FETCH rel_num_cur INTO Ctx(qa_ss_const.Po_Release_Num);

242: CLOSE def_ship_cur;
243: -- now ctx(release_num) actually has release id. lets get release num
244: IF ( Ctx(qa_ss_const.Po_Release_Num) is NOT NULL) Then
245: OPEN rel_num_cur( Ctx(qa_ss_const.Po_Release_Num) );
246: FETCH rel_num_cur INTO Ctx(qa_ss_const.Po_Release_Num);
247: CLOSE rel_num_cur;
248: END IF;
249:
250: -- Adding code to find buyer ie. Po_Agent_Id

Line 295: Ctx qa_ss_const.Ctx_Table;

291: PK9 IN VARCHAR2 DEFAULT NULL,
292: PK10 IN VARCHAR2 DEFAULT NULL )
293: IS
294: P_Organization_Id NUMBER;
295: Ctx qa_ss_const.Ctx_Table;
296:
297: -- fixing base_po_num for bug 1241396
298:
299: -- R12 Project MOAC 4637896

Line 328: INTO Ctx(qa_ss_const.Po_Number),

324: -- htp.p('PK10 = ' || PK10); htp.nl;
325: OPEN ship_cur;
326: -- htp.p('ship_cur opened'); htp.nl;
327: FETCH ship_cur
328: INTO Ctx(qa_ss_const.Po_Number),
329: Ctx(qa_ss_const.Po_Line_Num),
330: Ctx(qa_ss_const.Po_Release_Num),
331: Ctx(qa_ss_const.Po_Shipment_Num),
332: Ctx(qa_ss_const.Ship_To_Location),

Line 329: Ctx(qa_ss_const.Po_Line_Num),

325: OPEN ship_cur;
326: -- htp.p('ship_cur opened'); htp.nl;
327: FETCH ship_cur
328: INTO Ctx(qa_ss_const.Po_Number),
329: Ctx(qa_ss_const.Po_Line_Num),
330: Ctx(qa_ss_const.Po_Release_Num),
331: Ctx(qa_ss_const.Po_Shipment_Num),
332: Ctx(qa_ss_const.Ship_To_Location),
333: Ctx(qa_ss_const.Vender_Item_Number),

Line 330: Ctx(qa_ss_const.Po_Release_Num),

326: -- htp.p('ship_cur opened'); htp.nl;
327: FETCH ship_cur
328: INTO Ctx(qa_ss_const.Po_Number),
329: Ctx(qa_ss_const.Po_Line_Num),
330: Ctx(qa_ss_const.Po_Release_Num),
331: Ctx(qa_ss_const.Po_Shipment_Num),
332: Ctx(qa_ss_const.Ship_To_Location),
333: Ctx(qa_ss_const.Vender_Item_Number),
334: Ctx(qa_ss_const.Ordered_Quantity),

Line 331: Ctx(qa_ss_const.Po_Shipment_Num),

327: FETCH ship_cur
328: INTO Ctx(qa_ss_const.Po_Number),
329: Ctx(qa_ss_const.Po_Line_Num),
330: Ctx(qa_ss_const.Po_Release_Num),
331: Ctx(qa_ss_const.Po_Shipment_Num),
332: Ctx(qa_ss_const.Ship_To_Location),
333: Ctx(qa_ss_const.Vender_Item_Number),
334: Ctx(qa_ss_const.Ordered_Quantity),
335: Ctx(qa_ss_const.UOM_Name),

Line 332: Ctx(qa_ss_const.Ship_To_Location),

328: INTO Ctx(qa_ss_const.Po_Number),
329: Ctx(qa_ss_const.Po_Line_Num),
330: Ctx(qa_ss_const.Po_Release_Num),
331: Ctx(qa_ss_const.Po_Shipment_Num),
332: Ctx(qa_ss_const.Ship_To_Location),
333: Ctx(qa_ss_const.Vender_Item_Number),
334: Ctx(qa_ss_const.Ordered_Quantity),
335: Ctx(qa_ss_const.UOM_Name),
336: Ctx(qa_ss_const.Vendor_Name),

Line 333: Ctx(qa_ss_const.Vender_Item_Number),

329: Ctx(qa_ss_const.Po_Line_Num),
330: Ctx(qa_ss_const.Po_Release_Num),
331: Ctx(qa_ss_const.Po_Shipment_Num),
332: Ctx(qa_ss_const.Ship_To_Location),
333: Ctx(qa_ss_const.Vender_Item_Number),
334: Ctx(qa_ss_const.Ordered_Quantity),
335: Ctx(qa_ss_const.UOM_Name),
336: Ctx(qa_ss_const.Vendor_Name),
337: Ctx(qa_ss_const.Vendor_Site_code),

Line 334: Ctx(qa_ss_const.Ordered_Quantity),

330: Ctx(qa_ss_const.Po_Release_Num),
331: Ctx(qa_ss_const.Po_Shipment_Num),
332: Ctx(qa_ss_const.Ship_To_Location),
333: Ctx(qa_ss_const.Vender_Item_Number),
334: Ctx(qa_ss_const.Ordered_Quantity),
335: Ctx(qa_ss_const.UOM_Name),
336: Ctx(qa_ss_const.Vendor_Name),
337: Ctx(qa_ss_const.Vendor_Site_code),
338: Ctx(qa_ss_const.Ship_To),

Line 335: Ctx(qa_ss_const.UOM_Name),

331: Ctx(qa_ss_const.Po_Shipment_Num),
332: Ctx(qa_ss_const.Ship_To_Location),
333: Ctx(qa_ss_const.Vender_Item_Number),
334: Ctx(qa_ss_const.Ordered_Quantity),
335: Ctx(qa_ss_const.UOM_Name),
336: Ctx(qa_ss_const.Vendor_Name),
337: Ctx(qa_ss_const.Vendor_Site_code),
338: Ctx(qa_ss_const.Ship_To),
339: Ctx(qa_ss_const.Item),

Line 336: Ctx(qa_ss_const.Vendor_Name),

332: Ctx(qa_ss_const.Ship_To_Location),
333: Ctx(qa_ss_const.Vender_Item_Number),
334: Ctx(qa_ss_const.Ordered_Quantity),
335: Ctx(qa_ss_const.UOM_Name),
336: Ctx(qa_ss_const.Vendor_Name),
337: Ctx(qa_ss_const.Vendor_Site_code),
338: Ctx(qa_ss_const.Ship_To),
339: Ctx(qa_ss_const.Item),
340: Ctx(qa_ss_const.Revision),

Line 337: Ctx(qa_ss_const.Vendor_Site_code),

333: Ctx(qa_ss_const.Vender_Item_Number),
334: Ctx(qa_ss_const.Ordered_Quantity),
335: Ctx(qa_ss_const.UOM_Name),
336: Ctx(qa_ss_const.Vendor_Name),
337: Ctx(qa_ss_const.Vendor_Site_code),
338: Ctx(qa_ss_const.Ship_To),
339: Ctx(qa_ss_const.Item),
340: Ctx(qa_ss_const.Revision),
341: Ctx(qa_ss_const.Item_Category),

Line 338: Ctx(qa_ss_const.Ship_To),

334: Ctx(qa_ss_const.Ordered_Quantity),
335: Ctx(qa_ss_const.UOM_Name),
336: Ctx(qa_ss_const.Vendor_Name),
337: Ctx(qa_ss_const.Vendor_Site_code),
338: Ctx(qa_ss_const.Ship_To),
339: Ctx(qa_ss_const.Item),
340: Ctx(qa_ss_const.Revision),
341: Ctx(qa_ss_const.Item_Category),
342: P_Organization_Id;

Line 339: Ctx(qa_ss_const.Item),

335: Ctx(qa_ss_const.UOM_Name),
336: Ctx(qa_ss_const.Vendor_Name),
337: Ctx(qa_ss_const.Vendor_Site_code),
338: Ctx(qa_ss_const.Ship_To),
339: Ctx(qa_ss_const.Item),
340: Ctx(qa_ss_const.Revision),
341: Ctx(qa_ss_const.Item_Category),
342: P_Organization_Id;
343: -- htp.p('ship_cur fetched successfully'); htp.nl;

Line 340: Ctx(qa_ss_const.Revision),

336: Ctx(qa_ss_const.Vendor_Name),
337: Ctx(qa_ss_const.Vendor_Site_code),
338: Ctx(qa_ss_const.Ship_To),
339: Ctx(qa_ss_const.Item),
340: Ctx(qa_ss_const.Revision),
341: Ctx(qa_ss_const.Item_Category),
342: P_Organization_Id;
343: -- htp.p('ship_cur fetched successfully'); htp.nl;
344: CLOSE ship_cur;

Line 341: Ctx(qa_ss_const.Item_Category),

337: Ctx(qa_ss_const.Vendor_Site_code),
338: Ctx(qa_ss_const.Ship_To),
339: Ctx(qa_ss_const.Item),
340: Ctx(qa_ss_const.Revision),
341: Ctx(qa_ss_const.Item_Category),
342: P_Organization_Id;
343: -- htp.p('ship_cur fetched successfully'); htp.nl;
344: CLOSE ship_cur;
345: -- htp.p('ship_cur closed successfully'); htp.nl;

Line 348: IF ( Ctx(qa_ss_const.Po_Release_Num) is NOT NULL) Then

344: CLOSE ship_cur;
345: -- htp.p('ship_cur closed successfully'); htp.nl;
346: -- now ctx(release_num) actually has release id. lets get release num
347:
348: IF ( Ctx(qa_ss_const.Po_Release_Num) is NOT NULL) Then
349: -- htp.p('attempt to fetch release num'); htp.nl;
350: OPEN rel_num_cur( Ctx(qa_ss_const.Po_Release_Num) );
351: FETCH rel_num_cur INTO Ctx(qa_ss_const.Po_Release_Num);
352: CLOSE rel_num_cur;

Line 350: OPEN rel_num_cur( Ctx(qa_ss_const.Po_Release_Num) );

346: -- now ctx(release_num) actually has release id. lets get release num
347:
348: IF ( Ctx(qa_ss_const.Po_Release_Num) is NOT NULL) Then
349: -- htp.p('attempt to fetch release num'); htp.nl;
350: OPEN rel_num_cur( Ctx(qa_ss_const.Po_Release_Num) );
351: FETCH rel_num_cur INTO Ctx(qa_ss_const.Po_Release_Num);
352: CLOSE rel_num_cur;
353: -- htp.p('successful rel num fetch'); htp.nl;
354: END IF;

Line 351: FETCH rel_num_cur INTO Ctx(qa_ss_const.Po_Release_Num);

347:
348: IF ( Ctx(qa_ss_const.Po_Release_Num) is NOT NULL) Then
349: -- htp.p('attempt to fetch release num'); htp.nl;
350: OPEN rel_num_cur( Ctx(qa_ss_const.Po_Release_Num) );
351: FETCH rel_num_cur INTO Ctx(qa_ss_const.Po_Release_Num);
352: CLOSE rel_num_cur;
353: -- htp.p('successful rel num fetch'); htp.nl;
354: END IF;
355: -- Now Ctx is populated. Also, populated P_Organization_Id above