APPS.AMS_CUSTOM_SETUP_PURPOSE_PKG dependencies on AMS_CUSTOM_SETUP_PURPOSE

Line 1: PACKAGE BODY AMS_Custom_Setup_Purpose_PKG as

1: PACKAGE BODY AMS_Custom_Setup_Purpose_PKG as
2: /* $Header: amslcspb.pls 115.3 2004/04/08 22:51:45 asaha noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_Custom_Setup_Purpose_PKG

2: /* $Header: amslcspb.pls 115.3 2004/04/08 22:51:45 asaha noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_Custom_Setup_Purpose_PKG
7: -- Purpose
8: --
9: -- History
10: --

Line 13: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Custom_Setup_Purpose_PKG';

9: -- History
10: --
11: -- NOTE
12:
13: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Custom_Setup_Purpose_PKG';
14: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amslcspb.pls';
15:
16: -- ========================================================
17: --

Line 47: INSERT INTO ams_custom_setup_purpose(

43:
44: BEGIN
45: px_object_version_number := nvl(px_object_version_number, 1);
46:
47: INSERT INTO ams_custom_setup_purpose(
48: setup_purpose_id,
49: custom_setup_id,
50: last_update_date,
51: last_updated_by,

Line 99: Update ams_custom_setup_purpose

95: p_object_version_number IN NUMBER)
96:
97: IS
98: BEGIN
99: Update ams_custom_setup_purpose
100: SET
101: setup_purpose_id = DECODE( p_setup_purpose_id, null, setup_purpose_id, FND_API.G_MISS_NUM, null, p_setup_purpose_id),
102: custom_setup_id = DECODE( p_custom_setup_id, null, custom_setup_id, FND_API.G_MISS_NUM, null, p_custom_setup_id),
103: last_update_date = DECODE( p_last_update_date, null, last_update_date, FND_API.G_MISS_DATE, null, p_last_update_date),

Line 138: DELETE FROM ams_custom_setup_purpose

134: p_setup_purpose_id NUMBER,
135: p_object_version_number NUMBER)
136: IS
137: BEGIN
138: DELETE FROM ams_custom_setup_purpose
139: WHERE setup_purpose_id = p_setup_purpose_id
140: AND object_version_number = p_object_version_number;
141: If (SQL%NOTFOUND) then
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 164: FROM ams_custom_setup_purpose

160: p_object_version_number NUMBER)
161: IS
162: CURSOR C IS
163: SELECT *
164: FROM ams_custom_setup_purpose
165: WHERE setup_purpose_id = p_setup_purpose_id
166: AND object_version_number = p_object_version_number
167: FOR UPDATE OF setup_purpose_id NOWAIT;
168: Recinfo C%ROWTYPE;

Line 219: from ams_custom_setup_purpose

215: l_db_luby_id NUMBER;
216:
217: cursor c_db_data_details is
218: select last_updated_by, nvl(object_version_number,1)
219: from ams_custom_setup_purpose
220: where setup_purpose_id = p_setup_purpose_id;
221:
222: cursor c_chk_csp_exists is
223: select 1

Line 224: from ams_custom_setup_purpose

220: where setup_purpose_id = p_setup_purpose_id;
221:
222: cursor c_chk_csp_exists is
223: select 1
224: from ams_custom_setup_purpose
225: where setup_purpose_id = p_setup_purpose_id;
226:
227: cursor c_get_cspid is
228: select ams_custom_setup_purpose_s.nextval

Line 228: select ams_custom_setup_purpose_s.nextval

224: from ams_custom_setup_purpose
225: where setup_purpose_id = p_setup_purpose_id;
226:
227: cursor c_get_cspid is
228: select ams_custom_setup_purpose_s.nextval
229: from dual;
230:
231: BEGIN
232:

Line 297: END AMS_Custom_Setup_Purpose_PKG;

293: end if;
294: end LOAD_ROW;
295:
296:
297: END AMS_Custom_Setup_Purpose_PKG;