APPS.FA_MASSPTFR_PKG dependencies on FA_MASS_EXTERNAL_TRANSFERS

Line 88: from fa_mass_external_transfers tfr,

84: tfr.attribute13,
85: tfr.attribute14,
86: tfr.attribute15,
87: tfr.attribute_category_code
88: from fa_mass_external_transfers tfr,
89: fa_book_controls bc
90: where tfr.book_type_code = p_book_type_code
91: and tfr.book_type_code = bc.book_type_code
92: and tfr.batch_name = p_batch_name

Line 479: update fa_mass_external_transfers

475:
476: -- Update status
477: begin
478: forall i in 1..l_mass_external_transfer_id.count
479: update fa_mass_external_transfers
480: set transaction_status = l_transaction_status(i)
481: where mass_external_transfer_id = l_mass_external_transfer_id(i);
482: end;
483:

Line 533: update fa_mass_external_transfers

529:
530: -- Update status
531: begin
532: forall i in 1..l_counter
533: update fa_mass_external_transfers
534: set transaction_status = l_transaction_status(i)
535: where mass_external_transfer_id = l_mass_external_transfer_id(i);
536: end;
537:

Line 580: from fa_mass_external_transfers tfr

576: tfr.to_gl_ccid,
577: tfr.to_employee_id,
578: tfr.source_line_id,
579: tfr.worker_id
580: from fa_mass_external_transfers tfr
581: where tfr.book_type_code = p_book_type_code
582: and tfr.batch_name = p_batch_name
583: and tfr.transaction_status = 'POST'
584: and tfr.transaction_type in ('INTRA', 'TRANSFER')

Line 691: update fa_mass_external_transfers

687: end loop;
688:
689: -- Update table
690: forall i IN 1..l_mass_external_transfer_id.count
691: update fa_mass_external_transfers
692: set worker_id = l_worker_id(i)
693: where mass_external_transfer_id = l_mass_external_transfer_id(i);
694:
695: FND_CONCURRENT.AF_COMMIT;