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.IBE_PROD_RELATION_PVT dependencies on IBE_CT_RELATION_RULES

Line 531: IBE_UTIL.debug('Deleting rows in IBE_CT_RELATION_RULES.');

527:
528: END LOOP;
529:
530: IF (l_debug = 'Y') THEN
531: IBE_UTIL.debug('Deleting rows in IBE_CT_RELATION_RULES.');
532: END IF;
533: FORALL i IN p_rel_type_code_tbl.FIRST..p_rel_type_code_tbl.LAST
534: DELETE
535: FROM ibe_ct_relation_rules

Line 535: FROM ibe_ct_relation_rules

531: IBE_UTIL.debug('Deleting rows in IBE_CT_RELATION_RULES.');
532: END IF;
533: FORALL i IN p_rel_type_code_tbl.FIRST..p_rel_type_code_tbl.LAST
534: DELETE
535: FROM ibe_ct_relation_rules
536: WHERE relation_type_code = p_rel_type_code_tbl(i);
537:
538: IF (l_debug = 'Y') THEN
539: IBE_UTIL.debug('Deleting rows in IBE_CT_RELATED_ITEMS.');

Line 1002: 'FROM ibe_ct_relation_rules ' ||

998: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;
999: BEGIN
1000: -- 1. Where Category p_category_id is origin
1001: OPEN l_rel_rule_csr FOR 'SELECT relation_type_code, relation_rule_id, dest_object_type, dest_object_id ' ||
1002: 'FROM ibe_ct_relation_rules ' ||
1003: 'WHERE origin_object_type = ''C'' ' ||
1004: 'AND origin_object_id = :category_id '
1005: USING p_category_id;
1006:

Line 1033: 'FROM ibe_ct_relation_rules ' ||

1029: CLOSE l_rel_rule_csr;
1030:
1031: -- 2. Where Category p_category_id is destination
1032: OPEN l_rel_rule_csr FOR 'SELECT relation_type_code, relation_rule_id, origin_object_type, origin_object_id ' ||
1033: 'FROM ibe_ct_relation_rules ' ||
1034: 'WHERE dest_object_type = ''C'' ' ||
1035: 'AND dest_object_id = :category_id '
1036: USING p_category_id;
1037:

Line 1080: 'FROM ibe_ct_relation_rules ' ||

1076: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;
1077: BEGIN
1078: -- 1. Where Section p_section_id is origin
1079: OPEN l_rel_rule_csr FOR 'SELECT relation_type_code, relation_rule_id, dest_object_type, dest_object_id ' ||
1080: 'FROM ibe_ct_relation_rules ' ||
1081: 'WHERE origin_object_type = ''S'' ' ||
1082: 'AND origin_object_id = :section_id ' ||
1083: 'AND relation_type_code <> ''AUTOPLACEMENT'' '
1084: USING p_section_id;

Line 1112: 'FROM ibe_ct_relation_rules ' ||

1108: CLOSE l_rel_rule_csr;
1109:
1110: -- 2. Where Section p_section_id is destination
1111: OPEN l_rel_rule_csr FOR 'SELECT relation_type_code, relation_rule_id, origin_object_type, origin_object_id ' ||
1112: 'FROM ibe_ct_relation_rules ' ||
1113: 'WHERE dest_object_type = ''S'' ' ||
1114: 'AND dest_object_id = :section_id '
1115: USING p_section_id;
1116:

Line 1158: 'FROM ibe_ct_relation_rules ' ||

1154: -- 1. Work on the rules where origin_type is Category
1155: -- origin_object_id is p_category_id
1156: OPEN l_rel_rule_csr FOR 'SELECT relation_type_code, ' ||
1157: 'relation_rule_id ' ||
1158: 'FROM ibe_ct_relation_rules ' ||
1159: 'WHERE origin_object_type = ''C'' ' ||
1160: 'AND origin_object_id = :category_id '
1161: USING p_category_id;
1162: LOOP

Line 1190: 'FROM ibe_ct_relation_rules ' ||

1186: -- 2. Work on the rules where dest_type is Category
1187: -- dest_object_id is p_category_id
1188: OPEN l_rel_rule_csr FOR 'SELECT relation_type_code, ' ||
1189: 'relation_rule_id ' ||
1190: 'FROM ibe_ct_relation_rules ' ||
1191: 'WHERE dest_object_type = ''C'' ' ||
1192: 'AND dest_object_id = :category_id '
1193: USING p_category_id;
1194:

Line 1237: 'FROM ibe_ct_relation_rules ' ||

1233: -- 1. Work on the rules where origin_type is Section
1234: -- origin_object_id is p_section_id
1235: OPEN l_rel_rule_csr FOR 'SELECT relation_type_code, '||
1236: 'relation_rule_id ' ||
1237: 'FROM ibe_ct_relation_rules ' ||
1238: 'WHERE origin_object_type = ''S'' ' ||
1239: 'AND origin_object_id = :section_id ' ||
1240: 'AND relation_type_code <> ''AUTOPLACEMENT'' '
1241: USING p_section_id;

Line 1270: 'FROM ibe_ct_relation_rules ' ||

1266: -- 2. Work on the rules where dest_type is Section
1267: -- dest_object_id is p_section_id
1268: OPEN l_rel_rule_csr FOR 'SELECT relation_type_code, ' ||
1269: 'relation_rule_id ' ||
1270: 'FROM ibe_ct_relation_rules ' ||
1271: 'WHERE dest_object_type = ''S'' ' ||
1272: 'AND dest_object_id = :section_id '
1273: USING p_section_id;
1274:

Line 1309: DELETE IBE_CT_RELATION_RULES

1305: IS
1306: BEGIN
1307: -- 1. Delete all the rules where origin_object_type is Category
1308: -- and origin_object_id is p_section_id
1309: DELETE IBE_CT_RELATION_RULES
1310: WHERE origin_object_type = 'C'
1311: AND origin_object_id = p_category_id;
1312:
1313: -- 2. Delete all the rules where dest_object_type is Category

Line 1315: DELETE IBE_CT_RELATION_RULES

1311: AND origin_object_id = p_category_id;
1312:
1313: -- 2. Delete all the rules where dest_object_type is Category
1314: -- and dest_object_id is p_section_id
1315: DELETE IBE_CT_RELATION_RULES
1316: WHERE dest_object_type = 'C'
1317: AND dest_object_id = p_category_id;
1318: END Category_Deleted;
1319:

Line 1326: DELETE IBE_CT_RELATION_RULES

1322: IS
1323: BEGIN
1324: -- 1. Delete all the rules where origin_object_type is Section
1325: -- and origin_object_id is p_section_id
1326: DELETE IBE_CT_RELATION_RULES
1327: WHERE origin_object_type = 'S'
1328: AND origin_object_id = p_section_id;
1329:
1330: -- 2. Delete all the rules where dest_object_type is Section

Line 1332: DELETE IBE_CT_RELATION_RULES

1328: AND origin_object_id = p_section_id;
1329:
1330: -- 2. Delete all the rules where dest_object_type is Section
1331: -- and dest_object_id is p_section_id
1332: DELETE IBE_CT_RELATION_RULES
1333: WHERE dest_object_type = 'S'
1334: AND dest_object_id = p_section_id;
1335: END Section_Deleted;
1336:

Line 1354: FROM ibe_ct_relation_rules

1350: BEGIN
1351: -- 1. Remove all the rules that have the deleted item
1352: -- as an origin object
1353: DELETE
1354: FROM ibe_ct_relation_rules
1355: WHERE origin_object_type = 'I'
1356: AND origin_object_id = p_inventory_item_id;
1357:
1358: -- 2. Remove all the rules that have the deleted item

Line 1361: FROM ibe_ct_relation_rules

1357:
1358: -- 2. Remove all the rules that have the deleted item
1359: -- as a destination object
1360: DELETE
1361: FROM ibe_ct_relation_rules
1362: WHERE dest_object_type = 'I'
1363: AND dest_object_id = p_inventory_item_id;
1364:
1365: -- 3. Remove all the rows in Related Items table