PACKAGE: APPS.QA_SS_OM

Source

1 package qa_ss_om AUTHID CURRENT_USER as
2 /* $Header: qltssomb.pls 115.4 2002/11/27 19:33:34 jezheng ship $ */
3 
4 type plan_info_rec is record (
5 		plan_id qa_plans.plan_id%type,
6 		name qa_plans.name%type,
7 		description qa_plans.description%type,
8 		meaning fnd_common_lookups.meaning%type);
9 
10 type plan_tab_type is table of plan_info_rec index by binary_integer;
11 
12 
13 function are_om_header_plans_applicable (
14 		P_So_Header_Id IN Number DEFAULT NULL
15 	)
16 
17 	Return VARCHAR2;
18 
19 function are_om_lines_plans_applicable (
20 		P_So_Header_Id IN Number DEFAULT NULL,
21 		P_Item_Id IN Number Default Null
22 	)
23 
24 	Return VARCHAR2;
25 
26 
27 procedure om_header_to_quality (
28 			PK1 IN VARCHAR2 DEFAULT NULL,
29 			PK2 IN VARCHAR2 DEFAULT NULL,
30 			PK3 IN VARCHAR2 DEFAULT NULL,
31 			PK4 IN VARCHAR2 DEFAULT NULL,
32 			PK5 IN VARCHAR2 DEFAULT NULL,
33 			PK6 IN VARCHAR2 DEFAULT NULL,
34 			PK7 IN VARCHAR2 DEFAULT NULL,
35 			PK8 IN VARCHAR2 DEFAULT NULL,
36 			PK9 IN VARCHAR2 DEFAULT NULL,
37 			PK10 IN VARCHAR2 DEFAULT NULL,
38 			c_outputs1 OUT NOCOPY VARCHAR2,
39 			c_outputs2 OUT NOCOPY VARCHAR2,
40 			c_outputs3 OUT NOCOPY VARCHAR2,
41 			c_outputs4 OUT NOCOPY VARCHAR2,
42 			c_outputs5 OUT NOCOPY VARCHAR2,
43 			c_outputs6 OUT NOCOPY VARCHAR2,
44 			c_outputs7 OUT NOCOPY VARCHAR2,
45 			c_outputs8 OUT NOCOPY VARCHAR2,
46 			c_outputs9 OUT NOCOPY VARCHAR2,
47 			c_outputs10 OUT NOCOPY VARCHAR2);
48 
49 procedure om_lines_to_quality (
50 			PK1 IN VARCHAR2 DEFAULT NULL,
51 			PK2 IN VARCHAR2 DEFAULT NULL,
52 			PK3 IN VARCHAR2 DEFAULT NULL,
53 			PK4 IN VARCHAR2 DEFAULT NULL,
54 			PK5 IN VARCHAR2 DEFAULT NULL,
55 			PK6 IN VARCHAR2 DEFAULT NULL,
56 			PK7 IN VARCHAR2 DEFAULT NULL,
57 			PK8 IN VARCHAR2 DEFAULT NULL,
58 			PK9 IN VARCHAR2 DEFAULT NULL,
59 			PK10 IN VARCHAR2 DEFAULT NULL,
60 			c_outputs1 OUT NOCOPY VARCHAR2,
61 			c_outputs2 OUT NOCOPY VARCHAR2,
62 			c_outputs3 OUT NOCOPY VARCHAR2,
63 			c_outputs4 OUT NOCOPY VARCHAR2,
64 			c_outputs5 OUT NOCOPY VARCHAR2,
65 			c_outputs6 OUT NOCOPY VARCHAR2,
66 			c_outputs7 OUT NOCOPY VARCHAR2,
67 			c_outputs8 OUT NOCOPY VARCHAR2,
68 			c_outputs9 OUT NOCOPY VARCHAR2,
69 			c_outputs10 OUT NOCOPY VARCHAR2);
70 
71 
72 procedure List_OM_Plans (plan_tab IN plan_tab_type,
73 			 P_so_header_id IN NUMBER Default Null,
74 			 P_item_id IN NUMBER DEFAULT Null);
75 
76 function is_om_header_plan_applicable (
77 		x_Pid IN NUMBER,
78 		x_so_header_id IN VARCHAR2 default null)
79 Return VARCHAR2;
80 
81 function is_om_lines_plan_applicable (
82 		x_Pid IN NUMBER,
83 		x_so_header_id IN VARCHAR2 default null,
84 		x_Item_Id in VARCHAR2 default null )
85 Return VARCHAR2;
86 
87 end qa_ss_om;
88