[Home] [Help]
PACKAGE BODY: APPS.ACCRUAL_WRITE_OFF_SV
Source
1 PACKAGE BODY accrual_write_off_sv AS
2 /* $Header: POXACCWB.pls 115.2 2003/10/03 23:29:43 vtkamath ship $*/
3 /*===========================================================================
4
5 PROCEDURE NAME: Insert_Row()
6
7 ===========================================================================*/
8 PROCEDURE Insert_Row(
9 x_write_off_id number,
10 x_last_update_date date,
11 x_last_updated_by number,
12 x_creation_date date,
13 x_created_by number,
14 x_last_update_login number,
15 x_write_off_date date,
16 x_transaction_organization_id number,
17 x_item_master_organization_id number,
18 x_accrual_account_id number,
19 x_accrual_code varchar2,
20 x_transaction_date date,
21 x_transaction_source_code varchar2,
22 x_request_id number,
23 x_program_application_id number,
24 x_program_id number,
25 x_program_update_date date,
26 x_period_name varchar2,
27 x_po_transaction_type varchar2,
28 x_invoice_num varchar2,
29 x_receipt_num varchar2,
30 x_po_transaction_id number,
31 x_inv_transaction_id number,
32 x_inv_transaction_type_id number,
33 x_wip_transaction_id number,
34 x_wip_transaction_type_id number,
35 x_inventory_item_id number,
36 x_po_unit_of_measure varchar2,
37 x_primary_unit_of_measure varchar2,
38 x_transaction_quantity number,
39 x_net_po_line_quantity number,
40 x_po_header_id number,
41 x_po_num varchar2,
42 x_po_line_num number,
43 x_po_line_id number,
44 x_po_distribution_id number,
45 x_vendor_id number,
46 x_vendor_name varchar2,
47 x_transaction_unit_price number,
48 x_invoice_id number,
49 x_invoice_line_num number,
50 x_avg_receipt_price number,
51 x_transaction_amount number,
52 /* changes for the patchset J project and ER 2270648 */
53 x_entered_transaction_amount number,
54 x_currency_code varchar2,
55 x_currency_conversion_type varchar2,
56 x_currency_conversion_rate number,
57 x_currency_conversion_date date,
58 x_adjustment_transaction number,
59 x_line_match_order number,
60 x_reason_id number,
61 x_comments varchar2,
62 x_destination_type_code varchar2,
63 x_write_off_code varchar2) IS
64
65
66 x_progress VARCHAR2(3) := NULL;
67
68
69 BEGIN
70
71 x_progress := '020';
72
73 INSERT into po_accrual_write_offs
74 (write_off_id,
75 last_update_date,
76 last_updated_by,
77 creation_date,
78 created_by,
79 last_update_login,
80 write_off_gl_date,
81 transaction_organization_id,
82 item_master_organization_id,
83 accrual_account_id,
84 accrual_code,
85 transaction_date,
86 transaction_source_code,
87 request_id,
88 program_application_id,
89 program_id,
90 program_update_date,
91 period_name,
92 po_transaction_type,
93 invoice_num,
94 receipt_num,
95 po_transaction_id,
96 inv_transaction_id,
97 inv_transaction_type_id,
98 wip_transaction_id,
99 wip_transaction_type_id,
100 inventory_item_id,
101 po_unit_of_measure,
102 primary_unit_of_measure,
103 transaction_quantity,
104 net_po_line_quantity,
105 po_header_id,
106 po_num,
107 po_line_num,
108 po_line_id,
109 po_distribution_id,
110 vendor_id,
111 vendor_name,
112 transaction_unit_price,
113 invoice_id,
114 invoice_line_num,
115 avg_receipt_price,
116 transaction_amount,
117 entered_transaction_amount,
118 currency_code,
119 currency_conversion_type,
120 currency_conversion_rate,
121 currency_conversion_date,
122 adjustment_transaction,
123 line_match_order,
124 reason_id,
125 comments,
126 destination_type_code,
127 write_off_code)
128 VALUES
129 (x_write_off_id,
130 x_last_update_date,
131 x_last_updated_by,
132 x_creation_date,
133 x_created_by,
134 x_last_update_login,
135 x_write_off_date,
136 x_transaction_organization_id,
137 x_item_master_organization_id,
138 x_accrual_account_id,
139 x_accrual_code,
140 x_transaction_date,
141 x_transaction_source_code,
142 x_request_id,
143 x_program_application_id,
144 x_program_id,
145 x_program_update_date,
146 x_period_name,
147 x_po_transaction_type,
148 x_invoice_num,
149 x_receipt_num,
150 x_po_transaction_id,
151 x_inv_transaction_id,
152 x_inv_transaction_type_id,
153 x_wip_transaction_id,
154 x_wip_transaction_type_id,
155 x_inventory_item_id,
156 x_po_unit_of_measure,
157 x_primary_unit_of_measure,
158 x_transaction_quantity,
159 x_net_po_line_quantity,
160 x_po_header_id,
161 x_po_num,
162 x_po_line_num,
163 x_po_line_id,
164 x_po_distribution_id,
165 x_vendor_id,
166 x_vendor_name,
167 x_transaction_unit_price,
168 x_invoice_id,
169 x_invoice_line_num,
170 x_avg_receipt_price,
171 x_transaction_amount,
172 x_entered_transaction_amount,
173 x_currency_code,
174 x_currency_conversion_type,
175 x_currency_conversion_rate,
176 x_currency_conversion_date,
177 x_adjustment_transaction,
178 x_line_match_order,
179 x_reason_id,
180 x_comments,
181 x_destination_type_code,
182 x_write_off_code);
183
184 exception
185
186 when others then
187 po_message_s.sql_error('Insert_Row', X_progress, sqlcode);
188 raise;
189
190 END Insert_Row;
191
192
193 END accrual_write_off_sv;
194
195