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.

[Home] [Help]

APPS.FA_MASSADD_CREATE_PKG dependencies on FA_MASS_ADDITIONS_S

Line 302: set mass_addition_id = fa_mass_additions_s.nextval

298: G_child_iteration_count := G_child_iteration_count + 1;
299:
300: forall i in 1..p_invoice_dist_id_tbl.count
301: update /*+ index(FA_MASS_ADDITIONS_GT FA_MASS_ADDITIONS_GT_N4) */fa_mass_additions_gt
302: set mass_addition_id = fa_mass_additions_s.nextval
303: ,book_type_code = p_book_type_code
304: ,line_status = p_line_status_tbl(i)
305: ,posting_status = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_posting_status_tbl(i), 'NEW') /* ER 14739752 */
306: ,queue_name = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_queue_name_tbl(i), 'NEW')

Line 408: set mass_addition_id = fa_mass_additions_s.nextval

404: begin
405:
406: forall i in 1..p_invoice_dist_id_tbl.count
407: update /*+ index(FA_MASS_ADDITIONS_GT FA_MASS_ADDITIONS_GT_N4) */ fa_mass_additions_gt
408: set mass_addition_id = fa_mass_additions_s.nextval
409: ,book_type_code = p_book_type_code
410: ,line_status = 'VALID'
411: ,posting_status = 'NEW'
412: ,queue_name = 'NEW'

Line 608: fa_mass_additions_s.nextval

604:
605: -- Bug 13809266 : Allow unallocated lines from AP
606: cursor c_item_accrual is
607: select /*+ index(gt FA_MASS_ADDITIONS_GT_N2) */ rowid,
608: fa_mass_additions_s.nextval
609: from fa_mass_additions_gt gt
610: where (gt.line_type_lookup_code in ('ITEM', 'ACCRUAL') OR
611: (gt.line_type_lookup_code in ('NONREC_TAX','FREIGHT','MISCELLANEOUS') and
612: gt.parent_invoice_dist_id is null and

Line 1153: set mass_addition_id = fa_mass_additions_s.nextval,

1149: -- we need to do one update outside the recursive routine here
1150:
1151: forall i in 1..l_child_inv_dist_id1_tbl.count
1152: update /*+ index(FA_MASS_ADDITIONS_GT FA_MASS_ADDITIONS_GT_N4) */ fa_mass_additions_gt
1153: set mass_addition_id = fa_mass_additions_s.nextval,
1154: --book_type_code = p_book_type_code,
1155: line_status = 'VALID',
1156: posting_status = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'ON HOLD','NEW'), /* ER 14739752 */
1157: queue_name = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'ON HOLD','NEW'),

Line 1640: gt.mass_addition_id , --fa_mass_additions_s.nextval,

1636: invoice_line_number ,
1637: invoice_payment_id ,
1638: warranty_number)
1639: select /*+ index(gt FA_MASS_ADDITIONS_GT_N1) */
1640: gt.mass_addition_id , --fa_mass_additions_s.nextval,
1641: gt.asset_number ,
1642: gt.tag_number ,
1643: gt.description ,
1644: gt.asset_category_id ,