eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBC_ASSOCIATIONS_GRP dependencies on IBC_ASSOCIATIONS

Line 1: PACKAGE BODY Ibc_Associations_Grp AS

1: PACKAGE BODY Ibc_Associations_Grp AS
2: /* $Header: ibcgassb.pls 115.15 2003/11/20 00:22:03 vicho ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBC_ASSOCIATIONS_GRP';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ibcgassb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBC_ASSOCIATIONS_GRP';

1: PACKAGE BODY Ibc_Associations_Grp AS
2: /* $Header: ibcgassb.pls 115.15 2003/11/20 00:22:03 vicho ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBC_ASSOCIATIONS_GRP';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ibcgassb.pls';
6:
7: --------------------------------------------------------------------------------
8: -- Start of comments

Line 40: FROM IBC_ASSOCIATIONS

36: l_assoc_id NUMBER;
37: --
38: CURSOR Check_Duplicate_CItem IS
39: SELECT association_id
40: FROM IBC_ASSOCIATIONS
41: WHERE association_type_code = p_assoc_type_code
42: AND associated_object_val1 = p_assoc_object1
43: AND NVL(associated_object_val2, '0') = NVL(p_assoc_object2, '0')
44: AND NVL(associated_object_val3, '0') = NVL(p_assoc_object3, '0')

Line 122: Ibc_Associations_Pkg.insert_row (

118:
119:
120: -- Insert into table
121: l_assoc_id := NULL;
122: Ibc_Associations_Pkg.insert_row (
123: px_association_id => l_assoc_id
124: ,p_content_item_id => p_content_item_id
125: ,p_citem_version_id => p_citem_version_id
126: ,p_association_type_code => p_assoc_type_code

Line 216: FROM IBC_ASSOCIATIONS

212: l_assoc_id NUMBER;
213: --
214: CURSOR Check_Assoc IS
215: SELECT association_id
216: FROM IBC_ASSOCIATIONS
217: WHERE association_type_code = p_assoc_type_code
218: AND associated_object_val1 = p_assoc_object1
219: AND NVL(associated_object_val2, '0') = NVL(p_assoc_object2, '0')
220: AND NVL(associated_object_val3, '0') = NVL(p_assoc_object3, '0')

Line 263: Ibc_Associations_Pkg.delete_row(

259: END IF;
260: CLOSE Check_Assoc;
261:
262: -- Delete Entry
263: Ibc_Associations_Pkg.delete_row(
264: p_association_id => l_assoc_id
265: );
266:
267: -- Log Action

Line 347: FROM IBC_ASSOCIATIONS

343: l_tmp_id NUMBER;
344: --
345: CURSOR Check_Assoc IS
346: SELECT association_id
347: FROM IBC_ASSOCIATIONS
348: WHERE association_type_code = p_assoc_type_code
349: AND associated_object_val1 = p_assoc_object1
350: AND NVL(associated_object_val2, '0') = NVL(p_assoc_object2, '0')
351: AND NVL(associated_object_val3, '0') = NVL(p_assoc_object3, '0')

Line 433: Ibc_Associations_Pkg.update_row (

429: RAISE Fnd_Api.G_EXC_ERROR;
430: END IF;
431:
432: -- UPDATE row
433: Ibc_Associations_Pkg.update_row (
434: p_association_id => l_assoc_id
435: ,p_content_item_id => p_new_citem_id
436: ,p_citem_version_id => p_new_citem_ver_id
437: );

Line 762: DELETE FROM IBC_ASSOCIATIONS

758: --
759: --DBMS_OUT NOCOPYPUT.put_line('Begin Successful....');
760:
761: FORALL i IN p_old_content_item_ids.FIRST..p_old_content_item_ids.LAST
762: DELETE FROM IBC_ASSOCIATIONS
763: WHERE ROWID IN (
764: SELECT A.ROWID FROM IBC_ASSOCIATIONS A,
765: (
766: -- The below Select Statement Returns all the rows that will be updated

Line 764: SELECT A.ROWID FROM IBC_ASSOCIATIONS A,

760:
761: FORALL i IN p_old_content_item_ids.FIRST..p_old_content_item_ids.LAST
762: DELETE FROM IBC_ASSOCIATIONS
763: WHERE ROWID IN (
764: SELECT A.ROWID FROM IBC_ASSOCIATIONS A,
765: (
766: -- The below Select Statement Returns all the rows that will be updated
767: -- in the following Update Statement Which moves an Association from old_content_item_id
768: -- to the New Content Item id.

Line 780: FROM IBC_ASSOCIATIONS

776: ,associated_object_val2
777: ,associated_object_val3
778: ,associated_object_val4
779: ,associated_object_val5
780: FROM IBC_ASSOCIATIONS
781: WHERE CONTENT_ITEM_ID = p_old_content_item_ids(i)
782: AND ((citem_version_id IS NULL AND p_old_citem_version_ids(i) IS NULL)
783: OR
784: (citem_version_id = p_old_citem_version_ids(i))

Line 821: UPDATE IBC_ASSOCIATIONS SET

817:
818:
819:
820: FORALL i IN p_old_content_item_ids.FIRST..p_old_content_item_ids.LAST
821: UPDATE IBC_ASSOCIATIONS SET
822: CONTENT_ITEM_ID = p_new_content_item_ids(i)
823: ,CITEM_VERSION_ID = p_new_citem_version_ids(i)
824: ,OBJECT_VERSION_NUMBER = 1
825: ,LAST_UPDATE_DATE = SYSDATE

Line 850: Ibc_Associations_Pkg.insert_row (

846: LOOP
847: IF SQL%BULK_ROWCOUNT(i) = 0 AND p_old_content_item_ids(i) IS NULL THEN
848: BEGIN
849:
850: Ibc_Associations_Pkg.insert_row (
851: px_association_id => l_assoc_id
852: ,p_content_item_id => p_new_content_item_ids(i)
853: ,p_citem_version_id => p_new_citem_version_ids(i)
854: ,p_association_type_code => p_assoc_type_codes(i)

Line 1076: Ibc_Associations_Pkg.insert_row (

1072: END IF;
1073:
1074: -- Insert into table
1075: l_assoc_id := NULL;
1076: Ibc_Associations_Pkg.insert_row (
1077: px_association_id => l_assoc_id
1078: ,p_content_item_id => l_content_item_id
1079: ,p_citem_version_id => l_citem_version_id
1080: ,p_association_type_code => l_assoc_type_code

Line 1212: FROM IBC_ASSOCIATIONS

1208: l_assoc_object5 VARCHAR2(254);
1209: --
1210: CURSOR Get_Assoc_Id IS
1211: SELECT association_id
1212: FROM IBC_ASSOCIATIONS
1213: WHERE content_item_id = l_content_item_id
1214: AND ((citem_version_id IS NULL AND l_citem_version_id IS NULL) OR
1215: (citem_version_id = l_citem_version_id)
1216: )

Line 1301: Ibc_Associations_Pkg.delete_row(

1297: END IF;
1298: CLOSE Get_Assoc_Id;
1299:
1300: -- Delete Entry
1301: Ibc_Associations_Pkg.delete_row(
1302: p_association_id => l_temp_assoc_id
1303: );
1304:
1305: -- Log Action

Line 1447: FROM IBC_ASSOCIATIONS a, IBC_ASSOCIATION_TYPES_B t

1443: CURSOR Get_Assoc IS
1444: SELECT a.ASSOCIATION_TYPE_CODE, a.ASSOCIATED_OBJECT_VAL1, a.ASSOCIATED_OBJECT_VAL2,
1445: a.ASSOCIATED_OBJECT_VAL3, a.ASSOCIATED_OBJECT_VAL4, a.ASSOCIATED_OBJECT_VAL5,
1446: t.CALL_BACK_PKG
1447: FROM IBC_ASSOCIATIONS a, IBC_ASSOCIATION_TYPES_B t
1448: WHERE a.CONTENT_ITEM_ID = p_content_item_id AND
1449: ((a.citem_version_id IS NULL AND p_citem_version_id IS NULL)
1450: OR
1451: (a.citem_version_id = p_citem_version_id)) AND

Line 1751: END Ibc_Associations_Grp;

1747:
1748: END Get_Association_NameAndCode;
1749:
1750:
1751: END Ibc_Associations_Grp;