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_CONTENT_TYPES_B

Line 849: temp IBC_CONTENT_TYPES_B.content_type_code%TYPE;

845: ibc_content_items
846: WHERE
847: content_item_id = f_content_item_id;
848:
849: temp IBC_CONTENT_TYPES_B.content_type_code%TYPE;
850: BEGIN
851: --DBMS_OUTPUT.put_line('----- getContentType -----');
852: OPEN c_ctype;
853: FETCH c_ctype INTO temp;

Line 888: temp IBC_CONTENT_TYPES_B.content_type_code%TYPE;

884: WHERE
885: ibc_citem_versions_b.content_item_id = ibc_content_items.content_item_id
886: AND
887: ibc_citem_versions_b.citem_version_id = f_citem_ver_id;
888: temp IBC_CONTENT_TYPES_B.content_type_code%TYPE;
889: BEGIN
890: --DBMS_OUTPUT.put_line('----- getContentTypeV -----');
891: OPEN c_ctypev;
892: FETCH c_ctypev INTO temp;

Line 2485: ctype_code IBC_CONTENT_TYPES_B.content_type_code%TYPE; -- content type code

2481: ,x_return_status OUT NOCOPY VARCHAR2
2482: )
2483: IS
2484: content_item_id NUMBER; --content item id
2485: ctype_code IBC_CONTENT_TYPES_B.content_type_code%TYPE; -- content type code
2486: citem_name IBC_CITEM_VERSIONS_TL.content_item_name%TYPE; -- content item name
2487: citem_desc IBC_CITEM_VERSIONS_TL.description%TYPE; -- content item description
2488: attach_file_id IBC_CITEM_VERSIONS_TL.attachment_file_id%TYPE;
2489: temp_bundle CLOB; -- temporary clob to hold text information while creating

Line 4048: ctype_code IBC_CONTENT_TYPES_B.content_type_code%TYPE;

4044: l_api_name CONSTANT VARCHAR2(30) := 'change_status';--|**|
4045: l_api_version_number CONSTANT NUMBER := G_API_VERSION_DEFAULT; --|**|
4046: --******************* END REQUIRED VARIABLES ***************************
4047: content_item_id NUMBER;
4048: ctype_code IBC_CONTENT_TYPES_B.content_type_code%TYPE;
4049: dir_id NUMBER;
4050: BEGIN
4051: --DBMS_OUTPUT.put_line('----- ' || l_api_name || ' -----');
4052: --******************* BEGIN REQUIRED AREA ******************************

Line 5188: ctype_code IBC_CONTENT_TYPES_B.content_type_code%TYPE;

5184: l_api_version_number CONSTANT NUMBER := G_API_VERSION_DEFAULT; --|**|
5185: --******************* END REQUIRED VARIABLES ***************************
5186: temp NUMBER;
5187: content_item_id NUMBER;
5188: ctype_code IBC_CONTENT_TYPES_B.content_type_code%TYPE;
5189: dir_id NUMBER;
5190: BEGIN
5191: --DBMS_OUTPUT.put_line('----- ' || l_api_name || ' -----');
5192: --******************* BEGIN REQUIRED AREA ******************************

Line 5825: ctype_code IBC_CONTENT_TYPES_B.content_type_code%TYPE;

5821: --******************* END REQUIRED VARIABLES ***************************
5822:
5823: attribute_fid NUMBER; --variable to returned attribute bundle id
5824: return_status CHAR(1); -- variable to check from returning procedures
5825: ctype_code IBC_CONTENT_TYPES_B.content_type_code%TYPE;
5826: content_item_id NUMBER;
5827: BEGIN
5828: --DBMS_OUTPUT.put_line('----- ' || l_api_name || ' -----');
5829: --******************* BEGIN REQUIRED AREA ******************************

Line 8055: ctype_code IBC_CONTENT_TYPES_B.content_type_code%TYPE;

8051: insert_data CHAR(1);
8052: counter NUMBER := 1;
8053: sort_order NUMBER;
8054: content_item_id NUMBER;
8055: ctype_code IBC_CONTENT_TYPES_B.content_type_code%TYPE;
8056: dir_id NUMBER;
8057: BEGIN
8058: --DBMS_OUTPUT.put_line('----- ' || l_api_name || ' -----');
8059: SAVEPOINT svpt_insert_components;

Line 9430: ctype_code IBC_CONTENT_TYPES_B.content_type_code%TYPE; -- content type code

9426: --******************* BEGIN REQUIRED VARIABLES *************************
9427: l_api_name CONSTANT VARCHAR2(30) := 'set_citem_att_bundle'; --|**|
9428: l_api_version_number CONSTANT NUMBER := G_API_VERSION_DEFAULT; --|**|
9429: --******************* END REQUIRED VARIABLES ***************************
9430: ctype_code IBC_CONTENT_TYPES_B.content_type_code%TYPE; -- content type code
9431: bundle_text CLOB; -- tempory blob
9432: file_id NUMBER; -- pointer to actual FND_LOB location
9433: old_file_id NUMBER;
9434: return_status CHAR(1);

Line 13811: ctype_code IBC_CONTENT_TYPES_B.content_type_code%TYPE;

13807: l_api_name CONSTANT VARCHAR2(30) := 'Change_Translation_Status'; --|**|
13808: l_api_version_number CONSTANT NUMBER := G_API_VERSION_DEFAULT; --|**|
13809: --******************* END REQUIRED VARIABLES ***************************
13810: content_item_id NUMBER;
13811: ctype_code IBC_CONTENT_TYPES_B.content_type_code%TYPE;
13812: dir_id NUMBER;
13813: l_description VARCHAR2(50);
13814: l_activity VARCHAR2(50);
13815: