PACKAGE: APPS.QASPSET_TABLE_HANDLER_PKG

Source

1 PACKAGE QASPSET_TABLE_HANDLER_PKG AUTHID CURRENT_USER as
2 /* $Header: qaspsets.pls 115.3 2002/11/27 19:20:37 jezheng ship $ */
3 
4 PROCEDURE insert_plan_header_row(
5       X_Rowid                IN OUT NOCOPY VARCHAR2,
6       X_Sampling_Plan_id     IN OUT NOCOPY NUMBER,
7       X_Sampling_Plan_Code   VARCHAR2,
8       X_Description          VARCHAR2,
9       X_Insp_Level_Code      VARCHAR2,
10       X_Sampling_Std_Code    NUMBER,
11       X_AQL                  NUMBER,
12       X_Org_id		     NUMBER,
13       X_Last_Update_Date     DATE,
14       X_Last_Updated_By      NUMBER,
15       X_Creation_Date        DATE,
16       X_Created_By           NUMBER,
17       X_Last_Update_Login    NUMBER
18 );
19 
20 
21 
22 PROCEDURE insert_customized_rules_row(
23       X_Rowid                IN OUT NOCOPY VARCHAR2,
24       X_Rule_id              IN OUT NOCOPY NUMBER,
25       X_Sampling_Plan_id      NUMBER,
26       X_Min_Lot_Size         NUMBER,
27       X_Max_Lot_Size         NUMBER,
28       X_Sample_Size          NUMBER,
29       X_Last_Update_Date     DATE,
30       X_Last_Updated_By      NUMBER,
31       X_Creation_Date        DATE,
32       X_Created_By           NUMBER,
33       X_Last_Update_Login    NUMBER
34 );
35 
36 
37 
38 PROCEDURE update_plan_header_row(
39       X_Rowid                VARCHAR2,
40       X_Sampling_Plan_id     NUMBER,
41       X_Sampling_Plan_Code   VARCHAR2,
42       X_Description          VARCHAR2,
43       X_Insp_Level_Code      VARCHAR2,
44       X_Sampling_Std_Code    NUMBER,
45       X_AQL                  NUMBER,
46       X_Org_id		     NUMBER,
47       X_Last_Update_Date     DATE,
48       X_Last_Updated_By      NUMBER,
49       X_Creation_Date        DATE,
50       X_Created_By           NUMBER,
51       X_Last_Update_Login    NUMBER
52 );
53 
54 
55 
56 PROCEDURE update_customized_rules_row(
57       X_Rowid                VARCHAR2,
58       X_Rule_id              NUMBER,
59       X_Sampling_Plan_id     NUMBER,
60       X_Min_Lot_Size         NUMBER,
61       X_Max_Lot_Size         NUMBER,
62       X_Sample_Size          NUMBER,
63       X_Last_Update_Date     DATE,
64       X_Last_Updated_By      NUMBER,
65       X_Creation_Date        DATE,
66       X_Created_By           NUMBER,
67       X_Last_Update_Login    NUMBER
68 );
69 
70 
71 
72 PROCEDURE lock_plan_header_row(
73       X_Rowid                VARCHAR2,
74       X_Sampling_Plan_id     NUMBER,
75       X_Sampling_Plan_Code   VARCHAR2,
76       X_Description          VARCHAR2,
77       X_Insp_Level_Code      VARCHAR2,
78       X_Sampling_Std_Code    NUMBER,
79       X_AQL                  NUMBER,
80       X_Org_id		     NUMBER,
81       X_Last_Update_Date     DATE,
82       X_Last_Updated_By      NUMBER,
83       X_Creation_Date        DATE,
84       X_Created_By           NUMBER,
85       X_Last_Update_Login    NUMBER
86 );
87 
88 
89 
90 PROCEDURE lock_customized_rules_row(
91       X_Rowid                VARCHAR2,
92       X_Rule_id              NUMBER,
93       X_Sampling_Plan_id     NUMBER,
94       X_Min_Lot_Size         NUMBER,
95       X_Max_Lot_Size         NUMBER,
96       X_Sample_Size          NUMBER,
97       X_Last_Update_Date     DATE,
98       X_Last_Updated_By      NUMBER,
99       X_Creation_Date        DATE,
100       X_Created_By           NUMBER,
101       X_Last_Update_Login    NUMBER
102 );
103 
104 
105 
106 PROCEDURE delete_plan_header_row(X_Rowid VARCHAR2);
107 
108 PROCEDURE delete_customized_rules_row(X_Rowid VARCHAR2);
109 
110 END QASPSET_TABLE_HANDLER_PKG;