[Home] [Help]
100: tfr.attribute13,
101: tfr.attribute14,
102: tfr.attribute15,
103: tfr.attribute_category_code
104: from fa_mass_external_transfers tfr,
105: fa_book_controls bc
106: where tfr.book_type_code = p_book_type_code
107: and tfr.book_type_code = bc.book_type_code
108: and tfr.batch_name = p_batch_name
546:
547: -- Update status
548: begin
549: forall i in 1..l_mass_external_transfer_id.count
550: update fa_mass_external_transfers
551: set transaction_status = l_transaction_status(i)
552: where mass_external_transfer_id = l_mass_external_transfer_id(i);
553: end;
554:
596:
597: -- Update status
598: begin
599: forall i in 1..l_counter
600: update fa_mass_external_transfers
601: set transaction_status = l_transaction_status(i)
602: where mass_external_transfer_id = l_mass_external_transfer_id(i);
603: end;
604:
634: bks1.group_asset_id, -- from_group_asset_id
635: bks2.group_asset_id -- to_group_asset_id
636: from fa_books bks1,
637: fa_books bks2,
638: fa_mass_external_transfers tfr
639: where tfr.book_type_code = p_book_type_code
640: and tfr.batch_name = p_batch_name
641: and tfr.transaction_status = 'POST'
642: and tfr.transaction_type in ('INTER', 'ADJUSTMENT'
669: tfr.source_line_id,
670: tfr.from_group_asset_id,
671: tfr.to_group_asset_id,
672: tfr.worker_id
673: from fa_mass_external_transfers tfr
674: where tfr.book_type_code = p_book_type_code
675: and tfr.batch_name = p_batch_name
676: and tfr.transaction_status = 'POST'
677: and tfr.transaction_type in ('INTER', 'ADJUSTMENT'
769: exit;
770: end if;
771:
772: forall i in 1..l_mass_ext_transfer_id_tbl.count
773: update fa_mass_external_transfers
774: set from_group_asset_id = l_from_group_asset_id_tbl(i),
775: to_group_asset_id = l_to_group_asset_id_tbl(i)
776: where mass_external_transfer_id = l_mass_ext_transfer_id_tbl(i);
777:
884:
885: else
886: l_worker_id := 1;
887:
888: update fa_mass_external_transfers
889: set worker_id = l_worker_id
890: where mass_external_transfer_id = l_mass_external_transfer_id;
891:
892: l_dep_group_idx := 1;
904:
905: -- Set all records w/ same from_group to this worker
906: for i in l_dep_group_idx..l_dep_group_total loop
907: begin
908: update fa_mass_external_transfers tfr
909: set tfr.worker_id = l_worker_id
910: where tfr.book_type_code = p_book_type_code
911: and tfr.batch_name = p_batch_name
912: and tfr.transaction_status = 'POST'
935:
936: -- Set all records w/ same to_group to this worker
937: for i in l_dep_group_idx..l_dep_group_total loop
938: begin
939: update fa_mass_external_transfers tfr
940: set tfr.worker_id = l_worker_id
941: where tfr.book_type_code = p_book_type_code
942: and tfr.batch_name = p_batch_name
943: and tfr.transaction_status = 'POST'
966:
967: -- Set all records w/ same from_asset to this worker
968: for i in l_dep_asset_idx..l_dep_asset_total loop
969: begin
970: update fa_mass_external_transfers tfr
971: set tfr.worker_id = l_worker_id
972: where tfr.book_type_code = p_book_type_code
973: and tfr.batch_name = p_batch_name
974: and tfr.transaction_status = 'POST'
997:
998: -- Set all records w/ same to_asset to this worker
999: for i in l_dep_asset_idx..l_dep_asset_total loop
1000: begin
1001: update fa_mass_external_transfers tfr
1002: set tfr.worker_id = l_worker_id
1003: where tfr.book_type_code = p_book_type_code
1004: and tfr.batch_name = p_batch_name
1005: and tfr.transaction_status = 'POST'
1265: RETCODE OUT NOCOPY VARCHAR2)
1266: IS
1267: Cursor Assets_C is
1268: select Mass_External_Transfer_ID
1269: from fa_mass_external_transfers
1270: where transaction_status in ('DELETE','POSTED')
1271: for update nowait;
1272: LV_Mass_External_Transfer_ID NUMBER;
1273: BEGIN
1275: Loop
1276: Fetch Assets_C into LV_Mass_External_Transfer_ID;
1277: Exit when Assets_C%NOTFOUND;
1278:
1279: Delete from fa_mass_external_transfers
1280: where mass_external_transfer_id = LV_Mass_External_Transfer_ID;
1281:
1282: End Loop;
1283: Close Assets_C;