APPS.AS_ISSUER_PKG dependencies on AS_ISSUER

Line 1: PACKAGE BODY AS_ISSUER_PKG AS

1: PACKAGE BODY AS_ISSUER_PKG AS
2: /* $Header: asxifipb.pls 115.5 2002/11/06 00:41:30 appldev ship $ */
3: -- Start of Comments
4: -- Package name : AS_ISSUER_PKG
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AS_ISSUER_PKG';

Line 4: -- Package name : AS_ISSUER_PKG

1: PACKAGE BODY AS_ISSUER_PKG AS
2: /* $Header: asxifipb.pls 115.5 2002/11/06 00:41:30 appldev ship $ */
3: -- Start of Comments
4: -- Package name : AS_ISSUER_PKG
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AS_ISSUER_PKG';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxtifib.pls';
7: PROCEDURE insert_row( p_row_id IN OUT VARCHAR2,
8: p_party_id IN NUMBER,

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AS_ISSUER_PKG';

1: PACKAGE BODY AS_ISSUER_PKG AS
2: /* $Header: asxifipb.pls 115.5 2002/11/06 00:41:30 appldev ship $ */
3: -- Start of Comments
4: -- Package name : AS_ISSUER_PKG
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AS_ISSUER_PKG';
6: G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxtifib.pls';
7: PROCEDURE insert_row( p_row_id IN OUT VARCHAR2,
8: p_party_id IN NUMBER,
9: p_target_cap IN NUMBER,

Line 31: CURSOR C2 IS SELECT ROWID FROM as_issuer

27: p_attribute12 IN VARCHAR2,
28: p_attribute13 IN VARCHAR2,
29: p_attribute14 IN VARCHAR2,
30: p_attribute15 IN VARCHAR2) IS
31: CURSOR C2 IS SELECT ROWID FROM as_issuer
32: WHERE party_id = p_party_id;
33: BEGIN
34: INSERT INTO AS_ISSUER (party_id,
35: target_cap,

Line 34: INSERT INTO AS_ISSUER (party_id,

30: p_attribute15 IN VARCHAR2) IS
31: CURSOR C2 IS SELECT ROWID FROM as_issuer
32: WHERE party_id = p_party_id;
33: BEGIN
34: INSERT INTO AS_ISSUER (party_id,
35: target_cap,
36: last_update_date,
37: last_updated_by ,
38: creation_date,

Line 113: UPDATE AS_ISSUER SET

109: p_attribute13 IN VARCHAR2,
110: p_attribute14 IN VARCHAR2,
111: p_attribute15 IN VARCHAR2) IS
112: BEGIN
113: UPDATE AS_ISSUER SET
114: TARGET_CAP = DECODE(P_TARGET_CAP, FND_API.G_MISS_NUM, TARGET_CAP, P_TARGET_CAP),
115: ATTRIBUTE1 = DECODE(P_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, P_ATTRIBUTE1),
116: ATTRIBUTE2 = DECODE(P_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, P_ATTRIBUTE2),
117: ATTRIBUTE3 = DECODE(P_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, P_ATTRIBUTE3),

Line 147: DELETE FROM AS_ISSUER

143: END IF;
144: END UPDATE_ROW;
145: PROCEDURE DELETE_ROW (p_party_id IN NUMBER ) IS
146: BEGIN
147: DELETE FROM AS_ISSUER
148: WHERE PARTY_ID = P_PARTY_ID ;
149: IF (SQL%NOTFOUND) THEN
150: RAISE no_data_found;
151: END IF;

Line 153: END AS_ISSUER_PKG;

149: IF (SQL%NOTFOUND) THEN
150: RAISE no_data_found;
151: END IF;
152: END DELETE_ROW;
153: END AS_ISSUER_PKG;