[Home] [Help]
PACKAGE BODY: APPS.CSTACCWO
Source
1 PACKAGE BODY CSTACCWO AS
2 /* $Header: CSTACCWB.pls 115.4 2003/10/15 23:31:27 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 x_adjustment_transaction number,
53 x_line_match_order number,
54 x_reason_id number,
55 x_comments varchar2,
56 x_destination_type_code varchar2,
57 x_write_off_code varchar2,
58 x_legal_entity_id number,
59 x_cost_group_id number,
60 x_cost_type_id number,
61 x_period_id number) IS
62
63
64 x_progress VARCHAR2(3) := NULL;
65
66
67 BEGIN
68
69 x_progress := '020';
70
71 INSERT into cst_pac_accrual_write_offs
72 (write_off_id,
73 last_update_date,
74 last_updated_by,
75 creation_date,
76 created_by,
77 last_update_login,
78 write_off_gl_date,
79 transaction_organization_id,
80 item_master_organization_id,
81 accrual_account_id,
82 accrual_code,
83 transaction_date,
84 transaction_source_code,
85 request_id,
86 program_application_id,
87 program_id,
88 program_update_date,
89 period_name,
90 po_transaction_type,
91 invoice_num,
92 receipt_num,
93 po_transaction_id,
94 inv_transaction_id,
95 inv_transaction_type_id,
96 wip_transaction_id,
97 wip_transaction_type_id,
98 inventory_item_id,
99 po_unit_of_measure,
100 primary_unit_of_measure,
101 transaction_quantity,
102 net_po_line_quantity,
103 po_header_id,
104 po_num,
105 po_line_num,
106 po_line_id,
107 po_distribution_id,
108 vendor_id,
109 vendor_name,
110 transaction_unit_price,
111 invoice_id,
112 invoice_line_num,
113 avg_receipt_price,
114 transaction_amount,
115 Adjustment_transaction,
116 line_match_order,
117 reason_id,
118 comments,
119 destination_type_code,
120 write_off_code,
121 legal_entity_id,
122 cost_group_id,
123 cost_type_id,
124 period_id)
125 VALUES
126 (x_write_off_id,
127 x_last_update_date,
128 x_last_updated_by,
129 x_creation_date,
130 x_created_by,
131 x_last_update_login,
132 x_write_off_date,
133 x_transaction_organization_id,
134 x_item_master_organization_id,
135 x_accrual_account_id,
136 x_accrual_code,
137 x_transaction_date,
138 x_transaction_source_code,
139 x_request_id,
140 x_program_application_id,
141 x_program_id,
142 x_program_update_date,
143 x_period_name,
144 x_po_transaction_type,
145 x_invoice_num,
146 x_receipt_num,
147 x_po_transaction_id,
148 x_inv_transaction_id,
149 x_inv_transaction_type_id,
150 x_wip_transaction_id,
151 x_wip_transaction_type_id,
152 x_inventory_item_id,
153 x_po_unit_of_measure,
154 x_primary_unit_of_measure,
155 x_transaction_quantity,
156 x_net_po_line_quantity,
157 x_po_header_id,
158 x_po_num,
159 x_po_line_num,
160 x_po_line_id,
161 x_po_distribution_id,
162 x_vendor_id,
163 x_vendor_name,
164 x_transaction_unit_price,
165 x_invoice_id,
166 x_invoice_line_num,
167 x_avg_receipt_price,
168 x_transaction_amount,
169 x_adjustment_transaction,
170 x_line_match_order,
171 x_reason_id,
172 x_comments,
173 x_destination_type_code,
174 x_write_off_code,
175 x_legal_entity_id,
176 x_cost_group_id,
177 x_cost_type_id,
178 x_period_id);
179
180 exception
181
182 when others then
183 po_message_s.sql_error('Insert_Row', X_progress, sqlcode);
184 raise;
185
186 END Insert_Row;
187
188
189 END CSTACCWO;
190
191