APPS.FA_MODIFY_DISTRIBUTIONS_PKG dependencies on FA_MASS_EXTERNAL_TRANSFERS

Line 33: FROM fa_mass_external_transfers MET

29: l_transaction_status VARCHAR2(20) := 'ERRORED';
30:
31: CURSOR MET_C IS
32: SELECT MET.rowid row_id, MET.*
33: FROM fa_mass_external_transfers MET
34: WHERE MET.batch_name = 'FA_MODIFY_DISTS'
35: AND MET.transaction_status = 'POST'
36: AND MET.transaction_type in ('UNIT ADJUSTMENT', 'TRANSFER')
37: ORDER BY MET.BOOK_TYPE_CODE,

Line 87: LOOP -- begin for each row in fa_mass_external_transfers

83:
84: OPEN MET_C;
85: l_met_c_open := TRUE;
86:
87: LOOP -- begin for each row in fa_mass_external_transfers
88:
89: FETCH MET_C
90: INTO METInfo;
91:

Line 161: UPDATE fa_mass_external_transfers MET

157: end if;
158:
159: FOR i IN asgn_table.FIRST .. asgn_table.LAST LOOP
160:
161: UPDATE fa_mass_external_transfers MET
162: SET MET.transaction_status = l_transaction_status
163: WHERE MET.rowid = asgn_table(i).row_id
164: AND MET.transaction_status = 'POST';
165:

Line 229: EXIT; -- exit loop for each row in fa_mass_external_transfers

225: end if;
226:
227: if (l_last_fetch = TRUE) then
228:
229: EXIT; -- exit loop for each row in fa_mass_external_transfers
230:
231: end if;
232:
233: END LOOP; -- end for each row in fa_mass_external_transfers

Line 233: END LOOP; -- end for each row in fa_mass_external_transfers

229: EXIT; -- exit loop for each row in fa_mass_external_transfers
230:
231: end if;
232:
233: END LOOP; -- end for each row in fa_mass_external_transfers
234:
235: EXCEPTION
236:
237: when others then

Line 310: UPDATE fa_mass_external_transfers MET

306: BEGIN
307:
308: if (transfer_units = 0) then
309:
310: UPDATE fa_mass_external_transfers MET
311: SET MET.transaction_status = 'IGNORED'
312: WHERE MET.rowid = row_id;
313:
314: return;

Line 550: UPDATE fa_mass_external_transfers MET

546: ((transfer_units > 0) AND ((to_dist_id is NULL) AND
547: ((to_ccid is NULL) OR (to_location_id is NULL))))
548: ) then
549:
550: UPDATE fa_mass_external_transfers MET
551: SET MET.transaction_status = 'ERRORED'
552: WHERE MET.rowid = row_id;
553:
554: end if;

Line 559: UPDATE fa_mass_external_transfers MET

555:
556: EXCEPTION
557:
558: when others then
559: UPDATE fa_mass_external_transfers MET
560: SET MET.transaction_status = 'ERRORED'
561: WHERE MET.rowid = row_id;
562:
563: END insert_dist_table;