[Home] [Help]
PACKAGE: APPS.OZF_RESALE_ADJUSTMENTS_PKG
Source
1 PACKAGE OZF_RESALE_ADJUSTMENTS_PKG AS
2 /* $Header: ozftrsas.pls 120.1 2005/08/19 14:02:11 appldev ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_RESALE_ADJUSTMENTS_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 PROCEDURE Insert_Row(
17 px_resale_adjustment_id IN OUT NOCOPY NUMBER,
18 px_object_version_number IN OUT NOCOPY NUMBER,
19 p_last_update_date DATE,
20 p_last_updated_by NUMBER,
21 p_creation_date DATE,
22 p_request_id NUMBER,
23 p_created_by NUMBER,
24 p_created_from VARCHAR2,
25 p_last_update_login NUMBER,
26 p_program_application_id NUMBER,
27 p_program_update_date DATE,
28 p_program_id NUMBER,
29 p_resale_line_id NUMBER,
30 p_resale_batch_id NUMBER,
31 p_orig_system_agreement_uom varchar2,
32 p_ORIG_SYSTEM_AGREEMENT_name varchar2,
33 p_orig_system_agreement_type VARCHAR2,
34 p_orig_system_agreement_status VARCHAR2,
35 p_orig_system_agreement_curr VARCHAR2,
36 p_orig_system_agreement_price NUMBER,
37 p_orig_system_agreement_quant NUMBER,
38 p_agreement_id NUMBER,
39 p_agreement_type VARCHAR2,
40 p_agreement_name VARCHAR2,
41 p_agreement_price NUMBER,
42 p_agreement_uom_code VARCHAR2,
43 p_corrected_agreement_id NUMBER,
44 p_corrected_agreement_name VARCHAR2,
45 p_credit_code varchar2,
46 p_credit_advice_date DATE,
47 p_allowed_amount NUMBER,
48 p_total_allowed_amount NUMBER,
49 p_accepted_amount NUMBER,
50 p_total_accepted_amount NUMBER,
51 p_claimed_amount NUMBER,
52 p_total_claimed_amount NUMBER,
53 p_calculated_price NUMBER,
54 p_acctd_calculated_price NUMBER,
55 p_calculated_amount NUMBER,
56 p_line_agreement_flag varchar2,
57 p_tolerance_flag VARCHAR2,
58 p_line_tolerance_amount NUMBER,
59 p_operand NUMBER,
60 p_operand_calculation_code VARCHAR2,
61 p_priced_quantity NUMBER,
62 p_priced_uom_code VARCHAR2,
63 p_priced_unit_price NUMBER,
64 p_list_header_id NUMBER,
65 p_list_line_id NUMBER,
66 p_status_code VARCHAR2,
67 px_org_id IN OUT NOCOPY NUMBER);
68
69 PROCEDURE Update_Row(
70 p_resale_adjustment_id NUMBER,
71 p_object_version_number NUMBER,
72 p_last_update_date DATE,
73 p_last_updated_by NUMBER,
74 p_request_id NUMBER,
75 p_created_from VARCHAR2,
76 p_last_update_login NUMBER,
77 p_program_application_id NUMBER,
78 p_program_update_date DATE,
79 p_program_id NUMBER,
80 p_resale_line_id NUMBER,
81 p_resale_batch_id NUMBER,
82 p_orig_system_agreement_uom varchar2,
83 p_ORIG_SYSTEM_AGREEMENT_name varchar2,
84 p_orig_system_agreement_type VARCHAR2,
85 p_orig_system_agreement_status VARCHAR2,
86 p_orig_system_agreement_curr VARCHAR2,
87 p_orig_system_agreement_price NUMBER,
88 p_orig_system_agreement_quant NUMBER,
89 p_agreement_id NUMBER,
90 p_agreement_type VARCHAR2,
91 p_agreement_name VARCHAR2,
92 p_agreement_price NUMBER,
93 p_agreement_uom_code VARCHAR2,
94 p_corrected_agreement_id NUMBER,
95 p_corrected_agreement_name VARCHAR2,
96 p_credit_code varchar2,
97 p_credit_advice_date DATE,
98 p_allowed_amount NUMBER,
99 p_total_allowed_amount NUMBER,
100 p_accepted_amount NUMBER,
101 p_total_accepted_amount NUMBER,
102 p_claimed_amount NUMBER,
103 p_total_claimed_amount NUMBER,
104 p_calculated_price NUMBER,
105 p_acctd_calculated_price NUMBER,
106 p_calculated_amount NUMBER,
107 p_line_agreement_flag varchar2,
108 p_tolerance_flag VARCHAR2,
109 p_line_tolerance_amount NUMBER,
110 p_operand NUMBER,
111 p_operand_calculation_code VARCHAR2,
112 p_priced_quantity NUMBER,
113 p_priced_uom_code VARCHAR2,
114 p_priced_unit_price NUMBER,
115 p_list_header_id NUMBER,
116 p_list_line_id NUMBER,
117 p_status_code VARCHAR2,
118 p_org_id NUMBER);
119
120 PROCEDURE Delete_Row(
121 p_RESALE_ADJUSTMENT_ID NUMBER);
122 PROCEDURE Lock_Row(
123 p_resale_adjustment_id NUMBER,
124 p_object_version_number NUMBER,
125 p_last_update_date DATE,
126 p_last_updated_by NUMBER,
127 p_creation_date DATE,
128 p_request_id NUMBER,
129 p_created_by NUMBER,
130 p_created_from VARCHAR2,
131 p_last_update_login NUMBER,
132 p_program_application_id NUMBER,
133 p_program_update_date DATE,
134 p_program_id NUMBER,
135 p_resale_line_id NUMBER,
136 p_resale_batch_id NUMBER,
137 p_orig_system_agreement_uom varchar2,
138 p_ORIG_SYSTEM_AGREEMENT_name varchar2,
139 p_orig_system_agreement_type VARCHAR2,
140 p_orig_system_agreement_status VARCHAR2,
141 p_orig_system_agreement_curr VARCHAR2,
142 p_orig_system_agreement_price NUMBER,
143 p_orig_system_agreement_quant NUMBER,
144 p_agreement_id NUMBER,
145 p_agreement_type VARCHAR2,
146 p_agreement_name VARCHAR2,
147 p_agreement_price NUMBER,
148 p_agreement_uom_code VARCHAR2,
149 p_corrected_agreement_id NUMBER,
150 p_corrected_agreement_name VARCHAR2,
151 p_credit_code varchar2,
152 p_credit_advice_date DATE,
153 p_allowed_amount NUMBER,
154 p_total_allowed_amount NUMBER,
155 p_accepted_amount NUMBER,
156 p_total_accepted_amount NUMBER,
157 p_claimed_amount NUMBER,
158 p_total_claimed_amount NUMBER,
159 p_calculated_price NUMBER,
160 p_acctd_calculated_price NUMBER,
161 p_calculated_amount NUMBER,
162 p_line_agreement_flag varchar2,
163 p_tolerance_flag VARCHAR2,
164 p_line_tolerance_amount NUMBER,
165 p_operand NUMBER,
166 p_operand_calculation_code VARCHAR2,
167 p_priced_quantity NUMBER,
168 p_priced_uom_code VARCHAR2,
169 p_priced_unit_price NUMBER,
170 p_list_header_id NUMBER,
171 p_list_line_id NUMBER,
172 p_status_code VARCHAR2,
173 p_org_id NUMBER);
174
175 END OZF_RESALE_ADJUSTMENTS_PKG;