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_CAT_SCHEMA_UPLOAD_PVT dependencies on ICX_CAT_BROWSE_TREES

Line 676: FROM icx_cat_browse_trees browse, icx_cat_categories_tl cat

672:
673: CURSOR category_children_csr
674: IS
675: SELECT browse.child_category_id, cat.type, count(*)
676: FROM icx_cat_browse_trees browse, icx_cat_categories_tl cat
677: WHERE browse.child_category_id IN
678: (SELECT child_category_id
679: FROM icx_cat_browse_trees
680: WHERE parent_category_id = p_category_id)

Line 679: FROM icx_cat_browse_trees

675: SELECT browse.child_category_id, cat.type, count(*)
676: FROM icx_cat_browse_trees browse, icx_cat_categories_tl cat
677: WHERE browse.child_category_id IN
678: (SELECT child_category_id
679: FROM icx_cat_browse_trees
680: WHERE parent_category_id = p_category_id)
681: AND browse.child_category_id = cat.rt_category_id
682: AND language = p_language
683: GROUP BY browse.child_category_id, cat.type;

Line 724: DELETE FROM icx_cat_browse_trees

720: DELETE FROM icx_por_category_data_sources
721: WHERE rt_category_id = p_category_id;
722:
723: -- now delete the link from this category to its parents
724: DELETE FROM icx_cat_browse_trees
725: WHERE child_category_id = p_category_id;
726:
727: -- bulk fetch all children of this category
728: OPEN category_children_csr;

Line 735: DELETE FROM icx_cat_browse_trees

731: CLOSE category_children_csr;
732:
733: -- now delete all the links from this category to its children
734: FORALL i in 1..l_child_cat_table.COUNT
735: DELETE FROM icx_cat_browse_trees
736: WHERE parent_category_id = p_category_id
737: AND child_category_id = l_child_cat_table(i);
738:
739: -- now for all those children of this category that we are deleting

Line 745: INSERT INTO icx_cat_browse_trees

741: -- i.e. parent count is 1 then we put the child under the root
742: -- xxx why are we using 0 instead of ids? for this
743: -- we were doing this in 11.5.10 now changed
744: FORALL i in 1..l_child_cat_table.COUNT
745: INSERT INTO icx_cat_browse_trees
746: (parent_category_id, child_category_id, created_by, creation_date,
747: last_updated_by, last_update_date, last_update_login, request_id,
748: program_id, program_application_id, program_login_id)
749: SELECT 0, l_child_cat_table(i), p_user_id, sysdate, p_user_id, sysdate, p_login_id, p_request_id,

Line 1191: INSERT INTO icx_cat_browse_trees(parent_category_id, child_category_id,

1187: l_err_loc := 120;
1188:
1189:
1190: -- now we insert the relationship, if it does not already exist
1191: INSERT INTO icx_cat_browse_trees(parent_category_id, child_category_id,
1192: created_by, creation_date, last_updated_by, last_update_date, last_update_login,
1193: request_id, program_id, program_application_id, program_login_id)
1194: SELECT p_parent_id, p_child_id, p_user_id, sysdate, p_user_id, sysdate, p_login_id,
1195: p_request_id, fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id

Line 1198: FROM icx_cat_browse_trees

1194: SELECT p_parent_id, p_child_id, p_user_id, sysdate, p_user_id, sysdate, p_login_id,
1195: p_request_id, fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id
1196: FROM dual
1197: WHERE NOT EXISTS (SELECT 1
1198: FROM icx_cat_browse_trees
1199: WHERE parent_category_id = p_parent_id
1200: AND child_category_id = p_child_id);
1201:
1202: l_err_loc := 130;

Line 1209: DELETE FROM icx_cat_browse_trees

1205:
1206: l_err_loc := 140;
1207: -- if parent is not root we need to do more stuff
1208: -- first we remove any link from the child to root if it exists
1209: DELETE FROM icx_cat_browse_trees
1210: WHERE parent_category_id = 0
1211: AND child_category_id = p_child_id;
1212:
1213: l_err_loc := 150;

Line 1217: INSERT INTO icx_cat_browse_trees(parent_category_id, child_category_id,

1213: l_err_loc := 150;
1214:
1215: -- if the parent is does not have a parent
1216: -- then we need to attach it to the root
1217: INSERT INTO icx_cat_browse_trees(parent_category_id, child_category_id,
1218: created_by, creation_date, last_updated_by, last_update_date, last_update_login,
1219: request_id, program_id, program_application_id, program_login_id)
1220: SELECT 0, p_parent_id, p_user_id, sysdate, p_user_id, sysdate, p_login_id,
1221: p_request_id, fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id

Line 1224: FROM icx_cat_browse_trees

1220: SELECT 0, p_parent_id, p_user_id, sysdate, p_user_id, sysdate, p_login_id,
1221: p_request_id, fnd_global.conc_program_id, fnd_global.prog_appl_id, fnd_global.conc_login_id
1222: FROM dual
1223: WHERE NOT EXISTS (SELECT 1
1224: FROM icx_cat_browse_trees
1225: WHERE child_category_id = p_parent_id);
1226:
1227: l_err_loc := 160;
1228:

Line 1282: DELETE FROM icx_cat_browse_trees

1278: -- for sanity only proceed if parent is root or parent is of type 1
1279: IF (p_parent_id = 0 OR l_type = 1) THEN
1280:
1281: l_err_loc := 120;
1282: DELETE FROM icx_cat_browse_trees
1283: WHERE parent_category_id = p_parent_id
1284: AND child_category_id = p_child_id;
1285:
1286: l_err_loc := 130;

Line 1574: FROM icx_cat_browse_trees

1570:
1571: -- now we check to see if this relationship will add a cycle
1572: SELECT COUNT(*)
1573: INTO l_count
1574: FROM icx_cat_browse_trees
1575: WHERE child_category_id = x_parent_id
1576: START WITH parent_category_id = x_child_id
1577: CONNECT BY NOCYCLE PRIOR child_category_id = parent_category_id;
1578:

Line 1605: WHERE EXISTS (SELECT 1 FROM icx_cat_browse_trees

1601:
1602: BEGIN
1603: SELECT 1 INTO l_count
1604: FROM dual
1605: WHERE EXISTS (SELECT 1 FROM icx_cat_browse_trees
1606: WHERE parent_category_id = x_parent_id
1607: AND child_category_id = x_child_id);
1608:
1609: l_err_loc := 570;