APPS.IBC_ASSOCIATIONS_PKG dependencies on IBC_ASSOCIATIONS

Line 1: PACKAGE BODY Ibc_Associations_Pkg AS

1: PACKAGE BODY Ibc_Associations_Pkg AS
2: /* $Header: ibctasnb.pls 120.1 2005/07/29 15:10:16 appldev ship $ */
3:
4:
5: -- Purpose: Table Handler for IBC_ASSOCIATIONS table.

Line 5: -- Purpose: Table Handler for IBC_ASSOCIATIONS table.

1: PACKAGE BODY Ibc_Associations_Pkg AS
2: /* $Header: ibctasnb.pls 120.1 2005/07/29 15:10:16 appldev ship $ */
3:
4:
5: -- Purpose: Table Handler for IBC_ASSOCIATIONS table.
6:
7: -- MODIFICATION HISTORY
8: -- Person Date Comments
9: -- --------- ------ ------------------------------------------

Line 35: CURSOR c IS SELECT ROWID FROM ibc_associations

31: ,p_last_updated_by IN NUMBER --DEFAULT NULL
32: ,p_last_update_login IN NUMBER --DEFAULT NULL
33: ) IS
34:
35: CURSOR c IS SELECT ROWID FROM ibc_associations
36: WHERE association_id = px_association_id;
37:
38: CURSOR c2 IS SELECT ibc_associations_s1.NEXTVAL FROM dual;
39:

Line 38: CURSOR c2 IS SELECT ibc_associations_s1.NEXTVAL FROM dual;

34:
35: CURSOR c IS SELECT ROWID FROM ibc_associations
36: WHERE association_id = px_association_id;
37:
38: CURSOR c2 IS SELECT ibc_associations_s1.NEXTVAL FROM dual;
39:
40: BEGIN
41:
42: -- Primary key validation check

Line 52: INSERT INTO ibc_associations (

48: FETCH c2 INTO px_association_id;
49: CLOSE c2;
50: END IF;
51:
52: INSERT INTO ibc_associations (
53: association_id
54: ,content_item_id
55: ,citem_version_id
56: ,association_type_code

Line 120: UPDATE ibc_associations SET

116: ,p_last_update_login IN NUMBER --DEFAULT NULL
117: )
118: IS
119: BEGIN
120: UPDATE ibc_associations SET
121: content_item_id = DECODE(p_content_item_id,Fnd_Api.G_MISS_NUM,NULL,NULL,content_item_id,p_content_item_id)
122: ,citem_version_id = DECODE(p_citem_version_id,Fnd_Api.G_MISS_NUM,NULL,NULL,citem_version_id,p_citem_version_id)
123: ,association_type_code = DECODE(p_association_type_code,Fnd_Api.G_MISS_CHAR,NULL,NULL,association_type_code,p_association_type_code)
124: ,associated_object_val1 = DECODE(p_associated_object_val1,Fnd_Api.G_MISS_CHAR,NULL,NULL,associated_object_val1,p_associated_object_val1)

Line 152: DELETE FROM ibc_associations

148: p_association_id IN NUMBER
149: ) IS
150: BEGIN
151:
152: DELETE FROM ibc_associations
153: WHERE association_id = p_association_id;
154:
155: IF (SQL%NOTFOUND) THEN
156: RAISE NO_DATA_FOUND;

Line 182: FROM ibc_associations

178: associated_object_val3,
179: associated_object_val4,
180: associated_object_val5,
181: object_version_number
182: FROM ibc_associations
183: WHERE association_id = p_association_id
184: FOR UPDATE OF association_id NOWAIT;
185: recinfo c%ROWTYPE;
186:

Line 250: FROM IBC_ASSOCIATIONS

246: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
247:
248: -- get updatedby and update_date values if existing in db
249: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
250: FROM IBC_ASSOCIATIONS
251: WHERE ASSOCIATION_ID = To_NUMBER(p_association_id);
252: BEGIN
253:
254: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,

Line 257: Ibc_Associations_Pkg.UPDATE_ROW (

253:
254: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
255: db_user_id, db_last_update_date, p_upload_mode )) THEN
256:
257: Ibc_Associations_Pkg.UPDATE_ROW (
258: p_CONTENT_ITEM_ID => p_content_item_id
259: ,p_CITEM_VERSION_ID => p_citem_version_id
260: ,p_ASSOCIATION_ID => p_association_id
261: ,p_ASSOCIATION_TYPE_CODE => p_association_type_code

Line 276: Ibc_Associations_Pkg.INSERT_ROW (

272: END IF;
273: EXCEPTION
274: WHEN NO_DATA_FOUND THEN
275:
276: Ibc_Associations_Pkg.INSERT_ROW (
277: x_rowid => lx_rowid
278: ,px_ASSOCIATION_ID => lx_association_id
279: ,p_CONTENT_ITEM_ID => p_content_item_id
280: ,p_CITEM_VERSION_ID => p_citem_version_id

Line 314: IBC_ASSOCIATIONS_PKG.LOAD_ROW (

310: BEGIN
311: IF (p_UPLOAD_MODE = 'NLS') THEN
312: NULL;
313: ELSE
314: IBC_ASSOCIATIONS_PKG.LOAD_ROW (
315: p_upload_mode => p_upload_mode,
316: p_association_id => p_association_id
317: ,p_content_item_id => p_content_item_id
318: ,p_citem_version_id => p_citem_version_id

Line 330: END Ibc_Associations_Pkg;

326: p_last_update_date => p_last_update_date);
327: END IF;
328: END;
329:
330: END Ibc_Associations_Pkg;