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 *

Line 2042: l_pretty_url_rec AMS_PRETTY_URL_PVT.pretty_url_rec_type;

2038: l_attr_available VARCHAR2(30);
2039: l_system_url VARCHAR2(4000); -- dbiswas added 26May05 for 11.5.10.RUP4
2040: l_pretty_url_id NUMBER; -- dbiswas added 30Aug06 for R12 bug 5477945
2041: l_ctd_id NUMBER;
2042: l_pretty_url_rec AMS_PRETTY_URL_PVT.pretty_url_rec_type;
2043: l_ctd_rec AMS_CTD_PVT.ctd_rec_type;
2044:
2045: x_status_code VARCHAR2(30);
2046:

Line 2098: AMS_PRETTY_URL_PVT.CHECK_PU_MANDATORY_FIELDS(

2094: OPEN c_pretty_url(l_pretty_url_id);
2095: FETCH c_pretty_url INTO l_pretty_url_rec;
2096: CLOSE c_pretty_url;
2097: IF (l_pretty_url_rec.pretty_url_id IS NOT NULL) THEN
2098: AMS_PRETTY_URL_PVT.CHECK_PU_MANDATORY_FIELDS(
2099: p_pretty_url_rec => l_pretty_url_rec,
2100: x_return_status => l_return_status);
2101: IF l_return_status <> FND_API.g_ret_sts_success THEN
2102: RAISE FND_API.g_exc_error;

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

2120: ELSE --CTD Referenced in System url but does not exist. ERROR
2121: RAISE FND_API.g_exc_error;
2122: END IF ;
2123:
2124: AMS_PRETTY_URL_PVT.IS_SYSTEM_URL_UNIQ(p_sys_url => l_system_url ,
2125: p_current_used_by_id => p_schedule_id,
2126: p_current_used_by_type => 'CSCH',
2127: x_return_status => l_return_status);
2128: IF l_return_status <> FND_API.g_ret_sts_success THEN

Line 2224: AMS_PRETTY_URL_PVT.CHECK_PU_MANDATORY_FIELDS(

2220: OPEN c_pretty_url(l_pretty_url_id);
2221: FETCH c_pretty_url INTO l_pretty_url_rec;
2222: CLOSE c_pretty_url;
2223: IF (l_pretty_url_rec.pretty_url_id IS NOT NULL) THEN
2224: AMS_PRETTY_URL_PVT.CHECK_PU_MANDATORY_FIELDS(
2225: p_pretty_url_rec => l_pretty_url_rec,
2226: x_return_status => l_return_status);
2227: IF l_return_status <> FND_API.g_ret_sts_success THEN
2228: RAISE FND_API.g_exc_error;

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

2246: ELSE --CTD Referenced in System url but does not exist. ERROR
2247: RAISE FND_API.g_exc_error;
2248: END IF ;
2249:
2250: AMS_PRETTY_URL_PVT.IS_SYSTEM_URL_UNIQ(p_sys_url => l_system_url ,
2251: p_current_used_by_id => p_schedule_id,
2252: p_current_used_by_type => 'CSCH',
2253: x_return_status => l_return_status);
2254: IF l_return_status <> FND_API.g_ret_sts_success THEN