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.FA_MASSADD_CREATE_PKG dependencies on FA_CACHE_PKG

Line 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 */

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')
307: ,asset_type = p_asset_type_tbl(i)
308: ,split_merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_merged_code_tbl(i),NULL) /* ER 14739752 */
309: ,merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_merged_code_tbl(i),NULL)

Line 306: ,queue_name = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_queue_name_tbl(i), 'NEW')

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')
307: ,asset_type = p_asset_type_tbl(i)
308: ,split_merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_merged_code_tbl(i),NULL) /* ER 14739752 */
309: ,merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_merged_code_tbl(i),NULL)
310: ,parent_mass_addition_id = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_mass_add_id_tbl(i),NULL)

Line 308: ,split_merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_merged_code_tbl(i),NULL) /* ER 14739752 */

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')
307: ,asset_type = p_asset_type_tbl(i)
308: ,split_merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_merged_code_tbl(i),NULL) /* ER 14739752 */
309: ,merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_merged_code_tbl(i),NULL)
310: ,parent_mass_addition_id = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_mass_add_id_tbl(i),NULL)
311: ,merge_parent_mass_additions_id = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_mass_add_id_tbl(i),NULL)
312: ,add_to_asset_id = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_asset_id_tbl(i),NULL)

Line 309: ,merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_merged_code_tbl(i),NULL)

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')
307: ,asset_type = p_asset_type_tbl(i)
308: ,split_merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_merged_code_tbl(i),NULL) /* ER 14739752 */
309: ,merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_merged_code_tbl(i),NULL)
310: ,parent_mass_addition_id = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_mass_add_id_tbl(i),NULL)
311: ,merge_parent_mass_additions_id = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_mass_add_id_tbl(i),NULL)
312: ,add_to_asset_id = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_asset_id_tbl(i),NULL)
313: where parent_invoice_dist_id = p_invoice_dist_id_tbl(i)

Line 310: ,parent_mass_addition_id = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_mass_add_id_tbl(i),NULL)

306: ,queue_name = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_queue_name_tbl(i), 'NEW')
307: ,asset_type = p_asset_type_tbl(i)
308: ,split_merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_merged_code_tbl(i),NULL) /* ER 14739752 */
309: ,merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_merged_code_tbl(i),NULL)
310: ,parent_mass_addition_id = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_mass_add_id_tbl(i),NULL)
311: ,merge_parent_mass_additions_id = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_mass_add_id_tbl(i),NULL)
312: ,add_to_asset_id = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_asset_id_tbl(i),NULL)
313: where parent_invoice_dist_id = p_invoice_dist_id_tbl(i)
314: and line_status = 'NEW'

Line 311: ,merge_parent_mass_additions_id = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_mass_add_id_tbl(i),NULL)

307: ,asset_type = p_asset_type_tbl(i)
308: ,split_merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_merged_code_tbl(i),NULL) /* ER 14739752 */
309: ,merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_merged_code_tbl(i),NULL)
310: ,parent_mass_addition_id = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_mass_add_id_tbl(i),NULL)
311: ,merge_parent_mass_additions_id = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_mass_add_id_tbl(i),NULL)
312: ,add_to_asset_id = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_asset_id_tbl(i),NULL)
313: where parent_invoice_dist_id = p_invoice_dist_id_tbl(i)
314: and line_status = 'NEW'
315: and ledger_category_code = 'P'

Line 312: ,add_to_asset_id = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_asset_id_tbl(i),NULL)

308: ,split_merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_merged_code_tbl(i),NULL) /* ER 14739752 */
309: ,merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_merged_code_tbl(i),NULL)
310: ,parent_mass_addition_id = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_mass_add_id_tbl(i),NULL)
311: ,merge_parent_mass_additions_id = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_mass_add_id_tbl(i),NULL)
312: ,add_to_asset_id = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', p_asset_id_tbl(i),NULL)
313: where parent_invoice_dist_id = p_invoice_dist_id_tbl(i)
314: and line_status = 'NEW'
315: and ledger_category_code = 'P'
316: returning invoice_distribution_id

Line 438: if (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N') = 'Y') then /* ER 14739752 */

434: -- proactive set the values for merged children
435: for i in 1..l_invoice_dist_id_tbl.count loop
436: l_asset_id_tbl(l_asset_id_tbl.count + 1) := null;
437: l_line_status_tbl(l_line_status_tbl.count + 1) := 'VALID';
438: if (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N') = 'Y') then /* ER 14739752 */
439: l_posting_status_tbl(l_posting_status_tbl.count + 1) := 'NEW';
440: l_merged_code_tbl(l_merged_code_tbl.count + 1) := null;
441: else
442: l_posting_status_tbl(l_posting_status_tbl.count + 1) := 'MERGED';

Line 452: set split_merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL), /* ER 14739752 */

448:
449: -- flag these updated lines as parent MP where applicable
450: forall i in 1..l_mass_add_id_tbl.count
451: update /*+ index(gt FA_MASS_ADDITIONS_GT_N3) */ fa_mass_additions_gt gt
452: set split_merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL), /* ER 14739752 */
453: merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL)
454: where mass_addition_id = l_mass_add_id_tbl(i)
455: and book_type_code = p_book_type_code
456: and invoice_payment_id is null -- exclude discounts

Line 453: merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL)

449: -- flag these updated lines as parent MP where applicable
450: forall i in 1..l_mass_add_id_tbl.count
451: update /*+ index(gt FA_MASS_ADDITIONS_GT_N3) */ fa_mass_additions_gt gt
452: set split_merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL), /* ER 14739752 */
453: merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL)
454: where mass_addition_id = l_mass_add_id_tbl(i)
455: and book_type_code = p_book_type_code
456: and invoice_payment_id is null -- exclude discounts
457: and ledger_category_code = 'P'

Line 613: nvl(fa_cache_pkg.fazcbc_record.allow_unallocated_lines_flag,'N') = 'Y')

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
613: nvl(fa_cache_pkg.fazcbc_record.allow_unallocated_lines_flag,'N') = 'Y')
614: )
615: and gt.ledger_category_code = 'P'
616: and gt.line_status = 'NEW'
617: and gt.invoice_payment_id is null; -- exclude discounts

Line 691: if (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N') = 'N') then /* ER 14739752 */

687:
688: -- remove any child lines in NEW status whose only matching parents are in the delete queue
689: -- per discussion with AP Dev/PM this is correct (just as if te parent was excluded in
690: -- the post accounting setups)
691: if (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N') = 'N') then /* ER 14739752 */
692: open c_rejected;
693:
694: loop
695: fetch c_rejected bulk collect

Line 872: if (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N') = 'Y') then /* ER 14739752 */

868:
869: if (l_invoice_dist_id_tbl.count > 0) then
870: for i in 1..l_invoice_dist_id_tbl.count loop
871: l_asset_id_tbl(i) := null;
872: if (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N') = 'Y') then /* ER 14739752 */
873: l_posting_status_tbl(i) := 'NEW';
874: l_merged_code_tbl(i) := null;
875: else
876: l_posting_status_tbl(i) := 'MERGED';

Line 900: set split_merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL), /* ER 14739752 */

896: /*10209969 - Need to update inside loop as l_mass_add_id_tbl is fetched in each iteration */
897: -- flag the parent as MP
898: forall i in 1..l_mass_add_id_tbl.count
899: update fa_mass_additions_gt gt
900: set split_merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL), /* ER 14739752 */
901: merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL)
902: where mass_addition_id = l_mass_add_id_tbl(i)
903: and book_type_code = p_book_type_code
904: and invoice_payment_id is null

Line 901: merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL)

897: -- flag the parent as MP
898: forall i in 1..l_mass_add_id_tbl.count
899: update fa_mass_additions_gt gt
900: set split_merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL), /* ER 14739752 */
901: merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL)
902: where mass_addition_id = l_mass_add_id_tbl(i)
903: and book_type_code = p_book_type_code
904: and invoice_payment_id is null
905: and ledger_category_code = 'P'

Line 990: if (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N') = 'Y') then /* ER 14739752 */

986: l_child_inv_dist_id1_tbl(l_child_inv_dist_id1_tbl.count + 1) := l_invoice_dist_id_tbl(i);
987: l_child_mass_add_id1_tbl(l_child_mass_add_id1_tbl.count + 1) := l_mass_add_id_tbl(i);
988: l_child_asset_id1_tbl(l_child_asset_id1_tbl.count + 1) := NULL;
989: l_child_line_status1_tbl(l_child_line_status1_tbl.count + 1) := 'VALID';
990: if (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N') = 'Y') then /* ER 14739752 */
991: l_child_posting_status1_tbl(l_child_posting_status1_tbl.count + 1) := 'NEW';
992: l_child_merged_code1_tbl(l_child_merged_code1_tbl.count + 1) := null;
993: else
994: l_child_posting_status1_tbl(l_child_posting_status1_tbl.count + 1) := 'MERGED';

Line 1028: set split_merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL), /* ER 14739752 */

1024: -- flag the parent as MP
1025: -- no need for existance check as we're already driving by child
1026: forall i in 1..l_child_mass_add_id1_tbl.count
1027: update fa_mass_additions
1028: set split_merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL), /* ER 14739752 */
1029: merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL)
1030: where mass_addition_id = l_child_mass_add_id1_tbl(i)
1031: and book_type_code = p_book_type_code;
1032:

Line 1029: merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL)

1025: -- no need for existance check as we're already driving by child
1026: forall i in 1..l_child_mass_add_id1_tbl.count
1027: update fa_mass_additions
1028: set split_merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL), /* ER 14739752 */
1029: merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL)
1030: where mass_addition_id = l_child_mass_add_id1_tbl(i)
1031: and book_type_code = p_book_type_code;
1032:
1033: -- process singles

Line 1156: posting_status = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'ON HOLD','NEW'), /* ER 14739752 */

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'),
1158: asset_type = l_child_asset_type1_tbl(i), --decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', l_child_asset_type1_tbl(i),asset_type),
1159: split_merged_code = NULL,
1160: merged_code = NULL,

Line 1157: queue_name = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'ON HOLD','NEW'),

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'),
1158: asset_type = l_child_asset_type1_tbl(i), --decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', l_child_asset_type1_tbl(i),asset_type),
1159: split_merged_code = NULL,
1160: merged_code = NULL,
1161: parent_mass_addition_id = NULL,

Line 1158: asset_type = l_child_asset_type1_tbl(i), --decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', l_child_asset_type1_tbl(i),asset_type),

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'),
1158: asset_type = l_child_asset_type1_tbl(i), --decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', l_child_asset_type1_tbl(i),asset_type),
1159: split_merged_code = NULL,
1160: merged_code = NULL,
1161: parent_mass_addition_id = NULL,
1162: merge_parent_mass_additions_id = NULL,

Line 1163: add_to_asset_id = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', l_child_asset_id1_tbl(i),NULL)

1159: split_merged_code = NULL,
1160: merged_code = NULL,
1161: parent_mass_addition_id = NULL,
1162: merge_parent_mass_additions_id = NULL,
1163: add_to_asset_id = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', l_child_asset_id1_tbl(i),NULL)
1164: where parent_invoice_dist_id = l_child_inv_dist_id1_tbl(i)
1165: and line_status = 'NEW'
1166: and ledger_category_code = 'P'
1167: and book_type_code = p_book_type_code

Line 1181: if (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N') = 'Y') then /* ER 14739752 */

1177: , l_child_asset_type1A_tbl;
1178:
1179: for i in 1..l_child_mass_add_id1_tbl.count loop
1180: l_child_line_status1_tbl(l_child_line_status1_tbl.count + 1) := 'VALID';
1181: if (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N') = 'Y') then /* ER 14739752 */
1182: l_child_posting_status1_tbl(l_child_posting_status1_tbl.count + 1) := 'NEW';
1183: l_child_merged_code1_tbl(l_child_merged_code1_tbl.count + 1) := null;
1184: else
1185: l_child_posting_status1_tbl(l_child_posting_status1_tbl.count + 1) := 'MERGED';

Line 1229: set split_merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL), /* ER 14739752 */

1225:
1226: -- flag these updated lines as parent MP where applicable
1227: forall i in 1..l_child_mass_add_id1_tbl.count
1228: update /*+ index(gt FA_MASS_ADDITIONS_GT_N3) */ fa_mass_additions_gt gt
1229: set split_merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL), /* ER 14739752 */
1230: merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL)
1231: where invoice_distribution_id = l_child_inv_dist_id1A_tbl(i)
1232: and invoice_payment_id is null -- exclude discounts
1233: and book_type_code = p_book_type_code

Line 1230: merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL)

1226: -- flag these updated lines as parent MP where applicable
1227: forall i in 1..l_child_mass_add_id1_tbl.count
1228: update /*+ index(gt FA_MASS_ADDITIONS_GT_N3) */ fa_mass_additions_gt gt
1229: set split_merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL), /* ER 14739752 */
1230: merged_code = decode (nvl(fa_cache_pkg.fazcbc_record.IMPORT_ALLOC_INV_LINES_AS_NEW,'N'), 'N', 'MP',NULL)
1231: where invoice_distribution_id = l_child_inv_dist_id1A_tbl(i)
1232: and invoice_payment_id is null -- exclude discounts
1233: and book_type_code = p_book_type_code
1234: and ledger_category_code = 'P'

Line 1396: ,'fa_cache_pkg.fazcbc'

1392: , p_book_type_code
1393: ,p_log_level_rec => g_log_level_rec);
1394: fa_debug_pkg.add(l_calling_fn
1395: ,'calling'
1396: ,'fa_cache_pkg.fazcbc'
1397: ,p_log_level_rec => g_log_level_rec);
1398: end if;
1399:
1400: if NOT fa_cache_pkg.fazcbc(X_book => p_book_type_code,

Line 1400: if NOT fa_cache_pkg.fazcbc(X_book => p_book_type_code,

1396: ,'fa_cache_pkg.fazcbc'
1397: ,p_log_level_rec => g_log_level_rec);
1398: end if;
1399:
1400: if NOT fa_cache_pkg.fazcbc(X_book => p_book_type_code,
1401: p_log_level_rec => g_log_level_rec) then
1402: raise create_err;
1403: end if;
1404:

Line 1408: ,'fa_cache_pkg.fazcdp'

1404:
1405: if (g_log_level_rec.statement_level) then
1406: fa_debug_pkg.add(l_calling_fn
1407: ,'calling'
1408: ,'fa_cache_pkg.fazcdp'
1409: ,p_log_level_rec => g_log_level_rec);
1410: end if;
1411:
1412: if not fa_cache_pkg.fazcdp (x_book_type_code => p_book_type_code ) THEN

Line 1412: if not fa_cache_pkg.fazcdp (x_book_type_code => p_book_type_code ) THEN

1408: ,'fa_cache_pkg.fazcdp'
1409: ,p_log_level_rec => g_log_level_rec);
1410: end if;
1411:
1412: if not fa_cache_pkg.fazcdp (x_book_type_code => p_book_type_code ) THEN
1413: raise create_err;
1414: end if;
1415:
1416: l_ledger_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

Line 1416: l_ledger_id := fa_cache_pkg.fazcbc_record.set_of_books_id;

1412: if not fa_cache_pkg.fazcdp (x_book_type_code => p_book_type_code ) THEN
1413: raise create_err;
1414: end if;
1415:
1416: l_ledger_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
1417: l_date_ineffective := fa_cache_pkg.fazcbc_record.date_ineffective;
1418: l_book_class := fa_cache_pkg.fazcbc_record.book_class;
1419: l_coa_id := fa_cache_pkg.fazcbc_record.accounting_flex_structure;
1420:

Line 1417: l_date_ineffective := fa_cache_pkg.fazcbc_record.date_ineffective;

1413: raise create_err;
1414: end if;
1415:
1416: l_ledger_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
1417: l_date_ineffective := fa_cache_pkg.fazcbc_record.date_ineffective;
1418: l_book_class := fa_cache_pkg.fazcbc_record.book_class;
1419: l_coa_id := fa_cache_pkg.fazcbc_record.accounting_flex_structure;
1420:
1421: l_calendar_period_close_date :=

Line 1418: l_book_class := fa_cache_pkg.fazcbc_record.book_class;

1414: end if;
1415:
1416: l_ledger_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
1417: l_date_ineffective := fa_cache_pkg.fazcbc_record.date_ineffective;
1418: l_book_class := fa_cache_pkg.fazcbc_record.book_class;
1419: l_coa_id := fa_cache_pkg.fazcbc_record.accounting_flex_structure;
1420:
1421: l_calendar_period_close_date :=
1422: fa_cache_pkg.fazcdp_record.calendar_period_close_date ;

Line 1419: l_coa_id := fa_cache_pkg.fazcbc_record.accounting_flex_structure;

1415:
1416: l_ledger_id := fa_cache_pkg.fazcbc_record.set_of_books_id;
1417: l_date_ineffective := fa_cache_pkg.fazcbc_record.date_ineffective;
1418: l_book_class := fa_cache_pkg.fazcbc_record.book_class;
1419: l_coa_id := fa_cache_pkg.fazcbc_record.accounting_flex_structure;
1420:
1421: l_calendar_period_close_date :=
1422: fa_cache_pkg.fazcdp_record.calendar_period_close_date ;
1423:

Line 1422: fa_cache_pkg.fazcdp_record.calendar_period_close_date ;

1418: l_book_class := fa_cache_pkg.fazcbc_record.book_class;
1419: l_coa_id := fa_cache_pkg.fazcbc_record.accounting_flex_structure;
1420:
1421: l_calendar_period_close_date :=
1422: fa_cache_pkg.fazcdp_record.calendar_period_close_date ;
1423:
1424: IF l_date_ineffective IS NOT NULL THEN
1425: if (g_log_level_rec.statement_level) then
1426: fa_debug_pkg.add(l_calling_fn

Line 1489: greatest(nvl(fa_cache_pkg.fazcdp_record.calendar_period_open_date,

1485: ,p_log_level_rec => g_log_level_rec);
1486: end if;
1487:
1488: l_def_dpis_dt :=
1489: greatest(nvl(fa_cache_pkg.fazcdp_record.calendar_period_open_date,
1490: sysdate),
1491: least(sysdate,
1492: nvl(fa_cache_pkg.fazcdp_record.calendar_period_close_date, sysdate)));
1493:

Line 1492: nvl(fa_cache_pkg.fazcdp_record.calendar_period_close_date, sysdate)));

1488: l_def_dpis_dt :=
1489: greatest(nvl(fa_cache_pkg.fazcdp_record.calendar_period_open_date,
1490: sysdate),
1491: least(sysdate,
1492: nvl(fa_cache_pkg.fazcdp_record.calendar_period_close_date, sysdate)));
1493:
1494: END IF;
1495:
1496:

Line 1518: if not fa_cache_pkg.fazcdp (x_book_type_code => p_book_type_code ) THEN

1514: END IF;
1515:
1516:
1517: -- Call the cache pkg to fetch the calendar_period_close_date
1518: if not fa_cache_pkg.fazcdp (x_book_type_code => p_book_type_code ) THEN
1519: if (g_log_level_rec.statement_level) then
1520: fa_debug_pkg.add(l_calling_fn
1521: ,'Unable to find valid depreciation information '
1522: ,p_book_type_code