APPS.AMS_ACTDELVMETHOD_PVT dependencies on AMS_ACT_DELIVERY_METHODS

Line 48: SELECT ams_act_delivery_methods_s.NEXTVAL

44: l_return_status VARCHAR2(1); -- Return value from procedures
45: l_act_DelvMethod_rec act_DelvMethod_rec_type := p_act_DelvMethod_rec;
46: l_act_delivery_method_id NUMBER;
47: CURSOR C_act_delivery_method_id IS
48: SELECT ams_act_delivery_methods_s.NEXTVAL
49: FROM dual;
50: BEGIN
51: -- Standard Start of API savepoint
52: SAVEPOINT Create_Act_DelvMethod_PVT;

Line 100: INSERT INTO AMS_ACT_DELIVERY_METHODS

96: -- Get ID for activity delivery method from sequence.
97: OPEN c_act_delivery_method_id;
98: FETCH c_act_delivery_method_id INTO l_act_DelvMethod_rec.activity_delivery_method_id;
99: CLOSE c_act_delivery_method_id;
100: INSERT INTO AMS_ACT_DELIVERY_METHODS
101: (activity_delivery_method_id,
102: -- standard who columns
103: last_update_date,
104: last_updated_by,

Line 281: update AMS_ACT_DELIVERY_METHODS

277: END IF;
278: END IF;
279:
280:
281: update AMS_ACT_DELIVERY_METHODS
282: set
283: last_update_date = sysdate
284: ,last_updated_by = FND_GLOBAL.User_Id
285: ,last_update_login = FND_GLOBAL.Conc_Login_Id

Line 414: DELETE FROM AMS_ACT_DELIVERY_METHODS

410: -- API body
411: --
412: -- Perform the database operation
413: -- Delete header data
414: DELETE FROM AMS_ACT_DELIVERY_METHODS
415: WHERE activity_delivery_method_id = l_act_delivery_method_id
416: and object_version_number = p_object_version;
417: IF SQL%NOTFOUND THEN
418: --

Line 502: FROM AMS_ACT_DELIVERY_METHODS

498: l_return_status VARCHAR2(1); -- Return value from procedures
499: l_act_delivery_method_id NUMBER;
500: CURSOR c_act_delivery_method IS
501: SELECT activity_delivery_method_id
502: FROM AMS_ACT_DELIVERY_METHODS
503: WHERE activity_delivery_method_id = p_act_delvmethod_id
504: and object_version_number = p_object_version
505: FOR UPDATE of activity_delivery_method_id NOWAIT;
506: BEGIN

Line 769: 'ams_act_delivery_methods',

765: IF p_validation_mode = JTF_PLSQL_API.g_create
766: AND p_act_DelvMethod_rec.activity_delivery_method_id IS NOT NULL
767: THEN
768: IF AMS_Utility_PVT.check_uniqueness(
769: 'ams_act_delivery_methods',
770: 'activity_delivery_method_id = ' || p_act_DelvMethod_rec.activity_delivery_method_id
771: ) = FND_API.g_false
772: THEN
773: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

Line 928: FROM ams_act_delivery_methods

924: x_act_DelvMethod_rec OUT NOCOPY act_DelvMethod_rec_type
925: ) IS
926: CURSOR c_dlv IS
927: SELECT *
928: FROM ams_act_delivery_methods
929: WHERE activity_delivery_method_id = p_act_DelvMethod_rec.activity_delivery_method_id;
930: l_act_DelvMethod_rec c_dlv%ROWTYPE;
931: BEGIN
932: x_act_DelvMethod_rec := p_act_DelvMethod_rec;