PACKAGE: APPS.QA_SS_OSP

Source

1 package qa_ss_osp AUTHID CURRENT_USER as
2 /* $Header: qltssopb.pls 115.12 2002/11/27 19:33:49 jezheng ship $ */
3 
4 function are_osp_plans_applicable (
5 		P_Item_Number IN VARCHAR2 DEFAULT NULL,
6 		P_Supplier IN VARCHAR2 DEFAULT NULL,
7 		P_Wip_Entity_Name IN VARCHAR2 DEFAULT NULL,
8 		P_Po_Number IN VARCHAR2 DEFAULT NULL,
9 		P_Vendor_Item_Number IN VARCHAR2 DEFAULT NULL,
10 		P_Wip_Operation_Seq_Num IN NUMBER DEFAULT NULL,
11 		P_UOM_Name IN VARCHAR2 DEFAULT NULL,
12 		P_Production_Line IN VARCHAR2 DEFAULT NULL,
13 		P_Quantity_Ordered IN NUMBER DEFAULT NULL,
14 		P_Item_Revision IN VARCHAR2 DEFAULT NULL,
15 		P_Po_Release_Number IN NUMBER DEFAULT NULL,
16 		P_Organization_Id IN NUMBER DEFAULT NULL,
17         	P_Wip_Entity_Type IN NUMBER DEFAULT NULL)
18 
19 	Return VARCHAR2;
20 
21 
22 procedure osp_to_quality (
23 			PK1 IN VARCHAR2 DEFAULT NULL,
24 			PK2 IN VARCHAR2 DEFAULT NULL,
25 			PK3 IN VARCHAR2 DEFAULT NULL,
26 			PK4 IN VARCHAR2 DEFAULT NULL,
27 			PK5 IN VARCHAR2 DEFAULT NULL,
28 			PK6 IN VARCHAR2 DEFAULT NULL,
29 			PK7 IN VARCHAR2 DEFAULT NULL,
30 			PK8 IN VARCHAR2 DEFAULT NULL,
31 			PK9 IN VARCHAR2 DEFAULT NULL,
32 			PK10 IN VARCHAR2 DEFAULT NULL,
33 			c_outputs1 OUT NOCOPY VARCHAR2,
34 			c_outputs2 OUT NOCOPY VARCHAR2,
35 			c_outputs3 OUT NOCOPY VARCHAR2,
36 			c_outputs4 OUT NOCOPY VARCHAR2,
37 			c_outputs5 OUT NOCOPY VARCHAR2,
38 			c_outputs6 OUT NOCOPY VARCHAR2,
39 			c_outputs7 OUT NOCOPY VARCHAR2,
40 			c_outputs8 OUT NOCOPY VARCHAR2,
41 			c_outputs9 OUT NOCOPY VARCHAR2,
42 			c_outputs10 OUT NOCOPY VARCHAR2);
43 
44 
45 
46 procedure default_osp_values (Ctx IN OUT NOCOPY qa_ss_const.Ctx_Table,
47 			Txn_Num IN NUMBER DEFAULT NULL,
48 			PK1 IN VARCHAR2 DEFAULT NULL,
49 			PK2 IN VARCHAR2 DEFAULT NULL,
50 			PK3 IN VARCHAR2 DEFAULT NULL,
51 			PK4 IN VARCHAR2 DEFAULT NULL,
52 			PK5 IN VARCHAR2 DEFAULT NULL,
53 			PK6 IN VARCHAR2 DEFAULT NULL,
54 			PK7 IN VARCHAR2 DEFAULT NULL,
55 			PK8 IN VARCHAR2 DEFAULT NULL,
56 			PK9 IN VARCHAR2 DEFAULT NULL,
57 			PK10 IN VARCHAR2 DEFAULT NULL,
58 			X_PO_AGENT_ID OUT NOCOPY NUMBER,
59             X_Item_Id OUT NOCOPY NUMBER,
60             X_PO_HEADER_ID OUT NOCOPY NUMBER,
61             X_Wip_Entity_Type OUT NOCOPY NUMBER,
62             X_Wip_Rep_Sch_Id OUT NOCOPY NUMBER,
63             X_Po_Release_Id OUT NOCOPY NUMBER,
64             X_Po_Line_Id OUT NOCOPY NUMBER,
65             X_Line_Location_Id OUT NOCOPY NUMBER,
66             X_Po_Distribution_Id OUT NOCOPY NUMBER,
67             X_Wip_Entity_Id OUT NOCOPY NUMBER,
68             X_Wip_Line_Id OUT NOCOPY NUMBER,
69             X_Po_Shipment_Id OUT NOCOPY NUMBER,
70 	    X_Organization_Id OUT NOCOPY NUMBER);
71 
72 -- Below procedure to be called from qa_ss_core.plan_list_frames
73 procedure osp_plans (
74             PK1 IN VARCHAR2 DEFAULT NULL,
75 			PK2 IN VARCHAR2 DEFAULT NULL,
76 			PK3 IN VARCHAR2 DEFAULT NULL,
77 			PK4 IN VARCHAR2 DEFAULT NULL,
78 			PK5 IN VARCHAR2 DEFAULT NULL,
79 			PK6 IN VARCHAR2 DEFAULT NULL,
80 			PK7 IN VARCHAR2 DEFAULT NULL,
81 			PK8 IN VARCHAR2 DEFAULT NULL,
82 			PK9 IN VARCHAR2 DEFAULT NULL,
83 			PK10 IN VARCHAR2 DEFAULT NULL );
84 
85 end qa_ss_osp;
86