[Home] [Help]
PACKAGE: APPS.QP_QUALIFIER_PVT
Source
1 PACKAGE QP_QUALIFIER_PVT AUTHID CURRENT_USER as
2 /* $Header: QPXVQFRS.pls 115.0 99/10/14 18:54:50 porting ship $ */
3
4 PROCEDURE Insert_Row(
5 X_QUALIFIER_ID IN OUT NUMBER
6 , X_CREATION_DATE DATE
7 , X_CREATED_BY NUMBER
8 , X_LAST_UPDATE_DATE DATE
9 , X_LAST_UPDATED_BY NUMBER
10 , X_LAST_UPDATE_LOGIN NUMBER
11 , X_PROGRAM_APPLICATION_ID NUMBER
12 , X_PROGRAM_ID NUMBER
13 , X_PROGRAM_UPDATE_DATE DATE
14 , X_REQUEST_ID NUMBER
15 , X_EXCLUDER_FLAG VARCHAR2
16 , X_COMPARISON_OPERATOR_CODE VARCHAR2
17 , X_QUALIFIER_CONTEXT VARCHAR2
18 , X_QUALIFIER_ATTRIBUTE VARCHAR2
19 , X_QUALIFIER_RULE_ID NUMBER
20 , X_QUALIFIER_GROUPING_NO NUMBER
21 , X_QUALIFIER_ATTR_VALUE VARCHAR2
22 , X_LIST_HEADER_ID NUMBER
23 , X_LIST_LINE_ID NUMBER
24 , X_CREATED_FROM_RULE_ID NUMBER
25 , X_START_DATE_ACTIVE DATE
26 , X_END_DATE_ACTIVE DATE
27 , X_CONTEXT VARCHAR2
28 , X_ATTRIBUTE1 VARCHAR2
29 , X_ATTRIBUTE2 VARCHAR2
30 , X_ATTRIBUTE3 VARCHAR2
31 , X_ATTRIBUTE4 VARCHAR2
32 , X_ATTRIBUTE5 VARCHAR2
33 , X_ATTRIBUTE6 VARCHAR2
34 , X_ATTRIBUTE7 VARCHAR2
35 , X_ATTRIBUTE8 VARCHAR2
36 , X_ATTRIBUTE9 VARCHAR2
37 , X_ATTRIBUTE10 VARCHAR2
38 , X_ATTRIBUTE11 VARCHAR2
39 , X_ATTRIBUTE12 VARCHAR2
40 , X_ATTRIBUTE13 VARCHAR2
41 , X_ATTRIBUTE14 VARCHAR2
42 , X_ATTRIBUTE15 VARCHAR2
43 );
44
45
46 PROCEDURE Lock_Row(
47 X_QUALIFIER_ID IN OUT NUMBER
48 , X_CREATION_DATE DATE
49 , X_CREATED_BY NUMBER
50 , X_LAST_UPDATE_DATE DATE
51 , X_LAST_UPDATED_BY NUMBER
52 , X_LAST_UPDATE_LOGIN NUMBER
53 , X_PROGRAM_APPLICATION_ID NUMBER
54 , X_PROGRAM_ID NUMBER
55 , X_PROGRAM_UPDATE_DATE DATE
56 , X_REQUEST_ID NUMBER
57 , X_EXCLUDER_FLAG VARCHAR2
58 , X_COMPARISON_OPERATOR_CODE VARCHAR2
59 , X_QUALIFIER_CONTEXT VARCHAR2
60 , X_QUALIFIER_ATTRIBUTE VARCHAR2
61 , X_QUALIFIER_RULE_ID NUMBER
62 , X_QUALIFIER_GROUPING_NO NUMBER
63 , X_QUALIFIER_ATTR_VALUE VARCHAR2
64 , X_LIST_HEADER_ID NUMBER
65 , X_LIST_LINE_ID NUMBER
66 , X_CREATED_FROM_RULE_ID NUMBER
67 , X_START_DATE_ACTIVE DATE
68 , X_END_DATE_ACTIVE DATE
69 , X_CONTEXT VARCHAR2
70 , X_ATTRIBUTE1 VARCHAR2
71 , X_ATTRIBUTE2 VARCHAR2
72 , X_ATTRIBUTE3 VARCHAR2
73 , X_ATTRIBUTE4 VARCHAR2
74 , X_ATTRIBUTE5 VARCHAR2
75 , X_ATTRIBUTE6 VARCHAR2
76 , X_ATTRIBUTE7 VARCHAR2
77 , X_ATTRIBUTE8 VARCHAR2
78 , X_ATTRIBUTE9 VARCHAR2
79 , X_ATTRIBUTE10 VARCHAR2
80 , X_ATTRIBUTE11 VARCHAR2
81 , X_ATTRIBUTE12 VARCHAR2
82 , X_ATTRIBUTE13 VARCHAR2
83 , X_ATTRIBUTE14 VARCHAR2
84 , X_ATTRIBUTE15 VARCHAR2
85 );
86
87
88 PROCEDURE Update_Row(
89 X_QUALIFIER_ID IN OUT NUMBER
90 , X_CREATION_DATE DATE
91 , X_CREATED_BY NUMBER
92 , X_LAST_UPDATE_DATE DATE
93 , X_LAST_UPDATED_BY NUMBER
94 , X_LAST_UPDATE_LOGIN NUMBER
95 , X_PROGRAM_APPLICATION_ID NUMBER
96 , X_PROGRAM_ID NUMBER
97 , X_PROGRAM_UPDATE_DATE DATE
98 , X_REQUEST_ID NUMBER
99 , X_EXCLUDER_FLAG VARCHAR2
100 , X_COMPARISON_OPERATOR_CODE VARCHAR2
101 , X_QUALIFIER_CONTEXT VARCHAR2
102 , X_QUALIFIER_ATTRIBUTE VARCHAR2
103 , X_QUALIFIER_RULE_ID NUMBER
104 , X_QUALIFIER_GROUPING_NO NUMBER
105 , X_QUALIFIER_ATTR_VALUE VARCHAR2
106 , X_LIST_HEADER_ID NUMBER
107 , X_LIST_LINE_ID NUMBER
108 , X_CREATED_FROM_RULE_ID NUMBER
109 , X_START_DATE_ACTIVE DATE
110 , X_END_DATE_ACTIVE DATE
111 , X_CONTEXT VARCHAR2
112 , X_ATTRIBUTE1 VARCHAR2
113 , X_ATTRIBUTE2 VARCHAR2
114 , X_ATTRIBUTE3 VARCHAR2
115 , X_ATTRIBUTE4 VARCHAR2
116 , X_ATTRIBUTE5 VARCHAR2
117 , X_ATTRIBUTE6 VARCHAR2
118 , X_ATTRIBUTE7 VARCHAR2
119 , X_ATTRIBUTE8 VARCHAR2
120 , X_ATTRIBUTE9 VARCHAR2
121 , X_ATTRIBUTE10 VARCHAR2
122 , X_ATTRIBUTE11 VARCHAR2
123 , X_ATTRIBUTE12 VARCHAR2
124 , X_ATTRIBUTE13 VARCHAR2
125 , X_ATTRIBUTE14 VARCHAR2
126 , X_ATTRIBUTE15 VARCHAR2
127 );
128
129 PROCEDURE Delete_Row(
130 X_ID NUMBER
131 ,X_HEADER_LINE_FLAG VARCHAR2
132 );
133
134
135 END QP_QUALIFIER_PVT;