APPS.HZ_INDUSTRIAL_CLASS_APP_PKG dependencies on HZ_INDUSTRIAL_CLASS_APP

Line 1: PACKAGE BODY HZ_INDUSTRIAL_CLASS_APP_PKG as

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

Line 25: CURSOR C IS SELECT rowid FROM HZ_INDUSTRIAL_CLASS_APP

21: x_WH_UPDATE_DATE DATE,
22: x_CONTENT_SOURCE_TYPE VARCHAR2,
23: x_IMPORTANCE_RANKING VARCHAR2
24: ) IS
25: CURSOR C IS SELECT rowid FROM HZ_INDUSTRIAL_CLASS_APP
26: WHERE CODE_APPLIED_ID = x_CODE_APPLIED_ID;
27: BEGIN
28: INSERT INTO HZ_INDUSTRIAL_CLASS_APP(
29: CODE_APPLIED_ID,

Line 28: INSERT INTO HZ_INDUSTRIAL_CLASS_APP(

24: ) IS
25: CURSOR C IS SELECT rowid FROM HZ_INDUSTRIAL_CLASS_APP
26: WHERE CODE_APPLIED_ID = x_CODE_APPLIED_ID;
27: BEGIN
28: INSERT INTO HZ_INDUSTRIAL_CLASS_APP(
29: CODE_APPLIED_ID,
30: BEGIN_DATE,
31: PARTY_ID,
32: END_DATE,

Line 77: DELETE FROM HZ_INDUSTRIAL_CLASS_APP

73:
74: PROCEDURE Delete_Row( x_CODE_APPLIED_ID NUMBER
75: ) IS
76: BEGIN
77: DELETE FROM HZ_INDUSTRIAL_CLASS_APP
78: WHERE CODE_APPLIED_ID = x_CODE_APPLIED_ID;
79: If (SQL%NOTFOUND) then
80: RAISE NO_DATA_FOUND;
81: End If;

Line 107: Update HZ_INDUSTRIAL_CLASS_APP

103: x_CONTENT_SOURCE_TYPE VARCHAR2,
104: x_IMPORTANCE_RANKING VARCHAR2
105: ) IS
106: BEGIN
107: Update HZ_INDUSTRIAL_CLASS_APP
108: SET
109: CODE_APPLIED_ID = decode( x_CODE_APPLIED_ID, FND_API.G_MISS_NUM,CODE_APPLIED_ID,x_CODE_APPLIED_ID),
110: BEGIN_DATE = decode( x_BEGIN_DATE, FND_API.G_MISS_DATE,BEGIN_DATE,x_BEGIN_DATE),
111: PARTY_ID = decode( x_PARTY_ID, FND_API.G_MISS_NUM,PARTY_ID,x_PARTY_ID),

Line 160: FROM HZ_INDUSTRIAL_CLASS_APP

156: x_IMPORTANCE_RANKING VARCHAR2
157: ) IS
158: CURSOR C IS
159: SELECT *
160: FROM HZ_INDUSTRIAL_CLASS_APP
161: WHERE rowid = x_Rowid
162: FOR UPDATE of CODE_APPLIED_ID NOWAIT;
163: Recinfo C%ROWTYPE;
164: BEGIN

Line 235: END HZ_INDUSTRIAL_CLASS_APP_PKG;

231: APP_EXCEPTION.RAISE_EXCEPTION;
232: End If;
233: END Lock_Row;
234:
235: END HZ_INDUSTRIAL_CLASS_APP_PKG;