APPS.AP_WEB_CC_VALIDATIONS_PKG dependencies on AP_WEB_LOCATIONS_PKG

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

183: --
184: -- If a null merchant country was passed in,
185: -- default it based on various information of the card program.
186: l_count := execute_update('update ap_credit_card_trxns_all cc '||
187: 'set merchant_country = nvl(merchant_country, ap_web_locations_pkg.default_country(card_program_id)) '||
188: 'where merchant_country is null ', p_valid_only);
189:
190: --
191: -- Default merchant country code

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

333: fetch l_loc_cur into l_cc_trx;
334: exit when l_loc_cur%notfound;
335:
336: num_rows := num_rows + 1;
337: ap_web_locations_pkg.get_location(l_cc_trx, l_return_status, l_msg_count, l_msg_data);
338:
339: update ap_credit_card_trxns_all set location_id = l_cc_trx.location_id
340: where trx_id = l_cc_trx.trx_id;
341: end loop;