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 120.2 2012/02/15 06:10:26 rsatyava 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 120.2 2012/02/15 06:10:26 rsatyava 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 = NVL(p_old_citem_version_ids(i),citem_version_id)
783: AND association_type_code = p_assoc_type_codes(i)
784: AND (associated_object_val1 = p_assoc_objects1(i) OR DECODE(p_assoc_objects1(i),NULL,1) = 1)

Line 815: UPDATE IBC_ASSOCIATIONS SET

811:
812:
813:
814: FORALL i IN p_old_content_item_ids.FIRST..p_old_content_item_ids.LAST
815: UPDATE IBC_ASSOCIATIONS SET
816: CONTENT_ITEM_ID = p_new_content_item_ids(i)
817: ,CITEM_VERSION_ID = p_new_citem_version_ids(i)
818: ,OBJECT_VERSION_NUMBER = 1
819: ,LAST_UPDATE_DATE = SYSDATE

Line 841: Ibc_Associations_Pkg.insert_row (

837: LOOP
838: IF SQL%BULK_ROWCOUNT(i) = 0 AND p_old_content_item_ids(i) IS NULL THEN
839: BEGIN
840:
841: Ibc_Associations_Pkg.insert_row (
842: px_association_id => l_assoc_id
843: ,p_content_item_id => p_new_content_item_ids(i)
844: ,p_citem_version_id => p_new_citem_version_ids(i)
845: ,p_association_type_code => p_assoc_type_codes(i)

Line 1098: Ibc_Associations_Pkg.insert_row (

1094: END IF;
1095:
1096: -- Insert into table
1097: l_assoc_id := NULL;
1098: Ibc_Associations_Pkg.insert_row (
1099: px_association_id => l_assoc_id
1100: ,p_content_item_id => l_content_item_id
1101: ,p_citem_version_id => l_citem_version_id
1102: ,p_association_type_code => l_assoc_type_code

Line 1234: FROM IBC_ASSOCIATIONS

1230: l_assoc_object5 VARCHAR2(254);
1231: --
1232: CURSOR Get_Assoc_Id IS
1233: SELECT association_id
1234: FROM IBC_ASSOCIATIONS
1235: WHERE content_item_id = l_content_item_id
1236: AND citem_version_id = NVL(l_citem_version_id,citem_version_id)
1237: AND association_type_code = l_assoc_type_code
1238: AND associated_object_val1 = l_assoc_object1

Line 1321: Ibc_Associations_Pkg.delete_row(

1317: END IF;
1318: CLOSE Get_Assoc_Id;
1319:
1320: -- Delete Entry
1321: Ibc_Associations_Pkg.delete_row(
1322: p_association_id => l_temp_assoc_id
1323: );
1324:
1325: -- Log Action

Line 1467: FROM IBC_ASSOCIATIONS a, IBC_ASSOCIATION_TYPES_B t

1463: CURSOR Get_Assoc IS
1464: SELECT a.ASSOCIATION_TYPE_CODE, a.ASSOCIATED_OBJECT_VAL1, a.ASSOCIATED_OBJECT_VAL2,
1465: a.ASSOCIATED_OBJECT_VAL3, a.ASSOCIATED_OBJECT_VAL4, a.ASSOCIATED_OBJECT_VAL5,
1466: t.CALL_BACK_PKG
1467: FROM IBC_ASSOCIATIONS a, IBC_ASSOCIATION_TYPES_B t
1468: WHERE a.CONTENT_ITEM_ID = p_content_item_id AND
1469: a.citem_version_id = NVL(p_citem_version_id,a.citem_version_id) AND
1470: a.ASSOCIATION_TYPE_CODE = t.ASSOCIATION_TYPE_CODE;
1471:

Line 1769: END Ibc_Associations_Grp;

1765:
1766: END Get_Association_NameAndCode;
1767:
1768:
1769: END Ibc_Associations_Grp;