APPS.CSC_PLAN_ENABLE_SETUP_PKG dependencies on CSC_PLAN_ENABLE_SETUP

Line 1: PACKAGE BODY CSC_PLAN_ENABLE_SETUP_PKG as

1: PACKAGE BODY CSC_PLAN_ENABLE_SETUP_PKG as
2: /* $Header: cscteplb.pls 120.0 2005/05/30 15:52:34 appldev noship $ */
3: -- Start of Comments
4: -- Package name : CSC_PLAN_ENABLE_SETUP_PKG
5: -- Purpose : Table handler package to perform inserts, update, deletes and lock

Line 4: -- Package name : CSC_PLAN_ENABLE_SETUP_PKG

1: PACKAGE BODY CSC_PLAN_ENABLE_SETUP_PKG as
2: /* $Header: cscteplb.pls 120.0 2005/05/30 15:52:34 appldev noship $ */
3: -- Start of Comments
4: -- Package name : CSC_PLAN_ENABLE_SETUP_PKG
5: -- Purpose : Table handler package to perform inserts, update, deletes and lock
6: -- row operations on CSC_PLAN_ENABLE_SETUP table.
7: -- History :
8: -- MM-DD-YYYY NAME MODIFICATIONS

Line 6: -- row operations on CSC_PLAN_ENABLE_SETUP table.

2: /* $Header: cscteplb.pls 120.0 2005/05/30 15:52:34 appldev noship $ */
3: -- Start of Comments
4: -- Package name : CSC_PLAN_ENABLE_SETUP_PKG
5: -- Purpose : Table handler package to perform inserts, update, deletes and lock
6: -- row operations on CSC_PLAN_ENABLE_SETUP table.
7: -- History :
8: -- MM-DD-YYYY NAME MODIFICATIONS
9: -- 01-13-2000 dejoseph Created.
10: -- 01-31-2000 dejoseph 'Arcs'ed in for fourth code freeze. (07-FEB-2000)

Line 22: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSC_PLAN_ENABLE_SETUP_PKG';

18: -- NOTE :
19: -- End of Comments
20:
21:
22: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSC_PLAN_ENABLE_SETUP_PKG';
23: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cscteplb.pls';
24:
25: PROCEDURE Insert_Row(
26: P_FUNCTION_ID IN NUMBER,

Line 58: SELECT CSC_PLAN_ENABLE_SETUP_S.nextval

54: X_ENABLE_SETUP_ID OUT NOCOPY NUMBER,
55: X_OBJECT_VERSION_NUMBER OUT NOCOPY NUMBER)
56: IS
57: CURSOR C1 IS
58: SELECT CSC_PLAN_ENABLE_SETUP_S.nextval
59: FROM sys.dual;
60:
61: l_enable_setup_id NUMBER;
62:

Line 73: INSERT INTO CSC_PLAN_ENABLE_SETUP(

69: OPEN C1;
70: FETCH C1 INTO L_ENABLE_SETUP_ID;
71: CLOSE C1;
72:
73: INSERT INTO CSC_PLAN_ENABLE_SETUP(
74: ENABLE_SETUP_ID, FUNCTION_ID, START_DATE_ACTIVE,
75: END_DATE_ACTIVE, ON_INSERT_ENABLE_FLAG, ON_UPDATE_ENABLE_FLAG,
76: CUSTOM1_ENABLE_FLAG, CUSTOM2_ENABLE_FLAG, CREATION_DATE,
77: LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY,

Line 149: UPDATE csc_plan_enable_setup

145: L_MSG_COUNT NUMBER;
146: L_MSG_DATA VARCHAR2(2000);
147: L_RETURN_STATUS VARCHAR2(1);
148: BEGIN
149: UPDATE csc_plan_enable_setup
150: SET
151: FUNCTION_ID = NVL( p_function_id, FUNCTION_ID),
152: START_DATE_ACTIVE = NVL( p_start_date_active, START_DATE_ACTIVE),
153: END_DATE_ACTIVE = p_end_date_active,

Line 209: DELETE FROM CSC_PLAN_ENABLE_SETUP

205: L_MSG_COUNT NUMBER;
206: L_MSG_DATA VARCHAR2(2000);
207: L_RETURN_STATUS VARCHAR2(1);
208: BEGIN
209: DELETE FROM CSC_PLAN_ENABLE_SETUP
210: WHERE ENABLE_SETUP_ID = p_enable_setup_id
211: AND OBJECT_VERSION_NUMBER = p_object_version_number;
212:
213: If (SQL%NOTFOUND) then

Line 238: FROM CSC_PLAN_ENABLE_SETUP

234: P_OBJECT_VERSION_NUMBER IN NUMBER)
235: IS
236: CURSOR C1 IS
237: SELECT *
238: FROM CSC_PLAN_ENABLE_SETUP
239: WHERE ENABLE_SETUP_ID = p_enable_setup_id
240: AND OBJECT_VERSION_NUMBER = p_object_version_number
241: FOR UPDATE NOWAIT;
242:

Line 273: End CSC_PLAN_ENABLE_SETUP_PKG;

269: APP_EXCEPTION.RAISE_EXCEPTION;
270:
271: END Lock_Row;
272:
273: End CSC_PLAN_ENABLE_SETUP_PKG;