[Home] [Help]
15: Modified the object to remove literals from DML statements and CURSORS.
16:
17: 24-Jun-2005 rchandan for bug#4454657, Version 116.4
18: Modified the object as a part of AP LINES Impact Uptake
19: A column invoice_line_number ie added to jai_fa_mass_additions.
20: The ap_invoice_lines_all is used instead of ap_invoice_distributions_all while querying wherever applicable.
21: While calculating the apportion factor the distribution amount is taken instead of line amount.
22:
23: 10 07/12/2005 Hjujjuru for the bug 4866533 File version 120.2
42: is
43:
44: cursor c_ja_in_fa_mass_additions(p_parent_request_id number) is
45: select a.rowid, a.*
46: from JAI_FA_MASS_ADDITIONS a
47: where (p_parent_request_id IS NULL OR create_batch_id = p_parent_request_id)
48: and process_flag <> 'Y'
49: FOR UPDATE OF process_flag;
50:
157: This procedure processes all records that have not already
158: been processed earlier. This is checked by the process_flag
159: value of 'Y' for processed records.
160:
161: Records are populated onto the table JAI_FA_MASS_ADDITIONS by
162: the trigger ja_in_fa_mass_additions_boe3p after insert
163: on fa_mass_additions.
164:
165: In FA all amounts are posted in functional currency and hence 'INR'
342: end loop; /** tax for the given invoice item line from corresponding receipt line **/
343: lv_error_message := 'Processed Successfully on / no of tax lines inserted :'
344: || to_char(sysdate) || ' / ' || to_char(ln_no_of_tax_for_inv_line);/*rchandan for bug#4428980*/
345:
346: update JAI_FA_MASS_ADDITIONS
347: set process_flag = 'Y',
348: process_message = lv_error_message,/*rchandan for bug#4428980*/
349: last_update_date = sysdate
350: where rowid = cur_rec_invoice_line.rowid;
363: when others then
364:
365: lv_error_message := substr(sqlerrm, 1, 150);
366:
367: update JAI_FA_MASS_ADDITIONS
368: set process_flag = 'E',
369: process_message = lv_error_message,
370: last_update_date = sysdate
371: where rowid = cur_rec_invoice_line.rowid;