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_CITEM_ADMIN_GRP dependencies on IBC_ASSOCIATIONS

Line 581: FROM IBC_ASSOCIATIONS

577: RETURN VARCHAR2
578: IS
579: CURSOR c_check IS
580: SELECT association_id
581: FROM IBC_ASSOCIATIONS
582: WHERE content_item_id = p_content_item_id;
583: temp NUMBER;
584: BEGIN
585: OPEN c_check;

Line 1972: Ibc_Associations_Pkg.insert_row (

1968: ELSE
1969: a5 := NULL;
1970: END IF;
1971: -- ACTUAL INSERT !!!
1972: Ibc_Associations_Pkg.insert_row (
1973: px_association_id => assoc_id
1974: ,p_content_item_id => p_content_item_id
1975: ,p_citem_version_id => p_citem_version_id
1976: ,p_association_type_code => p_assoc_type_codes(counter)

Line 4445: IBC_ASSOCIATIONS

4441: ,associated_object_val4
4442: ,associated_object_val5
4443: ,citem_version_id
4444: FROM
4445: IBC_ASSOCIATIONS
4446: WHERE
4447: content_item_id = :CID
4448: AND (
4449: (citem_version_id IS NULL) OR

Line 4456: atc IBC_ASSOCIATIONS.association_type_code%TYPE; -- temp loop association type code

4452: ';
4453: cursor_id INTEGER; -- dynamic sql variable
4454: cursor_return INTEGER; -- dynamic sql variable
4455:
4456: atc IBC_ASSOCIATIONS.association_type_code%TYPE; -- temp loop association type code
4457: aov1 IBC_ASSOCIATIONS.associated_object_val1%TYPE; -- temp loop associated object code
4458: aov2 IBC_ASSOCIATIONS.associated_object_val2%TYPE; -- temp loop associated object code
4459: aov3 IBC_ASSOCIATIONS.associated_object_val3%TYPE; -- temp loop associated object code
4460: aov4 IBC_ASSOCIATIONS.associated_object_val4%TYPE; -- temp loop associated object code

Line 4457: aov1 IBC_ASSOCIATIONS.associated_object_val1%TYPE; -- temp loop associated object code

4453: cursor_id INTEGER; -- dynamic sql variable
4454: cursor_return INTEGER; -- dynamic sql variable
4455:
4456: atc IBC_ASSOCIATIONS.association_type_code%TYPE; -- temp loop association type code
4457: aov1 IBC_ASSOCIATIONS.associated_object_val1%TYPE; -- temp loop associated object code
4458: aov2 IBC_ASSOCIATIONS.associated_object_val2%TYPE; -- temp loop associated object code
4459: aov3 IBC_ASSOCIATIONS.associated_object_val3%TYPE; -- temp loop associated object code
4460: aov4 IBC_ASSOCIATIONS.associated_object_val4%TYPE; -- temp loop associated object code
4461: aov5 IBC_ASSOCIATIONS.associated_object_val5%TYPE; -- temp loop associated object code

Line 4458: aov2 IBC_ASSOCIATIONS.associated_object_val2%TYPE; -- temp loop associated object code

4454: cursor_return INTEGER; -- dynamic sql variable
4455:
4456: atc IBC_ASSOCIATIONS.association_type_code%TYPE; -- temp loop association type code
4457: aov1 IBC_ASSOCIATIONS.associated_object_val1%TYPE; -- temp loop associated object code
4458: aov2 IBC_ASSOCIATIONS.associated_object_val2%TYPE; -- temp loop associated object code
4459: aov3 IBC_ASSOCIATIONS.associated_object_val3%TYPE; -- temp loop associated object code
4460: aov4 IBC_ASSOCIATIONS.associated_object_val4%TYPE; -- temp loop associated object code
4461: aov5 IBC_ASSOCIATIONS.associated_object_val5%TYPE; -- temp loop associated object code
4462: civid IBC_ASSOCIATIONS.citem_version_id%TYPE; -- temp loop for citem version id

Line 4459: aov3 IBC_ASSOCIATIONS.associated_object_val3%TYPE; -- temp loop associated object code

4455:
4456: atc IBC_ASSOCIATIONS.association_type_code%TYPE; -- temp loop association type code
4457: aov1 IBC_ASSOCIATIONS.associated_object_val1%TYPE; -- temp loop associated object code
4458: aov2 IBC_ASSOCIATIONS.associated_object_val2%TYPE; -- temp loop associated object code
4459: aov3 IBC_ASSOCIATIONS.associated_object_val3%TYPE; -- temp loop associated object code
4460: aov4 IBC_ASSOCIATIONS.associated_object_val4%TYPE; -- temp loop associated object code
4461: aov5 IBC_ASSOCIATIONS.associated_object_val5%TYPE; -- temp loop associated object code
4462: civid IBC_ASSOCIATIONS.citem_version_id%TYPE; -- temp loop for citem version id
4463:

Line 4460: aov4 IBC_ASSOCIATIONS.associated_object_val4%TYPE; -- temp loop associated object code

4456: atc IBC_ASSOCIATIONS.association_type_code%TYPE; -- temp loop association type code
4457: aov1 IBC_ASSOCIATIONS.associated_object_val1%TYPE; -- temp loop associated object code
4458: aov2 IBC_ASSOCIATIONS.associated_object_val2%TYPE; -- temp loop associated object code
4459: aov3 IBC_ASSOCIATIONS.associated_object_val3%TYPE; -- temp loop associated object code
4460: aov4 IBC_ASSOCIATIONS.associated_object_val4%TYPE; -- temp loop associated object code
4461: aov5 IBC_ASSOCIATIONS.associated_object_val5%TYPE; -- temp loop associated object code
4462: civid IBC_ASSOCIATIONS.citem_version_id%TYPE; -- temp loop for citem version id
4463:
4464: assoc_id NUMBER; --temp holder of newly created association id

Line 4461: aov5 IBC_ASSOCIATIONS.associated_object_val5%TYPE; -- temp loop associated object code

4457: aov1 IBC_ASSOCIATIONS.associated_object_val1%TYPE; -- temp loop associated object code
4458: aov2 IBC_ASSOCIATIONS.associated_object_val2%TYPE; -- temp loop associated object code
4459: aov3 IBC_ASSOCIATIONS.associated_object_val3%TYPE; -- temp loop associated object code
4460: aov4 IBC_ASSOCIATIONS.associated_object_val4%TYPE; -- temp loop associated object code
4461: aov5 IBC_ASSOCIATIONS.associated_object_val5%TYPE; -- temp loop associated object code
4462: civid IBC_ASSOCIATIONS.citem_version_id%TYPE; -- temp loop for citem version id
4463:
4464: assoc_id NUMBER; --temp holder of newly created association id
4465:

Line 4462: civid IBC_ASSOCIATIONS.citem_version_id%TYPE; -- temp loop for citem version id

4458: aov2 IBC_ASSOCIATIONS.associated_object_val2%TYPE; -- temp loop associated object code
4459: aov3 IBC_ASSOCIATIONS.associated_object_val3%TYPE; -- temp loop associated object code
4460: aov4 IBC_ASSOCIATIONS.associated_object_val4%TYPE; -- temp loop associated object code
4461: aov5 IBC_ASSOCIATIONS.associated_object_val5%TYPE; -- temp loop associated object code
4462: civid IBC_ASSOCIATIONS.citem_version_id%TYPE; -- temp loop for citem version id
4463:
4464: assoc_id NUMBER; --temp holder of newly created association id
4465:
4466: */

Line 4699: Ibc_Associations_Pkg.insert_row (

4695: civid := px_citem_ver_id;
4696: END IF;
4697:
4698: -- copying every row
4699: Ibc_Associations_Pkg.insert_row (
4700: px_association_id => assoc_id
4701: ,p_content_item_id => new_citem_id
4702: ,p_citem_version_id => civid
4703: ,p_association_type_code => atc

Line 5480: ibc_associations

5476: -- used to loop through all the attributes
5477: A_LIST VARCHAR2(4000) := 'SELECT
5478: association_id
5479: FROM
5480: ibc_associations
5481: WHERE
5482: content_item_id = :CITEM
5483: AND
5484: association_type_code = :ACODE

Line 5646: Ibc_Associations_Pkg.delete_row(

5642:
5643: -- loading column values
5644: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, aid);
5645:
5646: Ibc_Associations_Pkg.delete_row(
5647: p_association_id => aid
5648: );
5649:
5650: --***************************************************

Line 13657: DELETE FROM IBC_ASSOCIATIONS WHERE CONTENT_ITEM_ID = l_citem_id;

13653: -- Delete from Version Labels
13654: DELETE FROM IBC_CITEM_VERSION_LABELS WHERE CONTENT_ITEM_ID = l_citem_id;
13655:
13656: -- Delete from Associations
13657: DELETE FROM IBC_ASSOCIATIONS WHERE CONTENT_ITEM_ID = l_citem_id;
13658:
13659: --***************************************************
13660: --************ADDING TO AUDIT LOG********************
13661: --***************************************************