APPS.HZ_CLASS_CODE_RELATIONS_PKG dependencies on HZ_CLASS_CODE_RELATIONS

Line 1: PACKAGE BODY HZ_CLASS_CODE_RELATIONS_PKG AS

1: PACKAGE BODY HZ_CLASS_CODE_RELATIONS_PKG AS
2: /*$Header: ARHCCRTB.pls 115.4 2002/11/21 19:38:06 sponnamb ship $ */
3:
4: PROCEDURE Insert_Row (
5: X_CLASS_CATEGORY IN VARCHAR2,

Line 17: INSERT INTO HZ_CLASS_CODE_RELATIONS (

13: ) IS
14:
15: BEGIN
16:
17: INSERT INTO HZ_CLASS_CODE_RELATIONS (
18: CLASS_CATEGORY,
19: CLASS_CODE,
20: SUB_CLASS_CODE,
21: START_DATE_ACTIVE,

Line 63: UPDATE HZ_CLASS_CODE_RELATIONS SET

59: ) IS
60:
61: BEGIN
62:
63: UPDATE HZ_CLASS_CODE_RELATIONS SET
64: END_DATE_ACTIVE = DECODE( X_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, X_END_DATE_ACTIVE ),
65: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
66: LAST_UPDATE_DATE = HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
67: LAST_UPDATED_BY = HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 100: SELECT * FROM HZ_CLASS_CODE_RELATIONS

96: X_APPLICATION_ID IN NUMBER
97: ) IS
98:
99: CURSOR C IS
100: SELECT * FROM HZ_CLASS_CODE_RELATIONS
101: WHERE ROWID = x_Rowid
102: FOR UPDATE NOWAIT;
103: Recinfo C%ROWTYPE;
104:

Line 193: FROM HZ_CLASS_CODE_RELATIONS

189: X_START_DATE_ACTIVE,
190: X_END_DATE_ACTIVE,
191: X_CREATED_BY_MODULE,
192: X_APPLICATION_ID
193: FROM HZ_CLASS_CODE_RELATIONS
194: WHERE CLASS_CATEGORY = X_CLASS_CATEGORY
195: AND CLASS_CODE = X_CLASS_CODE
196: AND SUB_CLASS_CODE = X_SUB_CLASS_CODE
197: AND START_DATE_ACTIVE = X_START_DATE_ACTIVE;

Line 219: DELETE FROM HZ_CLASS_CODE_RELATIONS

215: ) IS
216:
217: BEGIN
218:
219: DELETE FROM HZ_CLASS_CODE_RELATIONS
220: WHERE CLASS_CATEGORY = X_CLASS_CATEGORY
221: AND CLASS_CODE = X_CLASS_CODE
222: AND SUB_CLASS_CODE = X_SUB_CLASS_CODE
223: AND START_DATE_ACTIVE = X_START_DATE_ACTIVE;

Line 231: END HZ_CLASS_CODE_RELATIONS_PKG;

227: END IF;
228:
229: END Delete_Row;
230:
231: END HZ_CLASS_CODE_RELATIONS_PKG;