APPS.IBC_CTYPE_GROUP_NODES_PKG dependencies on IBC_CTYPE_GROUP_NODES

Line 1: PACKAGE BODY Ibc_Ctype_Group_Nodes_Pkg AS

1: PACKAGE BODY Ibc_Ctype_Group_Nodes_Pkg AS
2: /* $Header: ibctcgnb.pls 120.1 2005/07/12 01:43:05 appldev ship $*/
3:
4: -- MODIFICATION HISTORY
5: -- Person Date Comments

Line 22: CURSOR C IS SELECT ROWID FROM Ibc_Ctype_Group_Nodes

18: p_LAST_UPDATE_DATE IN DATE,
19: p_LAST_UPDATED_BY IN NUMBER,
20: p_LAST_UPDATE_LOGIN IN NUMBER
21: ) IS
22: CURSOR C IS SELECT ROWID FROM Ibc_Ctype_Group_Nodes
23: WHERE CTYPE_GROUP_NODE_ID = px_CTYPE_GROUP_NODE_ID;
24:
25: CURSOR c2 IS SELECT Ibc_Ctype_Group_Nodes_s1.NEXTVAL FROM dual;
26:

Line 25: CURSOR c2 IS SELECT Ibc_Ctype_Group_Nodes_s1.NEXTVAL FROM dual;

21: ) IS
22: CURSOR C IS SELECT ROWID FROM Ibc_Ctype_Group_Nodes
23: WHERE CTYPE_GROUP_NODE_ID = px_CTYPE_GROUP_NODE_ID;
24:
25: CURSOR c2 IS SELECT Ibc_Ctype_Group_Nodes_s1.NEXTVAL FROM dual;
26:
27: BEGIN
28:
29: -- Primary key validation check

Line 38: INSERT INTO IBC_CTYPE_GROUP_NODES (

34: FETCH c2 INTO px_CTYPE_GROUP_NODE_ID;
35: CLOSE c2;
36: END IF;
37:
38: INSERT INTO IBC_CTYPE_GROUP_NODES (
39: CTYPE_GROUP_NODE_ID
40: ,CONTENT_TYPE_CODE
41: ,DIRECTORY_NODE_ID
42: ,OBJECT_VERSION_NUMBER

Line 87: UPDATE IBC_CTYPE_GROUP_NODES SET

83: p_LAST_UPDATE_DATE IN DATE DEFAULT NULL,
84: p_LAST_UPDATE_LOGIN IN NUMBER DEFAULT NULL
85: ) IS
86: BEGIN
87: UPDATE IBC_CTYPE_GROUP_NODES SET
88: CONTENT_TYPE_CODE = p_CONTENT_TYPE_CODE,
89: DIRECTORY_NODE_ID = p_DIRECTORY_NODE_ID,
90: last_update_date = DECODE(p_last_update_date, FND_API.G_MISS_DATE, SYSDATE,
91: NULL, SYSDATE, p_last_update_date),

Line 111: DELETE FROM IBC_CTYPE_GROUP_NODES

107: PROCEDURE DELETE_ROW (
108: p_CTYPE_GROUP_NODE_ID IN NUMBER
109: ) IS
110: BEGIN
111: DELETE FROM IBC_CTYPE_GROUP_NODES
112: WHERE CTYPE_GROUP_NODE_ID = p_CTYPE_GROUP_NODE_ID;
113:
114: IF (SQL%NOTFOUND) THEN
115: RAISE NO_DATA_FOUND;

Line 147: FROM IBC_CTYPE_GROUP_NODES

143: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
144:
145: -- get updatedby and update_date values if existing in db
146: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
147: FROM IBC_CTYPE_GROUP_NODES
148: WHERE CTYPE_GROUP_NODE_ID = p_CTYPE_GROUP_NODE_ID;
149:
150: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
151: db_user_id, db_last_update_date, p_upload_mode )) THEN

Line 153: Ibc_Ctype_Group_Nodes_Pkg.UPDATE_ROW (

149:
150: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
151: db_user_id, db_last_update_date, p_upload_mode )) THEN
152:
153: Ibc_Ctype_Group_Nodes_Pkg.UPDATE_ROW (
154: p_CTYPE_GROUP_NODE_ID => p_CTYPE_GROUP_NODE_ID,
155: p_CONTENT_TYPE_CODE => p_CONTENT_TYPE_CODE,
156: p_DIRECTORY_NODE_ID => p_DIRECTORY_NODE_ID,
157: p_LAST_UPDATED_BY => l_user_id,

Line 164: Ibc_Ctype_Group_Nodes_Pkg.INSERT_ROW (

160: );
161: END IF;
162: EXCEPTION
163: WHEN NO_DATA_FOUND THEN
164: Ibc_Ctype_Group_Nodes_Pkg.INSERT_ROW (
165: x_ROWID => l_row_id,
166: px_CTYPE_GROUP_NODE_ID => lx_CTYPE_GROUP_NODE_ID,
167: p_CONTENT_TYPE_CODE => p_CONTENT_TYPE_CODE,
168: p_DIRECTORY_NODE_ID => p_DIRECTORY_NODE_ID,

Line 190: Ibc_Ctype_Group_Nodes_Pkg.LOAD_ROW (

186: BEGIN
187: IF (p_UPLOAD_MODE = 'NLS') THEN
188: NULL;
189: ELSE
190: Ibc_Ctype_Group_Nodes_Pkg.LOAD_ROW (
191: p_UPLOAD_MODE => p_UPLOAD_MODE,
192: p_CTYPE_GROUP_NODE_ID => p_CTYPE_GROUP_NODE_ID,
193: p_CONTENT_TYPE_CODE => p_CONTENT_TYPE_CODE,
194: p_DIRECTORY_NODE_ID => p_DIRECTORY_NODE_ID,

Line 200: END Ibc_Ctype_Group_Nodes_Pkg;

196: p_last_update_date => p_LAST_UPDATE_DATE);
197: END IF;
198: END LOAD_SEED_ROW;
199:
200: END Ibc_Ctype_Group_Nodes_Pkg;