APPS.AS_ISSUE_GROUP_IDFR_PKG dependencies on AS_ISSUE_GROUP_IDFR

Line 1: PACKAGE BODY AS_ISSUE_GROUP_IDFR_PKG AS

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

Line 4: -- Package name : AS_ISSUE_GROUP_IDFR_PKG

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

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

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

Line 34: CURSOR C1 IS SELECT AS_ISSUE_GROUP_IDFR_S.nextval FROM sys.dual;

30: p_attribute12 IN VARCHAR2,
31: p_attribute13 IN VARCHAR2,
32: p_attribute14 IN VARCHAR2,
33: p_attribute15 IN VARCHAR2 ) IS
34: CURSOR C1 IS SELECT AS_ISSUE_GROUP_IDFR_S.nextval FROM sys.dual;
35: CURSOR C2 IS SELECT ROWID FROM as_issue_group_idfr
36: WHERE issue_group_idfr_id = p_issue_group_idfr_id;
37: BEGIN
38: IF (p_issue_group_id IS NULL) OR (p_issue_group_id = FND_API.G_MISS_NUM) THEN

Line 35: CURSOR C2 IS SELECT ROWID FROM as_issue_group_idfr

31: p_attribute13 IN VARCHAR2,
32: p_attribute14 IN VARCHAR2,
33: p_attribute15 IN VARCHAR2 ) IS
34: CURSOR C1 IS SELECT AS_ISSUE_GROUP_IDFR_S.nextval FROM sys.dual;
35: CURSOR C2 IS SELECT ROWID FROM as_issue_group_idfr
36: WHERE issue_group_idfr_id = p_issue_group_idfr_id;
37: BEGIN
38: IF (p_issue_group_id IS NULL) OR (p_issue_group_id = FND_API.G_MISS_NUM) THEN
39: OPEN C1;

Line 43: INSERT INTO AS_ISSUE_GROUP_IDFR ( issue_group_idfr_id ,

39: OPEN C1;
40: FETCH C1 INTO p_issue_group_idfr_id;
41: CLOSE C1;
42: END IF;
43: INSERT INTO AS_ISSUE_GROUP_IDFR ( issue_group_idfr_id ,
44: issue_group_id,
45: scheme,
46: value,
47: search_code,

Line 131: UPDATE AS_ISSUE_GROUP_IDFR SET

127: p_attribute13 IN VARCHAR2,
128: p_attribute14 IN VARCHAR2,
129: p_attribute15 IN VARCHAR2) IS
130: BEGIN
131: UPDATE AS_ISSUE_GROUP_IDFR SET
132: ISSUE_GROUP_ID = DECODE(p_issue_group_id, FND_API.G_MISS_NUM, issue_group_id, p_issue_group_id),
133: SCHEME = DECODE(p_scheme , FND_API.G_MISS_CHAR, scheme, p_scheme ),
134: VALUE = DECODE(p_value, FND_API.G_MISS_CHAR, value, p_value),
135: SEARCH_CODE = DECODE(p_search_code , FND_API.G_MISS_CHAR, search_code, p_search_code ),

Line 166: DELETE FROM AS_ISSUE_GROUP_IDFR

162: END UPDATE_ROW;
163:
164: PROCEDURE delete_row (p_issue_group_idfr_id IN NUMBER ) IS
165: BEGIN
166: DELETE FROM AS_ISSUE_GROUP_IDFR
167: WHERE ISSUE_GROUP_IDFR_ID = P_ISSUE_GROUP_IDFR_ID;
168: IF (SQL%NOTFOUND) THEN
169: RAISE NO_DATA_FOUND;
170: END IF;

Line 172: END AS_ISSUE_GROUP_IDFR_PKG;

168: IF (SQL%NOTFOUND) THEN
169: RAISE NO_DATA_FOUND;
170: END IF;
171: END DELETE_ROW;
172: END AS_ISSUE_GROUP_IDFR_PKG;