APPS.HZ_CERTIFICATIONS_PKG dependencies on HZ_CERTIFICATIONS

Line 1: PACKAGE BODY HZ_CERTIFICATIONS_PKG as

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

Line 27: CURSOR C IS SELECT rowid FROM HZ_CERTIFICATIONS

23: x_PROGRAM_UPDATE_DATE DATE,
24: x_WH_UPDATE_DATE DATE,
25: x_STATUS VARCHAR2
26: ) IS
27: CURSOR C IS SELECT rowid FROM HZ_CERTIFICATIONS
28: WHERE CERTIFICATION_ID = x_CERTIFICATION_ID;
29: BEGIN
30: INSERT INTO HZ_CERTIFICATIONS(
31: CERTIFICATION_ID,

Line 30: INSERT INTO HZ_CERTIFICATIONS(

26: ) IS
27: CURSOR C IS SELECT rowid FROM HZ_CERTIFICATIONS
28: WHERE CERTIFICATION_ID = x_CERTIFICATION_ID;
29: BEGIN
30: INSERT INTO HZ_CERTIFICATIONS(
31: CERTIFICATION_ID,
32: CERTIFICATION_NAME,
33: CURRENT_STATUS,
34: PARTY_ID,

Line 83: DELETE FROM HZ_CERTIFICATIONS

79:
80: PROCEDURE Delete_Row( x_CERTIFICATION_ID NUMBER
81: ) IS
82: BEGIN
83: DELETE FROM HZ_CERTIFICATIONS
84: WHERE CERTIFICATION_ID = x_CERTIFICATION_ID;
85: If (SQL%NOTFOUND) then
86: RAISE NO_DATA_FOUND;
87: End If;

Line 115: Update HZ_CERTIFICATIONS

111: x_WH_UPDATE_DATE DATE,
112: x_STATUS VARCHAR2
113: ) IS
114: BEGIN
115: Update HZ_CERTIFICATIONS
116: SET
117: CERTIFICATION_ID = decode( x_CERTIFICATION_ID, FND_API.G_MISS_NUM,CERTIFICATION_ID,x_CERTIFICATION_ID),
118: CERTIFICATION_NAME = decode( x_CERTIFICATION_NAME, FND_API.G_MISS_CHAR,CERTIFICATION_NAME,x_CERTIFICATION_NAME),
119: CURRENT_STATUS = decode( x_CURRENT_STATUS, FND_API.G_MISS_CHAR,CURRENT_STATUS,x_CURRENT_STATUS),

Line 173: FROM HZ_CERTIFICATIONS

169: x_STATUS VARCHAR2
170: ) IS
171: CURSOR C IS
172: SELECT *
173: FROM HZ_CERTIFICATIONS
174: WHERE rowid = x_Rowid
175: FOR UPDATE of CERTIFICATION_ID NOWAIT;
176: Recinfo C%ROWTYPE;
177: BEGIN

Line 254: END HZ_CERTIFICATIONS_PKG;

250: APP_EXCEPTION.RAISE_EXCEPTION;
251: End If;
252: END Lock_Row;
253:
254: END HZ_CERTIFICATIONS_PKG;