APPS.AMS_PRTY_URL_ASSOC_PVT dependencies on AMS_PRETTY_URL_ASSOC

Line 48: SELECT AMS_PRETTY_URL_ASSOC_s.NEXTVAL

44: l_ASSOC_ID NUMBER;
45: l_dummy NUMBER;
46:
47: CURSOR c_id IS
48: SELECT AMS_PRETTY_URL_ASSOC_s.NEXTVAL
49: FROM dual;
50:
51: CURSOR c_id_exists (l_id IN NUMBER) IS
52: SELECT 1

Line 53: FROM AMS_PRETTY_URL_ASSOC

49: FROM dual;
50:
51: CURSOR c_id_exists (l_id IN NUMBER) IS
52: SELECT 1
53: FROM AMS_PRETTY_URL_ASSOC
54: WHERE ASSOC_ID = l_id;
55:
56: BEGIN
57: -- Standard Start of API savepoint

Line 132: -- Invoke table handler(AMS_PRETTY_URL_ASSOC_PKG.Insert_Row)

128:
129: -- Debug Message
130: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
131:
132: -- Invoke table handler(AMS_PRETTY_URL_ASSOC_PKG.Insert_Row)
133: AMS_PRETTY_URL_ASSOC_PKG.Insert_Row(
134: px_assoc_id => l_assoc_id,
135: p_creation_date => SYSDATE,
136: p_created_by => G_USER_ID,

Line 133: AMS_PRETTY_URL_ASSOC_PKG.Insert_Row(

129: -- Debug Message
130: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
131:
132: -- Invoke table handler(AMS_PRETTY_URL_ASSOC_PKG.Insert_Row)
133: AMS_PRETTY_URL_ASSOC_PKG.Insert_Row(
134: px_assoc_id => l_assoc_id,
135: p_creation_date => SYSDATE,
136: p_created_by => G_USER_ID,
137: p_last_update_date => SYSDATE,

Line 226: FROM AMS_PRETTY_URL_ASSOC;

222:
223: IS
224: CURSOR c_get_prty_url_assoc(assoc_id NUMBER) IS
225: SELECT *
226: FROM AMS_PRETTY_URL_ASSOC;
227: -- Hint: Developer need to provide Where clause
228: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Prty_Url_Assoc';
229: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
230: -- Local Variables

Line 321: -- Invoke table handler(AMS_PRETTY_URL_ASSOC_PKG.Update_Row)

317:
318: -- Debug Message
319: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
320:
321: -- Invoke table handler(AMS_PRETTY_URL_ASSOC_PKG.Update_Row)
322: AMS_PRETTY_URL_ASSOC_PKG.Update_Row(
323: p_assoc_id => p_prty_url_assoc_rec.assoc_id,
324: p_creation_date => SYSDATE,
325: p_created_by => G_USER_ID,

Line 322: AMS_PRETTY_URL_ASSOC_PKG.Update_Row(

318: -- Debug Message
319: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
320:
321: -- Invoke table handler(AMS_PRETTY_URL_ASSOC_PKG.Update_Row)
322: AMS_PRETTY_URL_ASSOC_PKG.Update_Row(
323: p_assoc_id => p_prty_url_assoc_rec.assoc_id,
324: p_creation_date => SYSDATE,
325: p_created_by => G_USER_ID,
326: p_last_update_date => SYSDATE,

Line 443: -- Invoke table handler(AMS_PRETTY_URL_ASSOC_PKG.Delete_Row)

439: --
440: -- Debug Message
441: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
442:
443: -- Invoke table handler(AMS_PRETTY_URL_ASSOC_PKG.Delete_Row)
444: AMS_PRETTY_URL_ASSOC_PKG.Delete_Row(
445: p_ASSOC_ID => p_ASSOC_ID);
446: --
447: -- End of API body

Line 444: AMS_PRETTY_URL_ASSOC_PKG.Delete_Row(

440: -- Debug Message
441: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
442:
443: -- Invoke table handler(AMS_PRETTY_URL_ASSOC_PKG.Delete_Row)
444: AMS_PRETTY_URL_ASSOC_PKG.Delete_Row(
445: p_ASSOC_ID => p_ASSOC_ID);
446: --
447: -- End of API body
448: --

Line 529: FROM AMS_PRETTY_URL_ASSOC

525: l_ASSOC_ID NUMBER;
526:
527: CURSOR c_Prty_Url_Assoc IS
528: SELECT ASSOC_ID
529: FROM AMS_PRETTY_URL_ASSOC
530: WHERE ASSOC_ID = p_ASSOC_ID
531: AND object_version_number = p_object_version
532: FOR UPDATE NOWAIT;
533:

Line 636: 'AMS_PRETTY_URL_ASSOC',

632: BEGIN
633: x_return_status := FND_API.g_ret_sts_success;
634: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
635: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
636: 'AMS_PRETTY_URL_ASSOC',
637: 'ASSOC_ID = ''' || p_prty_url_assoc_rec.ASSOC_ID ||''''
638: );
639: ELSE
640: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 641: 'AMS_PRETTY_URL_ASSOC',

637: 'ASSOC_ID = ''' || p_prty_url_assoc_rec.ASSOC_ID ||''''
638: );
639: ELSE
640: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
641: 'AMS_PRETTY_URL_ASSOC',
642: 'ASSOC_ID = ''' || p_prty_url_assoc_rec.ASSOC_ID ||
643: ''' AND ASSOC_ID <> ' || p_prty_url_assoc_rec.ASSOC_ID
644: );
645: END IF;

Line 860: FROM ams_pretty_url_assoc

856: l_return_status VARCHAR2(1);
857:
858: CURSOR c_complete IS
859: SELECT *
860: FROM ams_pretty_url_assoc
861: WHERE assoc_id = p_prty_url_assoc_rec.assoc_id;
862: l_prty_url_assoc_rec c_complete%ROWTYPE;
863: BEGIN
864: x_complete_rec := p_prty_url_assoc_rec;