APPS.HZ_INDUSTRIAL_CLASSES_PKG dependencies on HZ_INDUSTRIAL_CLASSES

Line 1: PACKAGE BODY HZ_INDUSTRIAL_CLASSES_PKG as

1: PACKAGE BODY HZ_INDUSTRIAL_CLASSES_PKG as
2: /* $Header: ARHOICTB.pls 120.3 2005/10/30 04:20:54 appldev ship $ */
3:
4:
5: PROCEDURE Insert_Row(

Line 23: CURSOR C IS SELECT rowid FROM HZ_INDUSTRIAL_CLASSES

19: x_PROGRAM_ID NUMBER,
20: x_PROGRAM_UPDATE_DATE DATE,
21: x_WH_UPDATE_DATE DATE
22: ) IS
23: CURSOR C IS SELECT rowid FROM HZ_INDUSTRIAL_CLASSES
24: WHERE INDUSTRIAL_CLASS_ID = x_INDUSTRIAL_CLASS_ID;
25: BEGIN
26: INSERT INTO HZ_INDUSTRIAL_CLASSES(
27: INDUSTRIAL_CLASS_ID,

Line 26: INSERT INTO HZ_INDUSTRIAL_CLASSES(

22: ) IS
23: CURSOR C IS SELECT rowid FROM HZ_INDUSTRIAL_CLASSES
24: WHERE INDUSTRIAL_CLASS_ID = x_INDUSTRIAL_CLASS_ID;
25: BEGIN
26: INSERT INTO HZ_INDUSTRIAL_CLASSES(
27: INDUSTRIAL_CLASS_ID,
28: INDUSTRIAL_CODE_NAME,
29: CODE_PRIMARY_SEGMENT,
30: INDUSTRIAL_CLASS_SOURCE,

Line 71: DELETE FROM HZ_INDUSTRIAL_CLASSES

67:
68: PROCEDURE Delete_Row( x_INDUSTRIAL_CLASS_ID NUMBER
69: ) IS
70: BEGIN
71: DELETE FROM HZ_INDUSTRIAL_CLASSES
72: WHERE INDUSTRIAL_CLASS_ID = x_INDUSTRIAL_CLASS_ID;
73: If (SQL%NOTFOUND) then
74: RAISE NO_DATA_FOUND;
75: End If;

Line 99: Update HZ_INDUSTRIAL_CLASSES

95: x_PROGRAM_UPDATE_DATE DATE,
96: x_WH_UPDATE_DATE DATE
97: ) IS
98: BEGIN
99: Update HZ_INDUSTRIAL_CLASSES
100: SET
101: INDUSTRIAL_CLASS_ID = decode( x_INDUSTRIAL_CLASS_ID, FND_API.G_MISS_NUM,INDUSTRIAL_CLASS_ID,x_INDUSTRIAL_CLASS_ID),
102: INDUSTRIAL_CODE_NAME = decode( x_INDUSTRIAL_CODE_NAME, FND_API.G_MISS_CHAR,INDUSTRIAL_CODE_NAME,x_INDUSTRIAL_CODE_NAME),
103: CODE_PRIMARY_SEGMENT = decode( x_CODE_PRIMARY_SEGMENT, FND_API.G_MISS_CHAR,CODE_PRIMARY_SEGMENT,x_CODE_PRIMARY_SEGMENT),

Line 148: FROM HZ_INDUSTRIAL_CLASSES

144: x_WH_UPDATE_DATE DATE
145: ) IS
146: CURSOR C IS
147: SELECT *
148: FROM HZ_INDUSTRIAL_CLASSES
149: WHERE rowid = x_Rowid
150: FOR UPDATE of INDUSTRIAL_CLASS_ID NOWAIT;
151: Recinfo C%ROWTYPE;
152: BEGIN

Line 215: END HZ_INDUSTRIAL_CLASSES_PKG;

211: APP_EXCEPTION.RAISE_EXCEPTION;
212: End If;
213: END Lock_Row;
214:
215: END HZ_INDUSTRIAL_CLASSES_PKG;