[Home] [Help]
98: tfr.attribute13,
99: tfr.attribute14,
100: tfr.attribute15,
101: tfr.attribute_category_code
102: from fa_mass_external_transfers tfr,
103: fa_book_controls bc
104: where tfr.book_type_code = p_book_type_code
105: and tfr.book_type_code = bc.book_type_code
106: and tfr.batch_name = p_batch_name
536:
537: -- Update status
538: begin
539: forall i in 1..l_mass_external_transfer_id.count
540: update fa_mass_external_transfers
541: set transaction_status = l_transaction_status(i)
542: where mass_external_transfer_id = l_mass_external_transfer_id(i);
543: end;
544:
584:
585: -- Update status
586: begin
587: forall i in 1..l_counter
588: update fa_mass_external_transfers
589: set transaction_status = l_transaction_status(i)
590: where mass_external_transfer_id = l_mass_external_transfer_id(i);
591: end;
592:
620: bks1.group_asset_id, -- from_group_asset_id
621: bks2.group_asset_id -- to_group_asset_id
622: from fa_books bks1,
623: fa_books bks2,
624: fa_mass_external_transfers tfr
625: where tfr.book_type_code = p_book_type_code
626: and tfr.batch_name = p_batch_name
627: and tfr.transaction_status = 'POST'
628: and tfr.transaction_type in ('INTER', 'ADJUSTMENT')
654: tfr.source_line_id,
655: tfr.from_group_asset_id,
656: tfr.to_group_asset_id,
657: tfr.worker_id
658: from fa_mass_external_transfers tfr
659: where tfr.book_type_code = p_book_type_code
660: and tfr.batch_name = p_batch_name
661: and tfr.transaction_status = 'POST'
662: and tfr.transaction_type in ('INTER', 'ADJUSTMENT')
762: exit;
763: end if;
764:
765: forall i in 1..l_mass_ext_transfer_id_tbl.count
766: update fa_mass_external_transfers
767: set from_group_asset_id = l_from_group_asset_id_tbl(i),
768: to_group_asset_id = l_to_group_asset_id_tbl(i)
769: where mass_external_transfer_id = l_mass_ext_transfer_id_tbl(i);
770:
877:
878: else
879: l_worker_id := 1;
880:
881: update fa_mass_external_transfers
882: set worker_id = l_worker_id
883: where mass_external_transfer_id = l_mass_external_transfer_id;
884:
885: l_dep_group_idx := 1;
897:
898: -- Set all records w/ same from_group to this worker
899: for i in l_dep_group_idx..l_dep_group_total loop
900: begin
901: update fa_mass_external_transfers tfr
902: set tfr.worker_id = l_worker_id
903: where tfr.book_type_code = p_book_type_code
904: and tfr.batch_name = p_batch_name
905: and tfr.transaction_status = 'POST'
926:
927: -- Set all records w/ same to_group to this worker
928: for i in l_dep_group_idx..l_dep_group_total loop
929: begin
930: update fa_mass_external_transfers tfr
931: set tfr.worker_id = l_worker_id
932: where tfr.book_type_code = p_book_type_code
933: and tfr.batch_name = p_batch_name
934: and tfr.transaction_status = 'POST'
955:
956: -- Set all records w/ same from_asset to this worker
957: for i in l_dep_asset_idx..l_dep_asset_total loop
958: begin
959: update fa_mass_external_transfers tfr
960: set tfr.worker_id = l_worker_id
961: where tfr.book_type_code = p_book_type_code
962: and tfr.batch_name = p_batch_name
963: and tfr.transaction_status = 'POST'
984:
985: -- Set all records w/ same to_asset to this worker
986: for i in l_dep_asset_idx..l_dep_asset_total loop
987: begin
988: update fa_mass_external_transfers tfr
989: set tfr.worker_id = l_worker_id
990: where tfr.book_type_code = p_book_type_code
991: and tfr.batch_name = p_batch_name
992: and tfr.transaction_status = 'POST'
1242: RETCODE OUT NOCOPY VARCHAR2)
1243: IS
1244: Cursor Assets_C is
1245: select Mass_External_Transfer_ID
1246: from fa_mass_external_transfers
1247: where transaction_status in ('DELETE','POSTED')
1248: for update nowait;
1249: LV_Mass_External_Transfer_ID NUMBER;
1250: BEGIN
1252: Loop
1253: Fetch Assets_C into LV_Mass_External_Transfer_ID;
1254: Exit when Assets_C%NOTFOUND;
1255:
1256: Delete from fa_mass_external_transfers
1257: where mass_external_transfer_id = LV_Mass_External_Transfer_ID;
1258:
1259: End Loop;
1260: Close Assets_C;