APPS.IBC_CONTENT_ITEM_NODES_PKG dependencies on IBC_CONTENT_ITEM_NODES

Line 1: PACKAGE BODY Ibc_Content_Item_Nodes_Pkg AS

1: PACKAGE BODY Ibc_Content_Item_Nodes_Pkg AS
2: /* $Header: ibctcinb.pls 115.4 2002/11/17 16:05:00 srrangar ship $*/
3:
4: -- Purpose: Table Handler for Ibc_Content_Item_Nodes table.
5:

Line 4: -- Purpose: Table Handler for Ibc_Content_Item_Nodes table.

1: PACKAGE BODY Ibc_Content_Item_Nodes_Pkg AS
2: /* $Header: ibctcinb.pls 115.4 2002/11/17 16:05:00 srrangar ship $*/
3:
4: -- Purpose: Table Handler for Ibc_Content_Item_Nodes table.
5:
6: -- MODIFICATION HISTORY
7: -- Person Date Comments
8: -- --------- ------ ------------------------------------------

Line 24: CURSOR C IS SELECT ROWID FROM IBC_CONTENT_ITEM_NODES

20: ,p_last_update_date IN DATE --DEFAULT NULL
21: ,p_last_updated_by IN NUMBER --DEFAULT NULL
22: ,p_last_update_login IN NUMBER --DEFAULT NULL
23: ) IS
24: CURSOR C IS SELECT ROWID FROM IBC_CONTENT_ITEM_NODES
25: WHERE content_item_node_id = px_content_item_node_id;
26: CURSOR c2 IS SELECT ibc_content_item_nodes_s1.NEXTVAL FROM dual;
27:
28: BEGIN

Line 26: CURSOR c2 IS SELECT ibc_content_item_nodes_s1.NEXTVAL FROM dual;

22: ,p_last_update_login IN NUMBER --DEFAULT NULL
23: ) IS
24: CURSOR C IS SELECT ROWID FROM IBC_CONTENT_ITEM_NODES
25: WHERE content_item_node_id = px_content_item_node_id;
26: CURSOR c2 IS SELECT ibc_content_item_nodes_s1.NEXTVAL FROM dual;
27:
28: BEGIN
29:
30: -- Primary key validation check

Line 40: INSERT INTO IBC_CONTENT_ITEM_NODES (

36: FETCH c2 INTO px_content_item_node_id;
37: CLOSE c2;
38: END IF;
39:
40: INSERT INTO IBC_CONTENT_ITEM_NODES (
41: content_item_node_id,
42: CONTENT_ITEM_ID,
43: DIRECTORY_NODE_ID,
44: OBJECT_VERSION_NUMBER,

Line 80: FROM IBC_CONTENT_ITEM_NODES

76: p_OBJECT_VERSION_NUMBER IN NUMBER
77: ) IS
78: CURSOR c IS SELECT
79: OBJECT_VERSION_NUMBER
80: FROM IBC_CONTENT_ITEM_NODES
81: WHERE content_item_node_id = p_content_item_node_id
82: FOR UPDATE OF CONTENT_ITEM_ID NOWAIT;
83: recinfo c%ROWTYPE;
84:

Line 114: UPDATE IBC_CONTENT_ITEM_NODES SET

110: ,p_last_update_login IN NUMBER --DEFAULT NULL
111: ,p_object_version_number IN NUMBER --DEFAULT NULL
112: ) IS
113: BEGIN
114: UPDATE IBC_CONTENT_ITEM_NODES SET
115: content_item_id = DECODE(p_content_item_id,FND_API.G_MISS_NUM,NULL,NULL,content_item_id,p_content_item_id)
116: ,directory_node_id = DECODE(p_directory_node_id,FND_API.G_MISS_NUM,NULL,NULL,directory_node_id,p_directory_node_id)
117: ,object_version_number = NVL(object_version_number,0) + 1
118: ,last_update_date = DECODE(p_last_update_date,FND_API.G_MISS_DATE,SYSDATE,NULL,SYSDATE,p_last_update_date)

Line 140: DELETE FROM IBC_CONTENT_ITEM_NODES

136: p_content_item_node_id IN NUMBER
137: ) IS
138: BEGIN
139:
140: DELETE FROM IBC_CONTENT_ITEM_NODES
141: WHERE content_item_node_id = p_content_item_node_id;
142:
143: IF (SQL%NOTFOUND) THEN
144: RAISE NO_DATA_FOUND;

Line 149: END Ibc_Content_Item_Nodes_Pkg;

145: END IF;
146: END DELETE_ROW;
147:
148:
149: END Ibc_Content_Item_Nodes_Pkg;