[Home] [Help]
PACKAGE: APPS.QASLSET_TABLE_HANDLER_PKG
Source
1 PACKAGE QASLSET_TABLE_HANDLER_PKG AUTHID CURRENT_USER as
2 /* $Header: qaslsets.pls 115.3 2002/11/27 19:19:04 jezheng ship $ */
3
4 PROCEDURE insert_process_row(
5 X_Rowid IN OUT NOCOPY VARCHAR2,
6 X_Process_id IN OUT NOCOPY NUMBER,
7 X_Process_Code VARCHAR2,
8 X_Description VARCHAR2,
9 X_Disqualification_Lots NUMBER default 1,
10 X_Disqualification_Days NUMBER,
11 X_Org_id NUMBER,
12 X_Last_Update_Date DATE,
13 X_Last_Updated_By NUMBER,
14 X_Creation_Date DATE,
15 X_Created_By NUMBER,
16 X_Last_Update_Login NUMBER
17 );
18
19
20 PROCEDURE insert_process_plans_row(
21 X_Rowid IN OUT NOCOPY VARCHAR2,
22 X_Process_Plan_id IN OUT NOCOPY NUMBER,
23 X_Process_id NUMBER,
24 X_Plan_id NUMBER,
25 X_Alternate_Plan_id NUMBER,
26 X_Last_Update_Date DATE,
27 X_Last_Updated_By NUMBER,
28 X_Creation_Date DATE,
29 X_Created_By NUMBER,
30 X_Last_Update_Login NUMBER
31 );
32
33
34 PROCEDURE insert_process_plan_rules_row(
35 X_Rowid IN OUT NOCOPY VARCHAR2,
36 X_Process_Plan_Rule_id IN OUT NOCOPY NUMBER,
37 X_Process_Plan_id NUMBER,
38 X_Rule_Seq NUMBER,
39 X_Frequency_Num NUMBER,
40 X_Frequency_Denom NUMBER,
41 X_Rounds NUMBER,
42 X_Days_Span NUMBER,
43 X_Last_Update_Date DATE,
44 X_Last_Updated_By NUMBER,
45 X_Creation_Date DATE,
46 X_Created_By NUMBER,
47 X_Last_Update_Login NUMBER
48 );
49
50
51
52 PROCEDURE update_process_row(
53 X_Rowid VARCHAR2,
54 X_Process_id NUMBER,
55 X_Process_Code VARCHAR2,
56 X_Description VARCHAR2,
57 X_Disqualification_Lots NUMBER default 1,
58 X_Disqualification_Days NUMBER,
59 X_Qualification_Lots NUMBER,
60 X_Qualification_Days NUMBER,
61 X_Org_id NUMBER,
62 X_Last_Update_Date DATE,
63 X_Last_Updated_By NUMBER,
64 X_Creation_Date DATE,
65 X_Created_By NUMBER,
66 X_Last_Update_Login NUMBER
67 );
68
69
70 PROCEDURE update_process_plans_row(
71 X_Rowid VARCHAR2,
72 X_Process_Plan_id NUMBER,
73 X_Process_id NUMBER,
74 X_Plan_id NUMBER,
75 X_Alternate_Plan_id NUMBER,
76 X_Last_Update_Date DATE,
77 X_Last_Updated_By NUMBER,
78 X_Creation_Date DATE,
79 X_Created_By NUMBER,
80 X_Last_Update_Login NUMBER
81 );
82
83
84 PROCEDURE update_process_plan_rules_row(
85 X_Rowid VARCHAR2,
86 X_Process_Plan_Rule_id NUMBER,
87 X_Process_Plan_id NUMBER,
88 X_Rule_Seq NUMBER,
89 X_Frequency_Num NUMBER,
90 X_Frequency_Denom NUMBER,
91 X_Rounds NUMBER,
92 X_Days_Span NUMBER,
93 X_Last_Update_Date DATE,
94 X_Last_Updated_By NUMBER,
95 X_Creation_Date DATE,
96 X_Created_By NUMBER,
97 X_Last_Update_Login NUMBER
98 );
99
100
101
102 PROCEDURE lock_process_row(
103 X_Rowid VARCHAR2,
104 X_Process_id NUMBER,
105 X_Process_Code VARCHAR2,
106 X_Description VARCHAR2,
107 X_Disqualification_Lots NUMBER default 1,
108 X_Disqualification_Days NUMBER,
109 X_Qualification_Lots NUMBER,
110 X_Qualification_Days NUMBER,
111 X_Org_id NUMBER,
112 X_Last_Update_Date DATE,
113 X_Last_Updated_By NUMBER,
114 X_Creation_Date DATE,
115 X_Created_By NUMBER,
116 X_Last_Update_Login NUMBER
117 );
118
119
120 PROCEDURE lock_process_plans_row(
121 X_Rowid VARCHAR2,
122 X_Process_Plan_id NUMBER,
123 X_Process_id NUMBER,
124 X_Plan_id NUMBER,
125 X_Alternate_Plan_id NUMBER,
126 X_Last_Update_Date DATE,
127 X_Last_Updated_By NUMBER,
128 X_Creation_Date DATE,
129 X_Created_By NUMBER,
130 X_Last_Update_Login NUMBER
131 );
132
133
134 PROCEDURE lock_process_plan_rules_row(
135 X_Rowid VARCHAR2,
136 X_Process_Plan_Rule_id NUMBER,
137 X_Process_Plan_id NUMBER,
138 X_Rule_Seq NUMBER,
139 X_Frequency_Num NUMBER,
140 X_Frequency_Denom NUMBER,
141 X_Rounds NUMBER,
142 X_Days_Span NUMBER,
143 X_Last_Update_Date DATE,
144 X_Last_Updated_By NUMBER,
145 X_Creation_Date DATE,
146 X_Created_By NUMBER,
147 X_Last_Update_Login NUMBER
148 );
149
150
151
152 PROCEDURE delete_process_row(X_Rowid VARCHAR2);
153
154 PROCEDURE delete_process_plans_row(X_Rowid VARCHAR2);
155
156 PROCEDURE delete_process_plan_rules_row(X_Rowid VARCHAR2);
157
158 END QASLSET_TABLE_HANDLER_PKG;