APPS.AP_WEB_CC_VALIDATIONS_PKG dependencies on AP_WEB_LOCATIONS_PKG

Line 197: 'set merchant_country = nvl(merchant_country, ap_web_locations_pkg.default_country(card_program_id)) '||

193: --
194: -- If a null merchant country was passed in,
195: -- default it based on various information of the card program.
196: l_count := execute_update('update ap_credit_card_trxns_all cc '||
197: 'set merchant_country = nvl(merchant_country, ap_web_locations_pkg.default_country(card_program_id)) '||
198: 'where merchant_country is null ', p_valid_only);
199:
200: --
201: -- Default merchant country code

Line 353: ap_web_locations_pkg.get_location(l_cc_trx, l_return_status, l_msg_count, l_msg_data);

349: fetch l_loc_cur into l_cc_trx;
350: exit when l_loc_cur%notfound;
351:
352: num_rows := num_rows + 1;
353: ap_web_locations_pkg.get_location(l_cc_trx, l_return_status, l_msg_count, l_msg_data);
354:
355: update ap_credit_card_trxns_all set location_id = l_cc_trx.location_id
356: where trx_id = l_cc_trx.trx_id;
357: end loop;