1 PACKAGE OE_OE_Form_Contract AUTHID CURRENT_USER AS
2 /* $Header: OEXFPCTS.pls 115.0 99/07/15 19:22:36 porting shi $ */
3
4 PROCEDURE Get_Startup_Values
5 (Item_Id_Flex_Code IN VARCHAR2,
6 Item_Id_Flex_Num OUT NUMBER);
7
8 -- Procedure : Default_Attributes
9 --
10
11 PROCEDURE Default_Attributes
12 ( x_return_status OUT VARCHAR2
13 , x_msg_count OUT NUMBER
14 , x_msg_data OUT VARCHAR2
15 , x_agreement_id OUT NUMBER
16 , x_attribute1 OUT VARCHAR2
17 , x_attribute10 OUT VARCHAR2
18 , x_attribute11 OUT VARCHAR2
19 , x_attribute12 OUT VARCHAR2
20 , x_attribute13 OUT VARCHAR2
21 , x_attribute14 OUT VARCHAR2
22 , x_attribute15 OUT VARCHAR2
23 , x_attribute2 OUT VARCHAR2
24 , x_attribute3 OUT VARCHAR2
25 , x_attribute4 OUT VARCHAR2
26 , x_attribute5 OUT VARCHAR2
27 , x_attribute6 OUT VARCHAR2
28 , x_attribute7 OUT VARCHAR2
29 , x_attribute8 OUT VARCHAR2
30 , x_attribute9 OUT VARCHAR2
31 , x_context OUT VARCHAR2
32 , x_discount_id OUT NUMBER
33 , x_last_updated_by OUT NUMBER
34 , x_price_list_id OUT NUMBER
35 , x_pricing_contract_id OUT NUMBER
36 , x_agreement OUT VARCHAR2
37 , x_discount OUT VARCHAR2
38 , x_price_list OUT VARCHAR2
39 );
40
41 -- Procedure : Change_Attribute
42 --
43
44 PROCEDURE Change_Attribute
45 ( x_return_status OUT VARCHAR2
46 , x_msg_count OUT NUMBER
47 , x_msg_data OUT VARCHAR2
48 , p_pricing_contract_id IN NUMBER
49 , p_attr_id IN NUMBER
50 , p_attr_value IN VARCHAR2
51 , p_attribute1 IN VARCHAR2
52 , p_attribute10 IN VARCHAR2
53 , p_attribute11 IN VARCHAR2
54 , p_attribute12 IN VARCHAR2
55 , p_attribute13 IN VARCHAR2
56 , p_attribute14 IN VARCHAR2
57 , p_attribute15 IN VARCHAR2
58 , p_attribute2 IN VARCHAR2
59 , p_attribute3 IN VARCHAR2
60 , p_attribute4 IN VARCHAR2
61 , p_attribute5 IN VARCHAR2
62 , p_attribute6 IN VARCHAR2
63 , p_attribute7 IN VARCHAR2
64 , p_attribute8 IN VARCHAR2
65 , p_attribute9 IN VARCHAR2
66 , p_context IN VARCHAR2
67 , x_agreement_id OUT NUMBER
68 , x_attribute1 OUT VARCHAR2
69 , x_attribute10 OUT VARCHAR2
70 , x_attribute11 OUT VARCHAR2
71 , x_attribute12 OUT VARCHAR2
72 , x_attribute13 OUT VARCHAR2
73 , x_attribute14 OUT VARCHAR2
74 , x_attribute15 OUT VARCHAR2
75 , x_attribute2 OUT VARCHAR2
76 , x_attribute3 OUT VARCHAR2
77 , x_attribute4 OUT VARCHAR2
78 , x_attribute5 OUT VARCHAR2
79 , x_attribute6 OUT VARCHAR2
80 , x_attribute7 OUT VARCHAR2
81 , x_attribute8 OUT VARCHAR2
82 , x_attribute9 OUT VARCHAR2
83 , x_context OUT VARCHAR2
84 , x_discount_id OUT NUMBER
85 , x_last_updated_by OUT NUMBER
86 , x_price_list_id OUT NUMBER
87 , x_pricing_contract_id OUT NUMBER
88 , x_agreement OUT VARCHAR2
89 , x_discount OUT VARCHAR2
90 , x_price_list OUT VARCHAR2
91 );
92
93 -- Procedure Validate_And_Write
94 --
95
96 PROCEDURE Validate_And_Write
97 ( x_return_status OUT VARCHAR2
98 , x_msg_count OUT NUMBER
99 , x_msg_data OUT VARCHAR2
100 , p_pricing_contract_id IN NUMBER
101 , x_creation_date OUT DATE
102 , x_created_by OUT NUMBER
103 , x_last_update_date OUT DATE
104 , x_last_updated_by OUT NUMBER
105 , x_last_update_login OUT NUMBER
106 );
107
108 -- Procedure Delete_Row
109 --
110
111 PROCEDURE Delete_Row
112 ( x_return_status OUT VARCHAR2
113 , x_msg_count OUT NUMBER
114 , x_msg_data OUT VARCHAR2
115 , p_pricing_contract_id IN NUMBER
116 );
117
118 -- Procedure Process_Entity
119 --
120
121 PROCEDURE Process_Entity
122 ( x_return_status OUT VARCHAR2
123 , x_msg_count OUT NUMBER
124 , x_msg_data OUT VARCHAR2
125 );
126
127 -- Procedure Process_Object
128 --
129
130 PROCEDURE Process_Object
131 ( x_return_status OUT VARCHAR2
132 , x_msg_count OUT NUMBER
133 , x_msg_data OUT VARCHAR2
134 );
135
136 -- Procedure lock_Row
137 --
138
139 PROCEDURE Lock_Row
140 ( x_return_status OUT VARCHAR2
141 , x_msg_count OUT NUMBER
142 , x_msg_data OUT VARCHAR2
143 , p_agreement_id IN NUMBER
144 , p_attribute1 IN VARCHAR2
145 , p_attribute10 IN VARCHAR2
146 , p_attribute11 IN VARCHAR2
147 , p_attribute12 IN VARCHAR2
148 , p_attribute13 IN VARCHAR2
149 , p_attribute14 IN VARCHAR2
150 , p_attribute15 IN VARCHAR2
151 , p_attribute2 IN VARCHAR2
152 , p_attribute3 IN VARCHAR2
153 , p_attribute4 IN VARCHAR2
154 , p_attribute5 IN VARCHAR2
155 , p_attribute6 IN VARCHAR2
156 , p_attribute7 IN VARCHAR2
157 , p_attribute8 IN VARCHAR2
158 , p_attribute9 IN VARCHAR2
159 , p_context IN VARCHAR2
160 , p_created_by IN NUMBER
161 , p_creation_date IN DATE
162 , p_discount_id IN NUMBER
163 , p_last_updated_by IN NUMBER
164 , p_last_update_date IN DATE
165 , p_last_update_login IN NUMBER
166 , p_price_list_id IN NUMBER
167 , p_pricing_contract_id IN NUMBER
168 );
169
170 PROCEDURE Create_Revision
171 ( l_Agreement_Id IN NUMBER
172 );
173
174 END OE_OE_Form_Contract;