APPS.FA_INV_XFR_PUB dependencies on DUAL

Line 420: from dual;

416: -- insure we load the trx_ref_idinto dest th row too!!!
417:
418: select fa_trx_references_s.nextval
419: into px_src_trans_rec.trx_reference_id
420: from dual;
421:
422: px_dest_trans_rec.trx_reference_id :=
423: px_src_trans_rec.trx_reference_id;
424:

Line 452: from dual;

448:
449: -- Populate th_id and who_info after calling faxcat
450: select fa_transaction_headers_s.nextval
451: into px_src_trans_rec.transaction_header_id
452: from dual;
453:
454: select fa_transaction_headers_s.nextval
455: into px_dest_trans_rec.transaction_header_id
456: from dual;

Line 456: from dual;

452: from dual;
453:
454: select fa_transaction_headers_s.nextval
455: into px_dest_trans_rec.transaction_header_id
456: from dual;
457:
458: px_src_trans_rec.who_info.creation_date := sysdate;
459: px_src_trans_rec.who_info.last_update_date := sysdate;
460: -- ER 14644811 : End

Line 462: if not FA_XLA_EVENTS_PVT.create_dual_transaction_event

458: px_src_trans_rec.who_info.creation_date := sysdate;
459: px_src_trans_rec.who_info.last_update_date := sysdate;
460: -- ER 14644811 : End
461:
462: if not FA_XLA_EVENTS_PVT.create_dual_transaction_event
463: (p_asset_hdr_rec_src => px_src_asset_hdr_rec,
464: p_asset_hdr_rec_dest => px_dest_asset_hdr_rec,
465: p_asset_type_rec_src => l_src_asset_type_rec,
466: p_asset_type_rec_dest => l_dest_asset_type_rec,

Line 488: if not FA_XLA_EVENTS_PVT.create_dual_transaction_event

484:
485: l_secondary_src_asset_hdr_rec.set_of_books_id := l_secondary_sob_id;
486: l_secondary_dest_asset_hdr_rec.set_of_books_id := l_secondary_sob_id;
487:
488: if not FA_XLA_EVENTS_PVT.create_dual_transaction_event
489: (p_asset_hdr_rec_src => l_secondary_src_asset_hdr_rec,
490: p_asset_hdr_rec_dest => l_secondary_dest_asset_hdr_rec,
491: p_asset_type_rec_src => l_src_asset_type_rec,
492: p_asset_type_rec_dest => l_dest_asset_type_rec,