PACKAGE: APPS.QA_SS_SHIP

Source

1 package qa_ss_ship AUTHID CURRENT_USER as
2 /* $Header: qltssshb.pls 115.10 2002/11/27 19:34:21 jezheng ship $ */
3 
4 
5 function are_ship_plans_applicable (
6 		P_Po_Number IN VARCHAR2 DEFAULT NULL,
7 		P_Po_Line_Num IN VARCHAR2 DEFAULT NULL,
8 		P_Po_Release_Num IN VARCHAR2 DEFAULT NULL,
9 		P_Shipment_Num IN VARCHAR2 DEFAULT NULL,
10 		P_Location IN VARCHAR2 DEFAULT NULL,
11 		P_Supplier_Item IN VARCHAR2 DEFAULT NULL,
12 		P_Ord_Qty IN VARCHAR2 DEFAULT NULL,
13 		P_Uom_Name IN VARCHAR2 DEFAULT NULL,
14 		P_Vendor IN VARCHAR2 DEFAULT NULL,
15 		P_Vendor_Site IN VARCHAR2 DEFAULT NULL,
16 		P_Organization IN VARCHAR2 DEFAULT NULL,
17 		P_Item IN VARCHAR2 DEFAULT NULL,
18 		P_Item_Rev IN VARCHAR2 DEFAULT NULL,
19 		P_Item_Cat IN VARCHAR2 DEFAULT NULL
20 	)
21 
22 	Return VARCHAR2;
23 
24 
25 procedure ship_to_quality (
26 			PK1 IN VARCHAR2 DEFAULT NULL,
27 			PK2 IN VARCHAR2 DEFAULT NULL,
28 			PK3 IN VARCHAR2 DEFAULT NULL,
29 			PK4 IN VARCHAR2 DEFAULT NULL,
30 			PK5 IN VARCHAR2 DEFAULT NULL,
31 			PK6 IN VARCHAR2 DEFAULT NULL,
32 			PK7 IN VARCHAR2 DEFAULT NULL,
33 			PK8 IN VARCHAR2 DEFAULT NULL,
34 			PK9 IN VARCHAR2 DEFAULT NULL,
35 			PK10 IN VARCHAR2 DEFAULT NULL,
36 			c_outputs1 OUT NOCOPY VARCHAR2,
37 			c_outputs2 OUT NOCOPY VARCHAR2,
38 			c_outputs3 OUT NOCOPY VARCHAR2,
39 			c_outputs4 OUT NOCOPY VARCHAR2,
40 			c_outputs5 OUT NOCOPY VARCHAR2,
41 			c_outputs6 OUT NOCOPY VARCHAR2,
42 			c_outputs7 OUT NOCOPY VARCHAR2,
43 			c_outputs8 OUT NOCOPY VARCHAR2,
44 			c_outputs9 OUT NOCOPY VARCHAR2,
45 			c_outputs10 OUT NOCOPY VARCHAR2);
46 
47 
48 
49 procedure default_ship_values (Ctx IN OUT NOCOPY qa_ss_const.Ctx_Table,
50 			Txn_Num IN NUMBER DEFAULT NULL,
51 			PK1 IN VARCHAR2 DEFAULT NULL,
52 			PK2 IN VARCHAR2 DEFAULT NULL,
53 			PK3 IN VARCHAR2 DEFAULT NULL,
54 			PK4 IN VARCHAR2 DEFAULT NULL,
55 			PK5 IN VARCHAR2 DEFAULT NULL,
56 			PK6 IN VARCHAR2 DEFAULT NULL,
57 			PK7 IN VARCHAR2 DEFAULT NULL,
58 			PK8 IN VARCHAR2 DEFAULT NULL,
59 			PK9 IN VARCHAR2 DEFAULT NULL,
60 			PK10 IN VARCHAR2 DEFAULT NULL,
61 			X_PO_AGENT_ID OUT NOCOPY NUMBER,
62             X_Item_Id OUT NOCOPY NUMBER,
63             X_PO_HEADER_ID OUT NOCOPY NUMBER,
64             X_Wip_Entity_Type OUT NOCOPY NUMBER,
65             X_Wip_Rep_Sch_Id OUT NOCOPY NUMBER,
66             X_Po_Release_Id OUT NOCOPY NUMBER,
67             X_Po_Line_Id OUT NOCOPY NUMBER,
68             X_Line_Location_Id OUT NOCOPY NUMBER,
69             X_Po_Distribution_Id OUT NOCOPY NUMBER,
70             X_Wip_Entity_Id OUT NOCOPY NUMBER,
71             X_Wip_Line_Id OUT NOCOPY NUMBER,
72             X_Po_Shipment_Id OUT NOCOPY NUMBER,
73 	    X_Organization_Id OUT NOCOPY NUMBER);
74 
75 -- Below procedure is for call from qa_ss_core.plan_list_frames
76 procedure shipping_plans (
77             PK1 IN VARCHAR2 DEFAULT NULL,
78 			PK2 IN VARCHAR2 DEFAULT NULL,
79 			PK3 IN VARCHAR2 DEFAULT NULL,
80 			PK4 IN VARCHAR2 DEFAULT NULL,
81 			PK5 IN VARCHAR2 DEFAULT NULL,
82 			PK6 IN VARCHAR2 DEFAULT NULL,
83 			PK7 IN VARCHAR2 DEFAULT NULL,
84 			PK8 IN VARCHAR2 DEFAULT NULL,
85 			PK9 IN VARCHAR2 DEFAULT NULL,
86 			PK10 IN VARCHAR2 DEFAULT NULL );
87 
88 
89 end qa_ss_ship;
90