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_OSP dependencies on QA_SS_CONST

Line 23: Ctx qa_ss_const.Ctx_Table;

19:
20: Return VARCHAR2
21:
22: IS
23: Ctx qa_ss_const.Ctx_Table;
24: p_category_id NUMBER;
25: p_category VARCHAR2(240);
26:
27: BEGIN

Line 32: Ctx(qa_ss_const.Item) := P_Item_Number;

28: -- dont think icx validate session is needed here, becos this is
29: -- a function called as part of wip's view definition
30: -- check the above
31:
32: Ctx(qa_ss_const.Item) := P_Item_Number;
33: Ctx(qa_ss_const.Vendor_Name) := P_Supplier;
34: Ctx(qa_ss_const.Job_Name) := P_Wip_Entity_Name;
35: Ctx(qa_ss_const.Po_Number) := P_Po_Number;
36: Ctx(qa_ss_const.Vender_Item_Number) := P_Vendor_Item_Number;

Line 33: Ctx(qa_ss_const.Vendor_Name) := P_Supplier;

29: -- a function called as part of wip's view definition
30: -- check the above
31:
32: Ctx(qa_ss_const.Item) := P_Item_Number;
33: Ctx(qa_ss_const.Vendor_Name) := P_Supplier;
34: Ctx(qa_ss_const.Job_Name) := P_Wip_Entity_Name;
35: Ctx(qa_ss_const.Po_Number) := P_Po_Number;
36: Ctx(qa_ss_const.Vender_Item_Number) := P_Vendor_Item_Number;
37: -- Typo vender in seed data

Line 34: Ctx(qa_ss_const.Job_Name) := P_Wip_Entity_Name;

30: -- check the above
31:
32: Ctx(qa_ss_const.Item) := P_Item_Number;
33: Ctx(qa_ss_const.Vendor_Name) := P_Supplier;
34: Ctx(qa_ss_const.Job_Name) := P_Wip_Entity_Name;
35: Ctx(qa_ss_const.Po_Number) := P_Po_Number;
36: Ctx(qa_ss_const.Vender_Item_Number) := P_Vendor_Item_Number;
37: -- Typo vender in seed data
38: Ctx(qa_ss_const.From_Op_Seq_Num) := to_char(P_Wip_Operation_Seq_Num);

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

31:
32: Ctx(qa_ss_const.Item) := P_Item_Number;
33: Ctx(qa_ss_const.Vendor_Name) := P_Supplier;
34: Ctx(qa_ss_const.Job_Name) := P_Wip_Entity_Name;
35: Ctx(qa_ss_const.Po_Number) := P_Po_Number;
36: Ctx(qa_ss_const.Vender_Item_Number) := P_Vendor_Item_Number;
37: -- Typo vender in seed data
38: Ctx(qa_ss_const.From_Op_Seq_Num) := to_char(P_Wip_Operation_Seq_Num);
39: Ctx(qa_ss_const.UOM_Name) := P_UOM_Name;

Line 36: Ctx(qa_ss_const.Vender_Item_Number) := P_Vendor_Item_Number;

32: Ctx(qa_ss_const.Item) := P_Item_Number;
33: Ctx(qa_ss_const.Vendor_Name) := P_Supplier;
34: Ctx(qa_ss_const.Job_Name) := P_Wip_Entity_Name;
35: Ctx(qa_ss_const.Po_Number) := P_Po_Number;
36: Ctx(qa_ss_const.Vender_Item_Number) := P_Vendor_Item_Number;
37: -- Typo vender in seed data
38: Ctx(qa_ss_const.From_Op_Seq_Num) := to_char(P_Wip_Operation_Seq_Num);
39: Ctx(qa_ss_const.UOM_Name) := P_UOM_Name;
40: Ctx(qa_ss_const.Production_Line) := P_Production_Line;

Line 38: Ctx(qa_ss_const.From_Op_Seq_Num) := to_char(P_Wip_Operation_Seq_Num);

34: Ctx(qa_ss_const.Job_Name) := P_Wip_Entity_Name;
35: Ctx(qa_ss_const.Po_Number) := P_Po_Number;
36: Ctx(qa_ss_const.Vender_Item_Number) := P_Vendor_Item_Number;
37: -- Typo vender in seed data
38: Ctx(qa_ss_const.From_Op_Seq_Num) := to_char(P_Wip_Operation_Seq_Num);
39: Ctx(qa_ss_const.UOM_Name) := P_UOM_Name;
40: Ctx(qa_ss_const.Production_Line) := P_Production_Line;
41: Ctx(qa_ss_const.Ordered_Quantity) := to_char(P_Quantity_Ordered);
42: Ctx(qa_ss_const.Revision) := P_Item_Revision;

Line 39: Ctx(qa_ss_const.UOM_Name) := P_UOM_Name;

35: Ctx(qa_ss_const.Po_Number) := P_Po_Number;
36: Ctx(qa_ss_const.Vender_Item_Number) := P_Vendor_Item_Number;
37: -- Typo vender in seed data
38: Ctx(qa_ss_const.From_Op_Seq_Num) := to_char(P_Wip_Operation_Seq_Num);
39: Ctx(qa_ss_const.UOM_Name) := P_UOM_Name;
40: Ctx(qa_ss_const.Production_Line) := P_Production_Line;
41: Ctx(qa_ss_const.Ordered_Quantity) := to_char(P_Quantity_Ordered);
42: Ctx(qa_ss_const.Revision) := P_Item_Revision;
43: Ctx(qa_ss_const.PO_Release_Num) := to_char(P_Po_Release_Number);

Line 40: Ctx(qa_ss_const.Production_Line) := P_Production_Line;

36: Ctx(qa_ss_const.Vender_Item_Number) := P_Vendor_Item_Number;
37: -- Typo vender in seed data
38: Ctx(qa_ss_const.From_Op_Seq_Num) := to_char(P_Wip_Operation_Seq_Num);
39: Ctx(qa_ss_const.UOM_Name) := P_UOM_Name;
40: Ctx(qa_ss_const.Production_Line) := P_Production_Line;
41: Ctx(qa_ss_const.Ordered_Quantity) := to_char(P_Quantity_Ordered);
42: Ctx(qa_ss_const.Revision) := P_Item_Revision;
43: Ctx(qa_ss_const.PO_Release_Num) := to_char(P_Po_Release_Number);
44: Ctx(qa_ss_const.Organization_Id) := to_char(P_Organization_Id);

Line 41: Ctx(qa_ss_const.Ordered_Quantity) := to_char(P_Quantity_Ordered);

37: -- Typo vender in seed data
38: Ctx(qa_ss_const.From_Op_Seq_Num) := to_char(P_Wip_Operation_Seq_Num);
39: Ctx(qa_ss_const.UOM_Name) := P_UOM_Name;
40: Ctx(qa_ss_const.Production_Line) := P_Production_Line;
41: Ctx(qa_ss_const.Ordered_Quantity) := to_char(P_Quantity_Ordered);
42: Ctx(qa_ss_const.Revision) := P_Item_Revision;
43: Ctx(qa_ss_const.PO_Release_Num) := to_char(P_Po_Release_Number);
44: Ctx(qa_ss_const.Organization_Id) := to_char(P_Organization_Id);
45: qa_ss_core.get_item_category_val(

Line 42: Ctx(qa_ss_const.Revision) := P_Item_Revision;

38: Ctx(qa_ss_const.From_Op_Seq_Num) := to_char(P_Wip_Operation_Seq_Num);
39: Ctx(qa_ss_const.UOM_Name) := P_UOM_Name;
40: Ctx(qa_ss_const.Production_Line) := P_Production_Line;
41: Ctx(qa_ss_const.Ordered_Quantity) := to_char(P_Quantity_Ordered);
42: Ctx(qa_ss_const.Revision) := P_Item_Revision;
43: Ctx(qa_ss_const.PO_Release_Num) := to_char(P_Po_Release_Number);
44: Ctx(qa_ss_const.Organization_Id) := to_char(P_Organization_Id);
45: qa_ss_core.get_item_category_val(
46: p_org_id => p_organization_id,

Line 43: Ctx(qa_ss_const.PO_Release_Num) := to_char(P_Po_Release_Number);

39: Ctx(qa_ss_const.UOM_Name) := P_UOM_Name;
40: Ctx(qa_ss_const.Production_Line) := P_Production_Line;
41: Ctx(qa_ss_const.Ordered_Quantity) := to_char(P_Quantity_Ordered);
42: Ctx(qa_ss_const.Revision) := P_Item_Revision;
43: Ctx(qa_ss_const.PO_Release_Num) := to_char(P_Po_Release_Number);
44: Ctx(qa_ss_const.Organization_Id) := to_char(P_Organization_Id);
45: qa_ss_core.get_item_category_val(
46: p_org_id => p_organization_id,
47: p_item_val => p_item_number,

Line 44: Ctx(qa_ss_const.Organization_Id) := to_char(P_Organization_Id);

40: Ctx(qa_ss_const.Production_Line) := P_Production_Line;
41: Ctx(qa_ss_const.Ordered_Quantity) := to_char(P_Quantity_Ordered);
42: Ctx(qa_ss_const.Revision) := P_Item_Revision;
43: Ctx(qa_ss_const.PO_Release_Num) := to_char(P_Po_Release_Number);
44: Ctx(qa_ss_const.Organization_Id) := to_char(P_Organization_Id);
45: qa_ss_core.get_item_category_val(
46: p_org_id => p_organization_id,
47: p_item_val => p_item_number,
48: x_category_val => p_category,

Line 50: Ctx(qa_ss_const.item_category) := p_category;

46: p_org_id => p_organization_id,
47: p_item_val => p_item_number,
48: x_category_val => p_category,
49: x_category_id => p_category_id);
50: Ctx(qa_ss_const.item_category) := p_category;
51:
52:
53: -- P_Wip_entity_type can be used for any checking if needed
54:

Line 111: procedure default_osp_values (Ctx IN OUT NOCOPY qa_ss_const.Ctx_Table,

107: END osp_to_quality;
108:
109: ------------------------------------------------------------------------------------------
110:
111: procedure default_osp_values (Ctx IN OUT NOCOPY qa_ss_const.Ctx_Table,
112: Txn_Num IN NUMBER DEFAULT NULL,
113: PK1 IN VARCHAR2 DEFAULT NULL,
114: PK2 IN VARCHAR2 DEFAULT NULL,
115: PK3 IN VARCHAR2 DEFAULT NULL,

Line 193: INTO Ctx(qa_ss_const.Item), Ctx(qa_ss_const.Vendor_Name), Ctx(qa_ss_const.Job_Name),

189:
190: OPEN def_osp_cur;
191:
192: FETCH def_osp_cur
193: INTO Ctx(qa_ss_const.Item), Ctx(qa_ss_const.Vendor_Name), Ctx(qa_ss_const.Job_Name),
194: Ctx(qa_ss_const.Po_Number), Ctx(qa_ss_const.Vender_Item_Number),
195: Ctx(qa_ss_const.From_op_seq_num), Ctx(qa_ss_const.uom_name),
196: Ctx(qa_ss_const.Production_Line), Ctx(qa_ss_const.Ordered_Quantity),
197: Ctx(qa_ss_const.Revision), Ctx(qa_ss_const.Po_Release_Num),

Line 194: Ctx(qa_ss_const.Po_Number), Ctx(qa_ss_const.Vender_Item_Number),

190: OPEN def_osp_cur;
191:
192: FETCH def_osp_cur
193: INTO Ctx(qa_ss_const.Item), Ctx(qa_ss_const.Vendor_Name), Ctx(qa_ss_const.Job_Name),
194: Ctx(qa_ss_const.Po_Number), Ctx(qa_ss_const.Vender_Item_Number),
195: Ctx(qa_ss_const.From_op_seq_num), Ctx(qa_ss_const.uom_name),
196: Ctx(qa_ss_const.Production_Line), Ctx(qa_ss_const.Ordered_Quantity),
197: Ctx(qa_ss_const.Revision), Ctx(qa_ss_const.Po_Release_Num),
198: l_po_header_id, l_po_release_id, X_Item_ID,

Line 195: Ctx(qa_ss_const.From_op_seq_num), Ctx(qa_ss_const.uom_name),

191:
192: FETCH def_osp_cur
193: INTO Ctx(qa_ss_const.Item), Ctx(qa_ss_const.Vendor_Name), Ctx(qa_ss_const.Job_Name),
194: Ctx(qa_ss_const.Po_Number), Ctx(qa_ss_const.Vender_Item_Number),
195: Ctx(qa_ss_const.From_op_seq_num), Ctx(qa_ss_const.uom_name),
196: Ctx(qa_ss_const.Production_Line), Ctx(qa_ss_const.Ordered_Quantity),
197: Ctx(qa_ss_const.Revision), Ctx(qa_ss_const.Po_Release_Num),
198: l_po_header_id, l_po_release_id, X_Item_ID,
199: X_Wip_Entity_Type, X_Wip_Rep_Sch_Id,

Line 196: Ctx(qa_ss_const.Production_Line), Ctx(qa_ss_const.Ordered_Quantity),

192: FETCH def_osp_cur
193: INTO Ctx(qa_ss_const.Item), Ctx(qa_ss_const.Vendor_Name), Ctx(qa_ss_const.Job_Name),
194: Ctx(qa_ss_const.Po_Number), Ctx(qa_ss_const.Vender_Item_Number),
195: Ctx(qa_ss_const.From_op_seq_num), Ctx(qa_ss_const.uom_name),
196: Ctx(qa_ss_const.Production_Line), Ctx(qa_ss_const.Ordered_Quantity),
197: Ctx(qa_ss_const.Revision), Ctx(qa_ss_const.Po_Release_Num),
198: l_po_header_id, l_po_release_id, X_Item_ID,
199: X_Wip_Entity_Type, X_Wip_Rep_Sch_Id,
200: X_Po_Line_Id, X_Line_Location_Id,

Line 197: Ctx(qa_ss_const.Revision), Ctx(qa_ss_const.Po_Release_Num),

193: INTO Ctx(qa_ss_const.Item), Ctx(qa_ss_const.Vendor_Name), Ctx(qa_ss_const.Job_Name),
194: Ctx(qa_ss_const.Po_Number), Ctx(qa_ss_const.Vender_Item_Number),
195: Ctx(qa_ss_const.From_op_seq_num), Ctx(qa_ss_const.uom_name),
196: Ctx(qa_ss_const.Production_Line), Ctx(qa_ss_const.Ordered_Quantity),
197: Ctx(qa_ss_const.Revision), Ctx(qa_ss_const.Po_Release_Num),
198: l_po_header_id, l_po_release_id, X_Item_ID,
199: X_Wip_Entity_Type, X_Wip_Rep_Sch_Id,
200: X_Po_Line_Id, X_Line_Location_Id,
201: X_Po_Distribution_Id, X_Wip_Entity_ID,

Line 254: Ctx qa_ss_const.Ctx_Table;

250: PK10 IN VARCHAR2 DEFAULT NULL )
251:
252: IS
253: P_Organization_Id NUMBER;
254: Ctx qa_ss_const.Ctx_Table;
255:
256: CURSOR osp_cur IS
257: SELECT Assembly_Item_Number, Vendor_Name, Wip_Entity_Name,
258: Base_Po_Num, Supplier_Item_Number,

Line 274: INTO Ctx(qa_ss_const.Item), Ctx(qa_ss_const.Vendor_Name), Ctx(qa_ss_const.Job_Name),

270: if (icx_sec.validatesession) then
271: OPEN osp_cur;
272:
273: FETCH osp_cur
274: INTO Ctx(qa_ss_const.Item), Ctx(qa_ss_const.Vendor_Name), Ctx(qa_ss_const.Job_Name),
275: Ctx(qa_ss_const.Po_Number), Ctx(qa_ss_const.Vender_Item_Number),
276: Ctx(qa_ss_const.From_op_seq_num), Ctx(qa_ss_const.uom_name),
277: Ctx(qa_ss_const.Production_Line), Ctx(qa_ss_const.Ordered_Quantity),
278: Ctx(qa_ss_const.Revision), Ctx(qa_ss_const.Po_Release_Num),

Line 275: Ctx(qa_ss_const.Po_Number), Ctx(qa_ss_const.Vender_Item_Number),

271: OPEN osp_cur;
272:
273: FETCH osp_cur
274: INTO Ctx(qa_ss_const.Item), Ctx(qa_ss_const.Vendor_Name), Ctx(qa_ss_const.Job_Name),
275: Ctx(qa_ss_const.Po_Number), Ctx(qa_ss_const.Vender_Item_Number),
276: Ctx(qa_ss_const.From_op_seq_num), Ctx(qa_ss_const.uom_name),
277: Ctx(qa_ss_const.Production_Line), Ctx(qa_ss_const.Ordered_Quantity),
278: Ctx(qa_ss_const.Revision), Ctx(qa_ss_const.Po_Release_Num),
279: P_Organization_Id;

Line 276: Ctx(qa_ss_const.From_op_seq_num), Ctx(qa_ss_const.uom_name),

272:
273: FETCH osp_cur
274: INTO Ctx(qa_ss_const.Item), Ctx(qa_ss_const.Vendor_Name), Ctx(qa_ss_const.Job_Name),
275: Ctx(qa_ss_const.Po_Number), Ctx(qa_ss_const.Vender_Item_Number),
276: Ctx(qa_ss_const.From_op_seq_num), Ctx(qa_ss_const.uom_name),
277: Ctx(qa_ss_const.Production_Line), Ctx(qa_ss_const.Ordered_Quantity),
278: Ctx(qa_ss_const.Revision), Ctx(qa_ss_const.Po_Release_Num),
279: P_Organization_Id;
280:

Line 277: Ctx(qa_ss_const.Production_Line), Ctx(qa_ss_const.Ordered_Quantity),

273: FETCH osp_cur
274: INTO Ctx(qa_ss_const.Item), Ctx(qa_ss_const.Vendor_Name), Ctx(qa_ss_const.Job_Name),
275: Ctx(qa_ss_const.Po_Number), Ctx(qa_ss_const.Vender_Item_Number),
276: Ctx(qa_ss_const.From_op_seq_num), Ctx(qa_ss_const.uom_name),
277: Ctx(qa_ss_const.Production_Line), Ctx(qa_ss_const.Ordered_Quantity),
278: Ctx(qa_ss_const.Revision), Ctx(qa_ss_const.Po_Release_Num),
279: P_Organization_Id;
280:
281: CLOSE osp_cur;

Line 278: Ctx(qa_ss_const.Revision), Ctx(qa_ss_const.Po_Release_Num),

274: INTO Ctx(qa_ss_const.Item), Ctx(qa_ss_const.Vendor_Name), Ctx(qa_ss_const.Job_Name),
275: Ctx(qa_ss_const.Po_Number), Ctx(qa_ss_const.Vender_Item_Number),
276: Ctx(qa_ss_const.From_op_seq_num), Ctx(qa_ss_const.uom_name),
277: Ctx(qa_ss_const.Production_Line), Ctx(qa_ss_const.Ordered_Quantity),
278: Ctx(qa_ss_const.Revision), Ctx(qa_ss_const.Po_Release_Num),
279: P_Organization_Id;
280:
281: CLOSE osp_cur;
282: -- Now Ctx is populated. Also, populated P_Organization_Id above