APPS.IBC_COMPOUND_RELATIONS_PKG dependencies on IBC_COMPOUND_RELATIONS

Line 1: PACKAGE BODY Ibc_Compound_Relations_Pkg AS

1: PACKAGE BODY Ibc_Compound_Relations_Pkg AS
2: /* $Header: ibctcrlb.pls 120.1 2005/07/29 15:03:56 appldev ship $*/
3:
4: -- Purpose: Table Handler for Ibc_Compound_Relations table.
5:

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

1: PACKAGE BODY Ibc_Compound_Relations_Pkg AS
2: /* $Header: ibctcrlb.pls 120.1 2005/07/29 15:03:56 appldev ship $*/
3:
4: -- Purpose: Table Handler for Ibc_Compound_Relations table.
5:
6: -- MODIFICATION HISTORY
7: -- Person Date Comments
8: -- --------- ------ ------------------------------------------

Line 32: CURSOR C IS SELECT ROWID FROM IBC_COMPOUND_RELATIONS

28: ,p_last_updated_by IN NUMBER --DEFAULT NULL
29: ,p_last_update_login IN NUMBER --DEFAULT NULL
30: ,p_subitem_version_id IN NUMBER --DEFAULT NULL
31: ) IS
32: CURSOR C IS SELECT ROWID FROM IBC_COMPOUND_RELATIONS
33: WHERE compound_relation_id = compound_relation_id;
34:
35: CURSOR c2 IS SELECT ibc_compound_relations_s1.NEXTVAL FROM dual;
36:

Line 35: CURSOR c2 IS SELECT ibc_compound_relations_s1.NEXTVAL FROM dual;

31: ) IS
32: CURSOR C IS SELECT ROWID FROM IBC_COMPOUND_RELATIONS
33: WHERE compound_relation_id = compound_relation_id;
34:
35: CURSOR c2 IS SELECT ibc_compound_relations_s1.NEXTVAL FROM dual;
36:
37: BEGIN
38:
39: -- Primary key validation check

Line 49: INSERT INTO IBC_COMPOUND_RELATIONS (

45: FETCH c2 INTO px_compound_relation_id;
46: CLOSE c2;
47: END IF;
48:
49: INSERT INTO IBC_COMPOUND_RELATIONS (
50: compound_relation_id,
51: CONTENT_ITEM_ID,
52: ATTRIBUTE_TYPE_CODE,
53: CONTENT_TYPE_CODE,

Line 101: FROM IBC_COMPOUND_RELATIONS

97: ) IS
98: CURSOR c IS SELECT
99: OBJECT_VERSION_NUMBER,
100: SORT_ORDER
101: FROM IBC_COMPOUND_RELATIONS
102: WHERE compound_relation_id = p_compound_relation_id
103: FOR UPDATE OF CONTENT_ITEM_ID NOWAIT;
104: recinfo c%ROWTYPE;
105:

Line 140: UPDATE IBC_COMPOUND_RELATIONS SET

136: ,p_sort_order IN NUMBER --DEFAULT NULL
137: ,p_subitem_version_id IN NUMBER --DEFAULT NULL
138: ) IS
139: BEGIN
140: UPDATE IBC_COMPOUND_RELATIONS SET
141: content_item_id = DECODE(p_content_item_id,FND_API.G_MISS_NUM,NULL,NULL,content_item_id,p_content_item_id)
142: ,attribute_type_code = DECODE(p_attribute_type_code,FND_API.G_MISS_CHAR,NULL,NULL,attribute_type_code,p_attribute_type_code)
143: ,content_type_code = DECODE(p_content_type_code,FND_API.G_MISS_CHAR,NULL,NULL,content_type_code,p_content_type_code)
144: ,citem_version_id = DECODE(p_citem_version_id,FND_API.G_MISS_NUM,NULL,NULL,citem_version_id,p_citem_version_id)

Line 173: DELETE FROM IBC_COMPOUND_RELATIONS

169: p_compound_relation_id IN NUMBER
170: ) IS
171: BEGIN
172:
173: DELETE FROM IBC_COMPOUND_RELATIONS
174: WHERE compound_relation_id = p_compound_relation_id;
175:
176: IF (SQL%NOTFOUND) THEN
177: RAISE NO_DATA_FOUND;

Line 196: Ibc_Compound_Relations_Pkg.LOAD_ROW (

192: BEGIN
193: IF (p_UPLOAD_MODE = 'NLS') THEN
194: NULL;
195: ELSE
196: Ibc_Compound_Relations_Pkg.LOAD_ROW (
197: p_UPLOAD_MODE => p_UPLOAD_MODE,
198: p_CONTENT_ITEM_ID => p_CONTENT_ITEM_ID,
199: p_ATTRIBUTE_TYPE_CODE => p_ATTRIBUTE_TYPE_CODE,
200: p_CONTENT_TYPE_CODE => p_CONTENT_TYPE_CODE,

Line 241: FROM IBC_COMPOUND_RELATIONS

237: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
238:
239: -- get updatedby and update_date values if existing in db
240: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
241: FROM IBC_COMPOUND_RELATIONS
242: WHERE p_compound_relation_id = p_compound_relation_id;
243:
244: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
245: db_user_id, db_last_update_date, p_upload_mode )) THEN

Line 282: END Ibc_Compound_Relations_Pkg;

278: p_subitem_version_id => p_subitem_version_id);
279: END LOAD_ROW;
280:
281:
282: END Ibc_Compound_Relations_Pkg;