APPS.AMS_LIST_CONT_RESTRICTIONS_PKG dependencies on AMS_LIST_CONT_RESTRICTIONS

Line 1: PACKAGE BODY AMS_LIST_CONT_RESTRICTIONS_PKG as

1: PACKAGE BODY AMS_LIST_CONT_RESTRICTIONS_PKG as
2: /* $Header: amstascb.pls 120.0 2005/05/31 21:00:56 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_LIST_CONT_RESTRICTIONS_PKG

2: /* $Header: amstascb.pls 120.0 2005/05/31 21:00:56 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_LIST_CONT_RESTRICTIONS_PKG
7: -- Purpose
8: --
9: -- History
10: --

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_LIST_CONT_RESTRICTIONS_PKG';

13: -- End of Comments
14: -- ===============================================================
15:
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_LIST_CONT_RESTRICTIONS_PKG';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amstascb.pls';
19:
20:
21: ----------------------------------------------------------

Line 66: INSERT INTO AMS_LIST_CONT_RESTRICTIONS(

62:
63: px_object_version_number := 1;
64:
65:
66: INSERT INTO AMS_LIST_CONT_RESTRICTIONS(
67: list_contact_restrictions_id,
68: list_header_id,
69: last_update_date,
70: last_updated_by,

Line 128: Update AMS_LIST_CONT_RESTRICTIONS

124:
125: IS
126: BEGIN
127:
128: Update AMS_LIST_CONT_RESTRICTIONS
129: SET
130: list_contact_restrictions_id = DECODE( p_list_cont_restrictions_id, FND_API.g_miss_num, list_contact_restrictions_id, p_list_cont_restrictions_id),
131: list_header_id = DECODE( p_list_header_id, FND_API.g_miss_num, list_header_id, p_list_header_id),
132: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),

Line 171: DELETE FROM AMS_LIST_CONT_RESTRICTIONS

167: PROCEDURE Delete_Row(
168: p_LIST_CONT_RESTRICTIONs_ID NUMBER)
169: IS
170: BEGIN
171: DELETE FROM AMS_LIST_CONT_RESTRICTIONS
172: WHERE LIST_CONTACT_RESTRICTIONs_ID = p_LIST_CONT_RESTRICTIONs_ID;
173: If (SQL%NOTFOUND) then
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: End If;

Line 213: FROM AMS_LIST_CONT_RESTRICTIONS

209:
210: IS
211: CURSOR C IS
212: SELECT *
213: FROM AMS_LIST_CONT_RESTRICTIONS
214: WHERE LIST_CONTACT_RESTRICTIONs_ID = p_LIST_CONT_RESTRICTIONs_ID
215: FOR UPDATE of LIST_CONTACT_RESTRICTIONs_ID NOWAIT;
216: Recinfo C%ROWTYPE;
217: BEGIN

Line 297: from ams_list_cont_restrictions

293: l_object_version_number NUMBER := p_object_version_number ;
294: l_list_cont_restrictions_id NUMBER := p_list_cont_restrictions_id ;
295: cursor c_chk_col_exists is
296: select 'x'
297: from ams_list_cont_restrictions
298: where list_contact_restrictions_id = p_list_cont_restrictions_id;
299:
300: CURSOR c_obj_verno IS
301: SELECT object_version_number, last_updated_by

Line 302: FROM ams_list_cont_restrictions

298: where list_contact_restrictions_id = p_list_cont_restrictions_id;
299:
300: CURSOR c_obj_verno IS
301: SELECT object_version_number, last_updated_by
302: FROM ams_list_cont_restrictions
303: where list_contact_restrictions_id = p_list_cont_restrictions_id;
304:
305:
306: begin

Line 369: END AMS_LIST_CONT_RESTRICTIONS_PKG;

365: end if;
366: end ;
367:
368:
369: END AMS_LIST_CONT_RESTRICTIONS_PKG;