APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_PRETTY_URL_PVT

Line 2054: l_pretty_url_rec AMS_PRETTY_URL_PVT.pretty_url_rec_type;

2050: l_attr_available VARCHAR2(30);
2051: l_system_url VARCHAR2(4000); -- dbiswas added 26May05 for 11.5.10.RUP4
2052: l_pretty_url_id NUMBER; -- dbiswas added 30Aug06 for R12 bug 5477945
2053: l_ctd_id NUMBER;
2054: l_pretty_url_rec AMS_PRETTY_URL_PVT.pretty_url_rec_type;
2055: l_ctd_rec AMS_CTD_PVT.ctd_rec_type;
2056:
2057: x_status_code VARCHAR2(30);
2058:

Line 2110: AMS_PRETTY_URL_PVT.CHECK_PU_MANDATORY_FIELDS(

2106: OPEN c_pretty_url(l_pretty_url_id);
2107: FETCH c_pretty_url INTO l_pretty_url_rec;
2108: CLOSE c_pretty_url;
2109: IF (l_pretty_url_rec.pretty_url_id IS NOT NULL) THEN
2110: AMS_PRETTY_URL_PVT.CHECK_PU_MANDATORY_FIELDS(
2111: p_pretty_url_rec => l_pretty_url_rec,
2112: x_return_status => l_return_status);
2113: IF l_return_status <> FND_API.g_ret_sts_success THEN
2114: RAISE FND_API.g_exc_error;

Line 2136: AMS_PRETTY_URL_PVT.IS_SYSTEM_URL_UNIQ(p_sys_url => l_system_url ,

2132: ELSE --CTD Referenced in System url but does not exist. ERROR
2133: RAISE FND_API.g_exc_error;
2134: END IF ;
2135:
2136: AMS_PRETTY_URL_PVT.IS_SYSTEM_URL_UNIQ(p_sys_url => l_system_url ,
2137: p_current_used_by_id => p_schedule_id,
2138: p_current_used_by_type => 'CSCH',
2139: x_return_status => l_return_status);
2140: IF l_return_status <> FND_API.g_ret_sts_success THEN

Line 2236: AMS_PRETTY_URL_PVT.CHECK_PU_MANDATORY_FIELDS(

2232: OPEN c_pretty_url(l_pretty_url_id);
2233: FETCH c_pretty_url INTO l_pretty_url_rec;
2234: CLOSE c_pretty_url;
2235: IF (l_pretty_url_rec.pretty_url_id IS NOT NULL) THEN
2236: AMS_PRETTY_URL_PVT.CHECK_PU_MANDATORY_FIELDS(
2237: p_pretty_url_rec => l_pretty_url_rec,
2238: x_return_status => l_return_status);
2239: IF l_return_status <> FND_API.g_ret_sts_success THEN
2240: RAISE FND_API.g_exc_error;

Line 2262: AMS_PRETTY_URL_PVT.IS_SYSTEM_URL_UNIQ(p_sys_url => l_system_url ,

2258: ELSE --CTD Referenced in System url but does not exist. ERROR
2259: RAISE FND_API.g_exc_error;
2260: END IF ;
2261:
2262: AMS_PRETTY_URL_PVT.IS_SYSTEM_URL_UNIQ(p_sys_url => l_system_url ,
2263: p_current_used_by_id => p_schedule_id,
2264: p_current_used_by_type => 'CSCH',
2265: x_return_status => l_return_status);
2266: IF l_return_status <> FND_API.g_ret_sts_success THEN