APPS.HZ_SECURITY_ISSUED_PKG dependencies on HZ_SECURITY_ISSUED

Line 1: PACKAGE BODY HZ_SECURITY_ISSUED_PKG as

1: PACKAGE BODY HZ_SECURITY_ISSUED_PKG as
2: /* $Header: ARHOSITB.pls 120.3 2005/10/30 04:21:12 appldev ship $ */
3:
4:
5: PROCEDURE Insert_Row(

Line 30: CURSOR C IS SELECT rowid FROM HZ_SECURITY_ISSUED

26: x_PROGRAM_UPDATE_DATE DATE,
27: x_WH_UPDATE_DATE DATE,
28: x_STATUS VARCHAR2
29: ) IS
30: CURSOR C IS SELECT rowid FROM HZ_SECURITY_ISSUED
31: WHERE SECURITY_ISSUED_ID = x_SECURITY_ISSUED_ID;
32: BEGIN
33: INSERT INTO HZ_SECURITY_ISSUED(
34: SECURITY_ISSUED_ID,

Line 33: INSERT INTO HZ_SECURITY_ISSUED(

29: ) IS
30: CURSOR C IS SELECT rowid FROM HZ_SECURITY_ISSUED
31: WHERE SECURITY_ISSUED_ID = x_SECURITY_ISSUED_ID;
32: BEGIN
33: INSERT INTO HZ_SECURITY_ISSUED(
34: SECURITY_ISSUED_ID,
35: ESTIMATED_TOTAL_AMOUNT,
36: PARTY_ID,
37: STOCK_EXCHANGE_ID,

Line 92: DELETE FROM HZ_SECURITY_ISSUED

88:
89: PROCEDURE Delete_Row( x_SECURITY_ISSUED_ID NUMBER
90: ) IS
91: BEGIN
92: DELETE FROM HZ_SECURITY_ISSUED
93: WHERE SECURITY_ISSUED_ID = x_SECURITY_ISSUED_ID;
94: If (SQL%NOTFOUND) then
95: RAISE NO_DATA_FOUND;
96: End If;

Line 127: Update HZ_SECURITY_ISSUED

123: x_WH_UPDATE_DATE DATE,
124: x_STATUS VARCHAR2
125: ) IS
126: BEGIN
127: Update HZ_SECURITY_ISSUED
128: SET
129: SECURITY_ISSUED_ID = decode( x_SECURITY_ISSUED_ID, FND_API.G_MISS_NUM,SECURITY_ISSUED_ID,x_SECURITY_ISSUED_ID),
130: ESTIMATED_TOTAL_AMOUNT = decode( x_ESTIMATED_TOTAL_AMOUNT, FND_API.G_MISS_NUM,ESTIMATED_TOTAL_AMOUNT,x_ESTIMATED_TOTAL_AMOUNT),
131: PARTY_ID = decode( x_PARTY_ID, FND_API.G_MISS_NUM,PARTY_ID,x_PARTY_ID),

Line 190: FROM HZ_SECURITY_ISSUED

186: x_STATUS VARCHAR2
187: ) IS
188: CURSOR C IS
189: SELECT *
190: FROM HZ_SECURITY_ISSUED
191: WHERE rowid = x_Rowid
192: FOR UPDATE of SECURITY_ISSUED_ID NOWAIT;
193: Recinfo C%ROWTYPE;
194: BEGIN

Line 279: END HZ_SECURITY_ISSUED_PKG;

275: APP_EXCEPTION.RAISE_EXCEPTION;
276: End If;
277: END Lock_Row;
278:
279: END HZ_SECURITY_ISSUED_PKG;