APPS.AMS_CTD_PVT dependencies on AMS_CTDS

Line 162: -- delete from AMS_CTDS

158: 'AFTER_CURSOR_FETCH_C_GET_NOT_ASSOCIATED_CTD',
159: 'Number of CTDs to be deleted = '||to_char(l_not_associated_ctd_list.count)
160: );
161:
162: -- delete from AMS_CTDS
163: FORALL i in l_not_associated_ctd_list.FIRST .. l_not_associated_ctd_list.LAST
164: DELETE FROM AMS_CTDS
165: WHERE CTD_ID = l_not_associated_ctd_list(i);
166:

Line 164: DELETE FROM AMS_CTDS

160: );
161:
162: -- delete from AMS_CTDS
163: FORALL i in l_not_associated_ctd_list.FIRST .. l_not_associated_ctd_list.LAST
164: DELETE FROM AMS_CTDS
165: WHERE CTD_ID = l_not_associated_ctd_list(i);
166:
167: write_debug_message(FND_LOG.LEVEL_EVENT,
168: PROCEDURE_NAME,

Line 446: SELECT AMS_CTDS_s.NEXTVAL

442: l_CTD_ID NUMBER;
443: l_dummy NUMBER;
444:
445: CURSOR c_id IS
446: SELECT AMS_CTDS_s.NEXTVAL
447: FROM dual;
448:
449: CURSOR c_id_exists (l_id IN NUMBER) IS
450: SELECT 1

Line 451: FROM AMS_CTDS

447: FROM dual;
448:
449: CURSOR c_id_exists (l_id IN NUMBER) IS
450: SELECT 1
451: FROM AMS_CTDS
452: WHERE CTD_ID = l_id;
453:
454: BEGIN
455: -- Standard Start of API savepoint

Line 530: -- Invoke table handler(AMS_CTDS_PKG.Insert_Row)

526:
527: -- Debug Message
528: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
529:
530: -- Invoke table handler(AMS_CTDS_PKG.Insert_Row)
531: AMS_CTDS_PKG.Insert_Row(
532: px_ctd_id => l_ctd_id,
533: p_action_id => p_ctd_rec.action_id,
534: p_forward_url => p_ctd_rec.forward_url,

Line 531: AMS_CTDS_PKG.Insert_Row(

527: -- Debug Message
528: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
529:
530: -- Invoke table handler(AMS_CTDS_PKG.Insert_Row)
531: AMS_CTDS_PKG.Insert_Row(
532: px_ctd_id => l_ctd_id,
533: p_action_id => p_ctd_rec.action_id,
534: p_forward_url => p_ctd_rec.forward_url,
535: p_track_url => p_ctd_rec.track_url,

Line 629: FROM AMS_CTDS;

625:
626: IS
627: CURSOR c_get_ctd(ctd_id NUMBER) IS
628: SELECT *
629: FROM AMS_CTDS;
630: -- Hint: Developer need to provide Where clause
631: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Ctd';
632: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
633: -- Local Variables

Line 724: -- Invoke table handler(AMS_CTDS_PKG.Update_Row)

720:
721: -- Debug Message
722: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
723:
724: -- Invoke table handler(AMS_CTDS_PKG.Update_Row)
725: AMS_CTDS_PKG.Update_Row(
726: p_ctd_id => p_ctd_rec.ctd_id,
727: p_action_id => p_ctd_rec.action_id,
728: p_forward_url => p_ctd_rec.forward_url,

Line 725: AMS_CTDS_PKG.Update_Row(

721: -- Debug Message
722: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
723:
724: -- Invoke table handler(AMS_CTDS_PKG.Update_Row)
725: AMS_CTDS_PKG.Update_Row(
726: p_ctd_id => p_ctd_rec.ctd_id,
727: p_action_id => p_ctd_rec.action_id,
728: p_forward_url => p_ctd_rec.forward_url,
729: p_track_url => p_ctd_rec.track_url,

Line 849: -- Invoke table handler(AMS_CTDS_PKG.Delete_Row)

845: --
846: -- Debug Message
847: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
848:
849: -- Invoke table handler(AMS_CTDS_PKG.Delete_Row)
850: AMS_CTDS_PKG.Delete_Row(
851: p_CTD_ID => p_CTD_ID);
852: --
853: -- End of API body

Line 850: AMS_CTDS_PKG.Delete_Row(

846: -- Debug Message
847: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
848:
849: -- Invoke table handler(AMS_CTDS_PKG.Delete_Row)
850: AMS_CTDS_PKG.Delete_Row(
851: p_CTD_ID => p_CTD_ID);
852: --
853: -- End of API body
854: --

Line 935: FROM AMS_CTDS

931: l_CTD_ID NUMBER;
932:
933: CURSOR c_Ctd IS
934: SELECT CTD_ID
935: FROM AMS_CTDS
936: WHERE CTD_ID = p_CTD_ID
937: AND object_version_number = p_object_version
938: FOR UPDATE NOWAIT;
939:

Line 1042: 'AMS_CTDS',

1038: BEGIN
1039: x_return_status := FND_API.g_ret_sts_success;
1040: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1041: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1042: 'AMS_CTDS',
1043: 'CTD_ID = ''' || p_ctd_rec.CTD_ID ||''''
1044: );
1045: ELSE
1046: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 1047: 'AMS_CTDS',

1043: 'CTD_ID = ''' || p_ctd_rec.CTD_ID ||''''
1044: );
1045: ELSE
1046: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
1047: 'AMS_CTDS',
1048: 'CTD_ID = ''' || p_ctd_rec.CTD_ID ||
1049: ''' AND CTD_ID <> ' || p_ctd_rec.CTD_ID
1050: );
1051: END IF;

Line 1253: FROM ams_ctds

1249: l_return_status VARCHAR2(1);
1250:
1251: CURSOR c_complete IS
1252: SELECT *
1253: FROM ams_ctds
1254: WHERE ctd_id = p_ctd_rec.ctd_id;
1255: l_ctd_rec c_complete%ROWTYPE;
1256: BEGIN
1257: x_complete_rec := p_ctd_rec;