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.ICX_POR_SCHEMA_UPLOAD dependencies on ICX_CAT_DELETED_ATTRIBUTES

Line 1168: --Bug#3027134 Added who columns in icx_cat_deleted_attributes

1164: ** Desc : Delete the local descriptor within a category.
1165: ** If no local descriptors for this category, the
1166: ** dynamic table and view will be dropped.
1167: **/
1168: --Bug#3027134 Added who columns in icx_cat_deleted_attributes
1169: --as part of ECM OA Rewrite
1170: --So add two parameters for user_id and login_id to delete_descriptors
1171: --to populate the who columns in icx_cat_deleted_attributes.
1172:

Line 1171: --to populate the who columns in icx_cat_deleted_attributes.

1167: **/
1168: --Bug#3027134 Added who columns in icx_cat_deleted_attributes
1169: --as part of ECM OA Rewrite
1170: --So add two parameters for user_id and login_id to delete_descriptors
1171: --to populate the who columns in icx_cat_deleted_attributes.
1172:
1173: PROCEDURE delete_descriptor (p_descriptor_id IN NUMBER,
1174: p_request_id IN NUMBER DEFAULT -1,
1175: p_user_id IN NUMBER,

Line 1244: --Bug#3027134 Added who columns in icx_cat_deleted_attributes

1240: xErrLoc := 800;
1241:
1242: -- populate the deleted_descriptors table so that the descriptor column
1243: -- values will be erased in the items_tlp/ext_items_tlp table later.
1244: --Bug#3027134 Added who columns in icx_cat_deleted_attributes
1245: --as part of ECM OA Rewrite
1246: --So populate the who columns in icx_cat_deleted_attributes.
1247: insert into icx_cat_deleted_attributes
1248: (rt_category_id, rt_descriptor_id, stored_in_table, stored_in_column,

Line 1246: --So populate the who columns in icx_cat_deleted_attributes.

1242: -- populate the deleted_descriptors table so that the descriptor column
1243: -- values will be erased in the items_tlp/ext_items_tlp table later.
1244: --Bug#3027134 Added who columns in icx_cat_deleted_attributes
1245: --as part of ECM OA Rewrite
1246: --So populate the who columns in icx_cat_deleted_attributes.
1247: insert into icx_cat_deleted_attributes
1248: (rt_category_id, rt_descriptor_id, stored_in_table, stored_in_column,
1249: last_update_login, last_updated_by, last_update_date, created_by,
1250: creation_date)

Line 1247: insert into icx_cat_deleted_attributes

1243: -- values will be erased in the items_tlp/ext_items_tlp table later.
1244: --Bug#3027134 Added who columns in icx_cat_deleted_attributes
1245: --as part of ECM OA Rewrite
1246: --So populate the who columns in icx_cat_deleted_attributes.
1247: insert into icx_cat_deleted_attributes
1248: (rt_category_id, rt_descriptor_id, stored_in_table, stored_in_column,
1249: last_update_login, last_updated_by, last_update_date, created_by,
1250: creation_date)
1251: values (xCategoryID, p_descriptor_id, xStoredInTable, xStoredInColumn,

Line 3005: --with rt_descriptor_id different in icx_cat_deleted_attributes.

3001: --Removed the rt_descriptor_id from the cursor and add a distinct
3002: --When descriptors are deleted from online, we add CR jobs which process
3003: --sync_deleted_descriptors, so there could be a scenario, when rt_category_id,
3004: --stored_in_table and stored_in_column are same
3005: --with rt_descriptor_id different in icx_cat_deleted_attributes.
3006: --In the above case without distinct, the sync_deleted_descriptors will
3007: --fail with exception 'ORA-00957:duplicate column name'
3008: CURSOR deleted_descriptors_csr IS
3009: SELECT distinct rt_category_id, stored_in_table, stored_in_column

Line 3010: from icx_cat_deleted_attributes order by stored_in_table, rt_category_id;

3006: --In the above case without distinct, the sync_deleted_descriptors will
3007: --fail with exception 'ORA-00957:duplicate column name'
3008: CURSOR deleted_descriptors_csr IS
3009: SELECT distinct rt_category_id, stored_in_table, stored_in_column
3010: from icx_cat_deleted_attributes order by stored_in_table, rt_category_id;
3011: vRtCategoryIds dbms_sql.number_table;
3012: --Bug#3072827 vRtDescriptorIds dbms_sql.number_table;
3013: vStoredInColumns dbms_sql.varchar2_table;
3014: vStoredInTables dbms_sql.varchar2_table;

Line 3144: v_sql := 'TRUNCATE TABLE ' || ICX_POR_EXT_UTL.getIcxSchema ||'.icx_cat_deleted_attributes';

3140:
3141: xErrLoc := 1400;
3142:
3143: -- do not hardcode "icx." get the schema name dynamically..
3144: v_sql := 'TRUNCATE TABLE ' || ICX_POR_EXT_UTL.getIcxSchema ||'.icx_cat_deleted_attributes';
3145: execute immediate v_sql;
3146:
3147: xErrLoc := 1500;
3148: