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.2 2005/09/18 23:28:20 vshastry 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.2 2005/09/18 23:28:20 vshastry 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 14: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSC_PROF_GROUP_CHECKS_PKG';

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

Line 40: FROM CSC_PROF_GROUP_CHECKS

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

Line 64: INSERT INTO CSC_PROF_GROUP_CHECKS(

60: -- OPEN C2;
61: -- FETCH C2 INTO px_check_sequence;
62: -- CLOSE C2;
63: -- End If;
64: INSERT INTO CSC_PROF_GROUP_CHECKS(
65: GROUP_ID,
66: CHECK_ID,
67: CHECK_SEQUENCE,
68: END_DATE_ACTIVE,

Line 115: Update CSC_PROF_GROUP_CHECKS

111: p_LAST_UPDATE_LOGIN NUMBER)
112:
113: IS
114: BEGIN
115: Update CSC_PROF_GROUP_CHECKS
116: SET
117: CHECK_SEQUENCE = p_CHECK_SEQUENCE,
118: END_DATE_ACTIVE = p_END_DATE_ACTIVE,
119: START_DATE_ACTIVE = p_START_DATE_ACTIVE,

Line 157: FROM CSC_PROF_GROUP_CHECKS

153:
154: IS
155: CURSOR C IS
156: SELECT *
157: FROM CSC_PROF_GROUP_CHECKS
158: WHERE GROUP_ID = p_GROUP_ID
159: AND CHECK_ID = P_CHECK_ID
160: FOR UPDATE of GROUP_ID NOWAIT;
161: Recinfo C%ROWTYPE;

Line 230: DELETE FROM CSC_PROF_GROUP_CHECKS

226: p_CHECK_ID NUMBER,
227: p_CHECK_SEQUENCE NUMBER)
228: IS
229: BEGIN
230: DELETE FROM CSC_PROF_GROUP_CHECKS
231: WHERE GROUP_ID = p_GROUP_ID
232: AND CHECK_ID = p_CHECK_ID
233: AND CHECK_SEQUENCE = p_CHECK_SEQUENCE;
234:

Line 241: End CSC_PROF_GROUP_CHECKS_PKG;

237: End If;
238: END Delete_Row;
239:
240:
241: End CSC_PROF_GROUP_CHECKS_PKG;