[Home] [Help]
PACKAGE: APPS.QP_PRICING_ATTRIBUTE_PVT
Source
1 PACKAGE QP_PRICING_ATTRIBUTE_PVT AUTHID CURRENT_USER as
2 /* $Header: QPXVPRAS.pls 115.0 99/10/14 18:54:35 porting ship $ */
3
4 PROCEDURE Insert_Row(
5 X_PRICING_ATTRIBUTE_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_LIST_LINE_ID NUMBER
16 , X_EXCLUDER_FLAG VARCHAR2
17 , X_ACCUMULATE_FLAG VARCHAR2
18 , X_PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2
19 , X_PRODUCT_ATTRIBUTE VARCHAR2
20 , X_PRODUCT_ATTR_VALUE VARCHAR2
21 , X_PRODUCT_UOM_CODE VARCHAR2
22 , X_PRICING_ATTRIBUTE_CONTEXT VARCHAR2
23 , X_PRICING_ATTRIBUTE VARCHAR2
24 , X_PRICING_ATTR_VALUE_FROM VARCHAR2
25 , X_PRICING_ATTR_VALUE_TO VARCHAR2
26 , X_ATTRIBUTE_GROUPING_NO NUMBER
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
47 PROCEDURE Lock_Row(
48 X_PRICING_ATTRIBUTE_ID IN OUT NUMBER
49 , X_CREATION_DATE DATE
50 , X_CREATED_BY NUMBER
51 , X_LAST_UPDATE_DATE DATE
52 , X_LAST_UPDATED_BY NUMBER
53 , X_LAST_UPDATE_LOGIN NUMBER
54 , X_PROGRAM_APPLICATION_ID NUMBER
55 , X_PROGRAM_ID NUMBER
56 , X_PROGRAM_UPDATE_DATE DATE
57 , X_REQUEST_ID NUMBER
58 , X_LIST_LINE_ID NUMBER
59 , X_EXCLUDER_FLAG VARCHAR2
60 , X_ACCUMULATE_FLAG VARCHAR2
61 , X_PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2
62 , X_PRODUCT_ATTRIBUTE VARCHAR2
63 , X_PRODUCT_ATTR_VALUE VARCHAR2
64 , X_PRODUCT_UOM_CODE VARCHAR2
65 , X_PRICING_ATTRIBUTE_CONTEXT VARCHAR2
66 , X_PRICING_ATTRIBUTE VARCHAR2
67 , X_PRICING_ATTR_VALUE_FROM VARCHAR2
68 , X_PRICING_ATTR_VALUE_TO VARCHAR2
69 , X_ATTRIBUTE_GROUPING_NO NUMBER
70 , X_CONTEXT VARCHAR2
71 , X_ATTRIBUTE1 VARCHAR2
72 , X_ATTRIBUTE2 VARCHAR2
73 , X_ATTRIBUTE3 VARCHAR2
74 , X_ATTRIBUTE4 VARCHAR2
75 , X_ATTRIBUTE5 VARCHAR2
76 , X_ATTRIBUTE6 VARCHAR2
77 , X_ATTRIBUTE7 VARCHAR2
78 , X_ATTRIBUTE8 VARCHAR2
79 , X_ATTRIBUTE9 VARCHAR2
80 , X_ATTRIBUTE10 VARCHAR2
81 , X_ATTRIBUTE11 VARCHAR2
82 , X_ATTRIBUTE12 VARCHAR2
83 , X_ATTRIBUTE13 VARCHAR2
84 , X_ATTRIBUTE14 VARCHAR2
85 , X_ATTRIBUTE15 VARCHAR2
86 );
87
88
89 PROCEDURE Update_Row(
90 X_PRICING_ATTRIBUTE_ID IN OUT NUMBER
91 , X_CREATION_DATE DATE
92 , X_CREATED_BY NUMBER
93 , X_LAST_UPDATE_DATE DATE
94 , X_LAST_UPDATED_BY NUMBER
95 , X_LAST_UPDATE_LOGIN NUMBER
96 , X_PROGRAM_APPLICATION_ID NUMBER
97 , X_PROGRAM_ID NUMBER
98 , X_PROGRAM_UPDATE_DATE DATE
99 , X_REQUEST_ID NUMBER
100 , X_LIST_LINE_ID NUMBER
101 , X_EXCLUDER_FLAG VARCHAR2
102 , X_ACCUMULATE_FLAG VARCHAR2
103 , X_PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2
104 , X_PRODUCT_ATTRIBUTE VARCHAR2
105 , X_PRODUCT_ATTR_VALUE VARCHAR2
106 , X_PRODUCT_UOM_CODE VARCHAR2
107 , X_PRICING_ATTRIBUTE_CONTEXT VARCHAR2
108 , X_PRICING_ATTRIBUTE VARCHAR2
109 , X_PRICING_ATTR_VALUE_FROM VARCHAR2
110 , X_PRICING_ATTR_VALUE_TO VARCHAR2
111 , X_ATTRIBUTE_GROUPING_NO NUMBER
112 , X_CONTEXT VARCHAR2
113 , X_ATTRIBUTE1 VARCHAR2
114 , X_ATTRIBUTE2 VARCHAR2
115 , X_ATTRIBUTE3 VARCHAR2
116 , X_ATTRIBUTE4 VARCHAR2
117 , X_ATTRIBUTE5 VARCHAR2
118 , X_ATTRIBUTE6 VARCHAR2
119 , X_ATTRIBUTE7 VARCHAR2
120 , X_ATTRIBUTE8 VARCHAR2
121 , X_ATTRIBUTE9 VARCHAR2
122 , X_ATTRIBUTE10 VARCHAR2
123 , X_ATTRIBUTE11 VARCHAR2
124 , X_ATTRIBUTE12 VARCHAR2
125 , X_ATTRIBUTE13 VARCHAR2
126 , X_ATTRIBUTE14 VARCHAR2
127 , X_ATTRIBUTE15 VARCHAR2
128 );
129
130 PROCEDURE Delete_Row(
131 X_LIST_LINE_ID NUMBER
132 );
133
134
135 END QP_PRICING_ATTRIBUTE_PVT;