eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_FA_ASSETS_PKG dependencies on FA_MASS_ADDITIONS

Line 19: A column invoice_line_number ie added to jai_fa_mass_additions.

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

Line 32: forward porting ja_in_fa_mass_additions_p.sql; version 115.3.6107.2 to R12

28: Forward porting the change in 11i bug 5365523 (Additional CVD Enhancement).
29: This bug has datamodel and spec changes.
30:
31: 16/04/2007 Kunkumar for bug no 5989740 for
32: forward porting ja_in_fa_mass_additions_p.sql; version 115.3.6107.2 to R12
33: -------------------------------------------------------------------------------------------
34: */
35:
36: procedure mass_additions

Line 44: cursor c_ja_in_fa_mass_additions(p_parent_request_id number) is

40: p_parent_request_id in number
41: )
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'

Line 46: from JAI_FA_MASS_ADDITIONS a

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:

Line 119: select fa_mass_additions_s.nextval

115: from JAI_CMN_TAXES_ALL
116: where tax_id = p_tax_id;
117:
118: cursor c_get_fa_mass_addition_id is
119: select fa_mass_additions_s.nextval
120: from dual;
121:
122: r_ap_invoice_lines_all c_ap_invoice_lines_all%rowtype;
123: r_rcv_transactions c_rcv_transactions%rowtype;

Line 140: lv_feeder_system_name fa_mass_additions.feeder_system_name%TYPE ;--rchandan for bug#4428980

136: lv_error_message varchar2(150);
137:
138: lv_object_name CONSTANT VARCHAR2(61) := 'jai_fa_ast_pkg.mass_additions';
139: lv_new CONSTANT varchar2(30) := 'NEW'; --rchandan for bug#4428980
140: lv_feeder_system_name fa_mass_additions.feeder_system_name%TYPE ;--rchandan for bug#4428980
141: lv_exchange_rate ap_invoices_all.exchange_rate%type; --rchandan for ap lines
142: ln_distribution_amount number;
143:
144:

Line 161: Records are populated onto the table JAI_FA_MASS_ADDITIONS by

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'

Line 162: the trigger ja_in_fa_mass_additions_boe3p after insert

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'
166: is hardcoded.

Line 163: on fa_mass_additions.

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'
166: is hardcoded.
167:

Line 214: for cur_rec_invoice_line in c_ja_in_fa_mass_additions(p_parent_request_id) loop

210:
211: Fnd_File.put_line(Fnd_File.LOG,
212: 'Process Details for mass addition id / Invoice number / Distribution Line No / No of tax lines inserted :');
213:
214: for cur_rec_invoice_line in c_ja_in_fa_mass_additions(p_parent_request_id) loop
215:
216:
217: begin
218:

Line 278: insert into fa_mass_additions

274: close c_get_fa_mass_addition_id;
275:
276: lv_feeder_system_name := 'ORACLE INDIA PAYABLES'; /*rchandan for bug#4428980*/
277:
278: insert into fa_mass_additions
279: (
280: mass_addition_id,
281: description,
282: book_type_code,

Line 346: update JAI_FA_MASS_ADDITIONS

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;

Line 367: update JAI_FA_MASS_ADDITIONS

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;