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
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;
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
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);
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;
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;
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;
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);
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);
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(
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,
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,
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,
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:
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,
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),
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,
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,
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,
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,
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,
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),
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;
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:
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;
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