APPS.CSC_PROF_GROUP_CHECKS_PKG dependencies on CSC_PROF_GROUP_CHECKS

Line 1: PACKAGE BODY CSC_PROF_GROUP_CHECKS_PKG as

1: PACKAGE BODY CSC_PROF_GROUP_CHECKS_PKG as
2: /* $Header: csctpgcb.pls 120.1 2005/08/03 22:58:08 mmadhavi noship $ */
3: -- Start of Comments
4: -- Package name : CSC_PROF_GROUP_CHECKS_PKG
5: -- Purpose :

Line 4: -- Package name : CSC_PROF_GROUP_CHECKS_PKG

1: PACKAGE BODY CSC_PROF_GROUP_CHECKS_PKG as
2: /* $Header: csctpgcb.pls 120.1 2005/08/03 22:58:08 mmadhavi noship $ */
3: -- Start of Comments
4: -- Package name : CSC_PROF_GROUP_CHECKS_PKG
5: -- Purpose :
6: -- History :
7: -- 07 Nov 02 jamose Upgrade table handler changes
8: -- 27 Nov 02 jamose For Fnd_Api_G_Miss* and NOCOPY changes

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

9: -- NOTE :
10: -- End of Comments
11:
12:
13: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_PROF_GROUP_CHECKS_PKG';
14: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csctugcb.pls';
15:
16: G_MISS_CHAR VARCHAR2(1) := FND_API.G_MISS_CHAR;
17: G_MISS_NUM NUMBER := FND_API.G_MISS_NUM;

Line 39: FROM CSC_PROF_GROUP_CHECKS

35: p_LAST_UPDATE_LOGIN NUMBER)
36:
37: IS
38: CURSOR C2 IS SELECT MAX(nvl(check_sequence,0)) + 1
39: FROM CSC_PROF_GROUP_CHECKS
40: WHERE check_id = p_CHECK_ID;
41: l_check_Sequence Number;
42: ps_SEEDED_FLAG Varchar2(3);
43:

Line 58: INSERT INTO CSC_PROF_GROUP_CHECKS(

54: -- OPEN C2;
55: -- FETCH C2 INTO px_check_sequence;
56: -- CLOSE C2;
57: -- End If;
58: INSERT INTO CSC_PROF_GROUP_CHECKS(
59: GROUP_ID,
60: CHECK_ID,
61: CHECK_SEQUENCE,
62: END_DATE_ACTIVE,

Line 109: Update CSC_PROF_GROUP_CHECKS

105: p_LAST_UPDATE_LOGIN NUMBER)
106:
107: IS
108: BEGIN
109: Update CSC_PROF_GROUP_CHECKS
110: SET
111: CHECK_SEQUENCE = p_CHECK_SEQUENCE,
112: END_DATE_ACTIVE = p_END_DATE_ACTIVE,
113: START_DATE_ACTIVE = p_START_DATE_ACTIVE,

Line 151: FROM CSC_PROF_GROUP_CHECKS

147:
148: IS
149: CURSOR C IS
150: SELECT *
151: FROM CSC_PROF_GROUP_CHECKS
152: WHERE GROUP_ID = p_GROUP_ID
153: AND CHECK_ID = P_CHECK_ID
154: FOR UPDATE of GROUP_ID NOWAIT;
155: Recinfo C%ROWTYPE;

Line 224: DELETE FROM CSC_PROF_GROUP_CHECKS

220: p_CHECK_ID NUMBER,
221: p_CHECK_SEQUENCE NUMBER)
222: IS
223: BEGIN
224: DELETE FROM CSC_PROF_GROUP_CHECKS
225: WHERE GROUP_ID = p_GROUP_ID
226: AND CHECK_ID = p_CHECK_ID
227: AND CHECK_SEQUENCE = p_CHECK_SEQUENCE;
228:

Line 235: End CSC_PROF_GROUP_CHECKS_PKG;

231: End If;
232: END Delete_Row;
233:
234:
235: End CSC_PROF_GROUP_CHECKS_PKG;