APPS.AMS_SCHEDULERULES_PVT dependencies on AMS_PRETTY_URL

Line 2009: ams_pretty_url_assoc assoc

2005: -- dbiswas added the following cursor on 26-may-2005 for pretty URL uniqueness in 11.5.10.RUP4
2006: CURSOR c_system_url (p_schedule_id IN NUMBER)IS
2007: SELECT system_url, pretty_url_id, ctd_id
2008: FROM ams_system_pretty_url sysUrl,
2009: ams_pretty_url_assoc assoc
2010: WHERE assoc.used_by_obj_type ='CSCH'
2011: AND assoc.used_by_obj_id = p_schedule_id
2012: AND assoc.system_url_id = sysUrl.system_url_id;
2013:

Line 2017: FROM ams_pretty_url

2013:
2014: -- dbiswas added the following 2 cursors on 30 Aug 06 for validating PU and CTD reqd fields
2015: CURSOR c_pretty_url (p_pretty_url_id IN NUMBER)IS
2016: SELECT *
2017: FROM ams_pretty_url
2018: WHERE pretty_url_id = p_pretty_url_id;
2019:
2020: CURSOR c_ctd_items (p_ctd_id IN NUMBER)IS
2021: SELECT ctd_id,

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