APPS.AP_WEB_CC_UPGRADE_PKG dependencies on AP_CREDIT_CARD_TRXNS_ALL

Line 195: ap_credit_card_trxns_all for those card numbers.

191:
192: /*
193: Procedure : Upgrade_Trxns
194: Purpose : For the cards which were successfully migrated during R12 and PADSS, update
195: ap_credit_card_trxns_all for those card numbers.
196: */
197: PROCEDURE Upgrade_Trxns
198: (x_errbuf OUT NOCOPY VARCHAR2,
199: x_retcode OUT NOCOPY VARCHAR2,

Line 220: l_table_name varchar2(30) := 'AP_CREDIT_CARD_TRXNS_ALL';

216: l_batch_size varchar2(30) := x_batch_size;
217: l_worker_id number := x_worker_id;
218: l_num_workers number := x_num_workers;
219: l_any_rows_to_process boolean;
220: l_table_name varchar2(30) := 'AP_CREDIT_CARD_TRXNS_ALL';
221: l_update_name varchar2(30) := x_script_name || 'UpgTrxn';
222: l_status varchar2(1);
223: l_industry varchar2(1);
224: l_oracle_schema varchar2(30);

Line 254: update /*+ ROWID (aca) */ ap_credit_card_trxns_all aca

250: true);
251:
252: while (l_any_rows_to_process = true) loop
253:
254: update /*+ ROWID (aca) */ ap_credit_card_trxns_all aca
255: set
256: card_number = null
257: , last_update_date = sysdate
258: , last_updated_by = l_user_id