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 1003: 'FROM ibe_ct_relation_rules ' ||

999: BEGIN
1000: -- 1. Where Category p_category_id is origin
1001: --09/01/12 AMAHESHW Bug 16078175 Ignore AUTOPLACEMENT relationship during Item_Category_Inserted proc
1002: OPEN l_rel_rule_csr FOR 'SELECT relation_type_code, relation_rule_id, dest_object_type, dest_object_id ' ||
1003: 'FROM ibe_ct_relation_rules ' ||
1004: 'WHERE origin_object_type = ''C'' ' ||
1005: 'AND origin_object_id = :category_id ' ||
1006: 'AND relation_type_code <> ''AUTOPLACEMENT'' '
1007: USING p_category_id;

Line 1036: 'FROM ibe_ct_relation_rules ' ||

1032:
1033: -- 2. Where Category p_category_id is destination
1034: --09/01/12 AMAHESHW Bug 16078175 Ignore AUTOPLACEMENT relationship during Item_Category_Inserted proc
1035: OPEN l_rel_rule_csr FOR 'SELECT relation_type_code, relation_rule_id, origin_object_type, origin_object_id ' ||
1036: 'FROM ibe_ct_relation_rules ' ||
1037: 'WHERE dest_object_type = ''C'' ' ||
1038: 'AND dest_object_id = :category_id ' ||
1039: 'AND relation_type_code <> ''AUTOPLACEMENT'' '
1040: USING p_category_id;

Line 1084: 'FROM ibe_ct_relation_rules ' ||

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

Line 1116: 'FROM ibe_ct_relation_rules ' ||

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

Line 1162: 'FROM ibe_ct_relation_rules ' ||

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

Line 1194: 'FROM ibe_ct_relation_rules ' ||

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

Line 1241: 'FROM ibe_ct_relation_rules ' ||

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

Line 1274: 'FROM ibe_ct_relation_rules ' ||

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

Line 1313: DELETE IBE_CT_RELATION_RULES

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

Line 1319: DELETE IBE_CT_RELATION_RULES

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

Line 1330: DELETE IBE_CT_RELATION_RULES

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

Line 1336: DELETE IBE_CT_RELATION_RULES

1332: AND origin_object_id = p_section_id;
1333:
1334: -- 2. Delete all the rules where dest_object_type is Section
1335: -- and dest_object_id is p_section_id
1336: DELETE IBE_CT_RELATION_RULES
1337: WHERE dest_object_type = 'S'
1338: AND dest_object_id = p_section_id;
1339: END Section_Deleted;
1340:

Line 1358: FROM ibe_ct_relation_rules

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

Line 1365: FROM ibe_ct_relation_rules

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