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 1661: PA_LOCATION_UTILS.CHECK_COUNTRY_NAME_OR_CODE

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

Line 3131: PA_LOCATION_UTILS.CHECK_LOCATION_EXISTS

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

Line 7003: PA_LOCATION_UTILS.CHECK_LOCATION_EXISTS

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

Line 8467: pa_location_utils.Check_Location_Exists

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