DBA Data[Home] [Help]

APPS.PA_RES_MANAGEMENT_AMG_PUB dependencies on PA_LOCATION_UTILS

Line 1266: PA_LOCATION_UTILS.CHECK_LOCATION_EXISTS

1262: ELSE
1263: l_dummy_city := l_req_rec.location_city;
1264: END IF;
1265:
1266: PA_LOCATION_UTILS.CHECK_LOCATION_EXISTS
1267: (
1268: p_country_code => l_dummy_country_code
1269: ,p_city => l_dummy_city
1270: ,p_region => l_dummy_state

Line 1662: PA_LOCATION_UTILS.CHECK_COUNTRY_NAME_OR_CODE

1658: IF l_debug_mode = 'Y' THEN
1659: pa_debug.write(l_module, 'Validating Search Country Code and Name to Code Conversion', l_log_level);
1660: END IF;
1661:
1662: PA_LOCATION_UTILS.CHECK_COUNTRY_NAME_OR_CODE
1663: (p_country_code => l_search_country_code_tmp,
1664: p_country_name => l_req_rec.search_country_name,
1665: p_check_id_flag => PA_STARTUP.G_Check_ID_Flag,
1666: x_country_code => l_req_rec.search_country_code,

Line 3132: PA_LOCATION_UTILS.CHECK_LOCATION_EXISTS

3128: ELSE
3129: l_dummy_city := l_req_rec.location_city;
3130: END IF;
3131:
3132: PA_LOCATION_UTILS.CHECK_LOCATION_EXISTS
3133: (
3134: p_country_code => l_dummy_country_code
3135: ,p_city => l_dummy_city
3136: ,p_region => l_dummy_state

Line 7004: PA_LOCATION_UTILS.CHECK_LOCATION_EXISTS

7000: ELSE
7001: l_dummy_city := l_asgn_rec.location_city;
7002: END IF;
7003:
7004: PA_LOCATION_UTILS.CHECK_LOCATION_EXISTS
7005: (
7006: p_country_code => l_dummy_country_code
7007: ,p_city => l_dummy_city
7008: ,p_region => l_dummy_state

Line 8469: pa_location_utils.Check_Location_Exists

8465: l_asgn_rec.location_city := l_dummy_city ;
8466: -- ==== A ==== Added for 5174316 : End
8467:
8468: -- If any of values ,not passed, DB Values will be taken
8469: pa_location_utils.Check_Location_Exists
8470: (
8471: p_country_code => l_dummy_country_code
8472: ,p_city => l_dummy_city
8473: ,p_region => l_dummy_state