APPS.FA_MASSPTFR_PKG dependencies on FA_MASS_EXTERNAL_TRANSFERS

Line 89: from fa_mass_external_transfers tfr,

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

Line 482: update fa_mass_external_transfers

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

Line 530: update fa_mass_external_transfers

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

Line 578: from fa_mass_external_transfers tfr

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

Line 680: update fa_mass_external_transfers

676: end loop;
677:
678: -- Update table
679: forall i IN 1..l_mass_external_transfer_id.count
680: update fa_mass_external_transfers
681: set worker_id = l_worker_id(i)
682: where mass_external_transfer_id = l_mass_external_transfer_id(i);
683:
684: FND_CONCURRENT.AF_COMMIT;