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.BOMPKMUD dependencies on BOM_LISTS

Line 81: -- Bug 4106826 - Added variable l_bom_lists_count for debugging

77: G_STRUCT_SER_EFF CONSTANT NUMBER(1) := 3;
78: G_STRUCT_REV_EFF CONSTANT NUMBER(1) := 4;
79:
80: --
81: -- Bug 4106826 - Added variable l_bom_lists_count for debugging
82: --
83: l_bom_lists_count NUMBER;
84:
85:

Line 83: l_bom_lists_count NUMBER;

79:
80: --
81: -- Bug 4106826 - Added variable l_bom_lists_count for debugging
82: --
83: l_bom_lists_count NUMBER;
84:
85:
86: -- ERES change begins
87: PROCEDURE Raise_ECO_Create_Event( p_organization_id IN NUMBER

Line 282: FROM bom_lists

278: FUNCTION cnt(p_list_id NUMBER)
279: RETURN NUMBER IS
280: CURSOR lc_cnt IS
281: SELECT COUNT(*)
282: FROM bom_lists
283: WHERE sequence_id = p_list_id;
284: l_cnt NUMBER;
285: BEGIN
286: OPEN lc_cnt;

Line 301: -- List - Sequence id of list in BOM_LISTS.

297: -- DESCRIPTION
298: -- Checks if component exists with attributes matching criteria in
299: -- component interface table.
300: -- REQUIRES
301: -- List - Sequence id of list in BOM_LISTS.
302: -- ECO - Engineering change order number of Mass Change Order.
303: -- Org Id - Organization id of Mass Change Order.
304: -- MODIFIES
305: -- Error Message - PL/SQL error.

Line 313: p_list_id IN bom_lists.sequence_id%TYPE,

309: --
310: -- EXAMPLE
311: --
312: PROCEDURE Match_Attributes(
313: p_list_id IN bom_lists.sequence_id%TYPE,
314: p_eco IN eng_revised_items_interface.change_notice%TYPE,
315: p_org_id IN eng_revised_items_interface.organization_id%TYPE,
316: x_error_message IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
317: IS

Line 325: DELETE FROM bom_lists l

321:
322: -- Bug 4216428
323:
324: FND_FILE.PUT_LINE(FND_FILE.LOG,'Delete rev effective structures from list');
325: DELETE FROM bom_lists l
326: WHERE l.sequence_id = p_list_id
327: AND EXISTS (
328: SELECT NULL
329: FROM bom_bill_of_materials b

Line 339: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;

335: --
336: -- Bug 4106826
337: --
338: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entered Match Attributes');
339: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
340: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS before delete st in Match attributes='||
341: to_char(l_bom_lists_count));
342: -- end Bug 4106826
343:

Line 340: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS before delete st in Match attributes='||

336: -- Bug 4106826
337: --
338: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entered Match Attributes');
339: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
340: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS before delete st in Match attributes='||
341: to_char(l_bom_lists_count));
342: -- end Bug 4106826
343:
344: -- Removed NVL and added AND/OR condition on Alternate_bom_desigantor to improve performance

Line 341: to_char(l_bom_lists_count));

337: --
338: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entered Match Attributes');
339: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
340: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS before delete st in Match attributes='||
341: to_char(l_bom_lists_count));
342: -- end Bug 4106826
343:
344: -- Removed NVL and added AND/OR condition on Alternate_bom_desigantor to improve performance
345: DELETE FROM bom_lists l

Line 345: DELETE FROM bom_lists l

341: to_char(l_bom_lists_count));
342: -- end Bug 4106826
343:
344: -- Removed NVL and added AND/OR condition on Alternate_bom_desigantor to improve performance
345: DELETE FROM bom_lists l
346: WHERE l.sequence_id = p_list_id
347: AND EXISTS (
348: SELECT NULL
349: FROM

Line 461: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;

457: );
458:
459: x_error_message := NULL;
460: COMMIT;
461: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
462: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete st in match_attribute='||
463: to_char(l_bom_lists_count));
464:
465: EXCEPTION

Line 462: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete st in match_attribute='||

458:
459: x_error_message := NULL;
460: COMMIT;
461: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
462: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete st in match_attribute='||
463: to_char(l_bom_lists_count));
464:
465: EXCEPTION
466: WHEN others THEN

Line 463: to_char(l_bom_lists_count));

459: x_error_message := NULL;
460: COMMIT;
461: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
462: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete st in match_attribute='||
463: to_char(l_bom_lists_count));
464:
465: EXCEPTION
466: WHEN others THEN
467: ROLLBACK TO begin_match;

Line 479: -- List id - Sequence id of list in BOM_LISTS.

475: -- DESCRIPTION
476: -- Checks attributes of component item with those of revised item to see
477: -- if they are compatible.
478: -- REQUIRES
479: -- List id - Sequence id of list in BOM_LISTS.
480: -- ECO - Engineering Change Order number of Mass Update.
481: -- Organization - Organization id of revised item.
482: -- MODIFIES
483: -- Error Message - PL/SQL error.

Line 492: p_list_id IN bom_lists.sequence_id%TYPE,

488: -- EXAMPLE
489: --
490:
491: PROCEDURE Check_Combination(
492: p_list_id IN bom_lists.sequence_id%TYPE,
493: p_eco IN eng_revised_items_interface.change_notice%TYPE,
494: p_organization IN eng_revised_items_interface.organization_id%TYPE,
495: x_error_message IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
496: IS

Line 531: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;

527: -- Components Flag is set to No.
528: --
529: -- - Component Item's ATP Flag or ATP Components Flag is set to Yes.
530: --
531: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
532: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS before delete stmt Check_Combination ='||
533: to_char(l_bom_lists_count));
534: DELETE FROM bom_lists l
535: WHERE l.sequence_id = p_list_id

Line 532: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS before delete stmt Check_Combination ='||

528: --
529: -- - Component Item's ATP Flag or ATP Components Flag is set to Yes.
530: --
531: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
532: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS before delete stmt Check_Combination ='||
533: to_char(l_bom_lists_count));
534: DELETE FROM bom_lists l
535: WHERE l.sequence_id = p_list_id
536: AND EXISTS (

Line 533: to_char(l_bom_lists_count));

529: -- - Component Item's ATP Flag or ATP Components Flag is set to Yes.
530: --
531: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
532: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS before delete stmt Check_Combination ='||
533: to_char(l_bom_lists_count));
534: DELETE FROM bom_lists l
535: WHERE l.sequence_id = p_list_id
536: AND EXISTS (
537: SELECT NULL

Line 534: DELETE FROM bom_lists l

530: --
531: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
532: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS before delete stmt Check_Combination ='||
533: to_char(l_bom_lists_count));
534: DELETE FROM bom_lists l
535: WHERE l.sequence_id = p_list_id
536: AND EXISTS (
537: SELECT NULL
538: FROM mtl_system_items_b ri,

Line 579: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;

575: AND c.revised_item_sequence_id = r.revised_item_sequence_id
576: AND r.change_notice = p_eco
577: AND r.organization_id = p_organization);
578:
579: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
580: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt 1 Check_Combination ='||
581: to_char(l_bom_lists_count));
582:
583: --

Line 580: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt 1 Check_Combination ='||

576: AND r.change_notice = p_eco
577: AND r.organization_id = p_organization);
578:
579: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
580: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt 1 Check_Combination ='||
581: to_char(l_bom_lists_count));
582:
583: --
584: -- Do not create revised items if:

Line 581: to_char(l_bom_lists_count));

577: AND r.organization_id = p_organization);
578:
579: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
580: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt 1 Check_Combination ='||
581: to_char(l_bom_lists_count));
582:
583: --
584: -- Do not create revised items if:
585: --

Line 594: DELETE FROM bom_lists l

590: -- Component is mandatory and is not "Consume or Derive"
591: -- - Shippable = Yes and Revised Items is not pick-to-order
592: --
593:
594: DELETE FROM bom_lists l
595: WHERE l.sequence_id = p_list_id
596: AND EXISTS (
597: SELECT NULL
598: FROM mtl_system_items_b i,

Line 621: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;

617: AND c.acd_type = action_add
618: AND c.revised_item_sequence_id = r.revised_item_sequence_id
619: AND r.change_notice = p_eco
620: AND r.organization_id = p_organization);
621: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
622: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt 2 in Check_Combination='||
623: to_char(l_bom_lists_count));
624:
625: DELETE FROM bom_lists bl

Line 622: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt 2 in Check_Combination='||

618: AND c.revised_item_sequence_id = r.revised_item_sequence_id
619: AND r.change_notice = p_eco
620: AND r.organization_id = p_organization);
621: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
622: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt 2 in Check_Combination='||
623: to_char(l_bom_lists_count));
624:
625: DELETE FROM bom_lists bl
626: WHERE bl.sequence_id = p_list_id

Line 623: to_char(l_bom_lists_count));

619: AND r.change_notice = p_eco
620: AND r.organization_id = p_organization);
621: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
622: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt 2 in Check_Combination='||
623: to_char(l_bom_lists_count));
624:
625: DELETE FROM bom_lists bl
626: WHERE bl.sequence_id = p_list_id
627: AND EXISTS (

Line 625: DELETE FROM bom_lists bl

621: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
622: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt 2 in Check_Combination='||
623: to_char(l_bom_lists_count));
624:
625: DELETE FROM bom_lists bl
626: WHERE bl.sequence_id = p_list_id
627: AND EXISTS (
628: SELECT NULL
629: FROM mtl_system_items_b ri_itm, -- revised item

Line 733: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;

729: AND ri_itm.effectivity_control = unit_control)
730: OR
731: ri_itm.effectivity_control = date_control)
732: );
733: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
734: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt3 in Check_Combination ='||
735: to_char(l_bom_lists_count));
736: --
737: -- Do not create revised items if:

Line 734: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt3 in Check_Combination ='||

730: OR
731: ri_itm.effectivity_control = date_control)
732: );
733: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
734: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt3 in Check_Combination ='||
735: to_char(l_bom_lists_count));
736: --
737: -- Do not create revised items if:
738: --

Line 735: to_char(l_bom_lists_count));

731: ri_itm.effectivity_control = date_control)
732: );
733: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
734: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt3 in Check_Combination ='||
735: to_char(l_bom_lists_count));
736: --
737: -- Do not create revised items if:
738: --
739: -- - Operation Sequence Number does not exist in routing (except 1).

Line 742: DELETE FROM bom_lists l

738: --
739: -- - Operation Sequence Number does not exist in routing (except 1).
740: --
741:
742: DELETE FROM bom_lists l
743: WHERE l.sequence_id = p_list_id
744: AND EXISTS (
745: SELECT NULL
746: FROM bom_inventory_comps_interface ci,

Line 784: DELETE FROM bom_lists l

780: --
781: -- If use up is specified, only bills for the use up item or bills
782: -- whose components include the use up item are allowed.
783: --
784: DELETE FROM bom_lists l
785: WHERE l.sequence_id = p_list_id
786: AND EXISTS (
787: SELECT NULL
788: FROM eng_revised_items_interface ri,

Line 823: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;

819: );
820:
821: x_error_message := NULL;
822: COMMIT;
823: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
824: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt 4 in Check_Combination ='||
825: to_char(l_bom_lists_count));
826: EXCEPTION
827: WHEN others THEN

Line 824: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt 4 in Check_Combination ='||

820:
821: x_error_message := NULL;
822: COMMIT;
823: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
824: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt 4 in Check_Combination ='||
825: to_char(l_bom_lists_count));
826: EXCEPTION
827: WHEN others THEN
828: ROLLBACK TO begin_combo;

Line 825: to_char(l_bom_lists_count));

821: x_error_message := NULL;
822: COMMIT;
823: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
824: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt 4 in Check_Combination ='||
825: to_char(l_bom_lists_count));
826: EXCEPTION
827: WHEN others THEN
828: ROLLBACK TO begin_combo;
829: x_error_message := SUBSTRB(sqlerrm, 1, 150);

Line 839: -- List - Sequence id of list in BOM_LISTS.

835: -- Check_Component
836: -- DESCRIPTION
837: -- Checks if listed items has valid components.
838: -- REQUIRES
839: -- List - Sequence id of list in BOM_LISTS.
840: -- Organization - Organization id of Bill to be checked.
841: -- Change Order - ECO number of Mass Change Order.
842: -- MODIFIES
843: -- Error buffer - Message if PL/SQL error encountered.

Line 851: p_list_id IN bom_lists.sequence_id%TYPE,

847: --
848: -- EXAMPLE
849: --
850: PROCEDURE Check_Component(
851: p_list_id IN bom_lists.sequence_id%TYPE,
852: p_change_order IN eng_revised_items_interface.change_notice%TYPE,
853: p_organization IN eng_revised_items_interface.organization_id%TYPE,
854: x_error_buffer IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
855: IS

Line 874: DELETE FROM bom_lists bl

870:
871: --
872: -- Bills can not be components of itself.
873: --
874: DELETE FROM bom_lists bl
875: WHERE bl.sequence_id = p_list_id
876: AND EXISTS (
877: SELECT NULL
878: FROM bom_inventory_comps_interface c,

Line 888: DELETE FROM bom_lists l

884:
885: --
886: -- Duplicate adds
887: --
888: DELETE FROM bom_lists l
889: WHERE l.sequence_id = p_list_id
890: AND EXISTS (
891: SELECT NULL
892: FROM bom_inventory_components c,

Line 926: DELETE FROM bom_lists l

922: -- Duplicate adds check,
923: -- if action is replace and old comp_item_id!=new comp_item_id
924: -- Included for mass replace of components.
925: --
926: DELETE FROM bom_lists l
927: WHERE l.sequence_id = p_list_id
928: AND EXISTS (
929: SELECT /*+ ORDERED USE_NL (B C CI CIR RI CO RI_ITM) */ NULL
930: FROM bom_structures_b b,

Line 973: DELETE FROM bom_lists l

969:
970: --
971: -- Only manufacturing items can be added as components to manufacturing bills
972: --
973: DELETE FROM bom_lists l
974: WHERE l.sequence_id = p_list_id
975: AND EXISTS (
976: SELECT NULL
977: FROM mtl_system_items_b i,

Line 1002: DELETE FROM bom_lists l

998: -- Only manufacturing items can be added as components to manufacturing
999: -- bills, if action is replace and old comp_item_id!=new comp_item_id
1000: -- Included for mass replace of components.
1001: --
1002: DELETE FROM bom_lists l
1003: WHERE l.sequence_id = p_list_id
1004: AND EXISTS (
1005: SELECT NULL
1006: FROM mtl_system_items_b i,

Line 1035: DELETE FROM bom_lists l

1031:
1032: --
1033: -- Duplicate components deletes and changes
1034: --
1035: DELETE FROM bom_lists l
1036: WHERE l.sequence_id = p_list_id
1037: AND EXISTS (
1038: SELECT NULL
1039: FROM bom_components_b c,

Line 1075: DELETE FROM bom_lists l

1071: --
1072: -- Other organizations who use our bills as common bills must have the
1073: -- component items in their organization as well.
1074: --
1075: DELETE FROM bom_lists l
1076: WHERE l.sequence_id = p_list_id
1077: AND EXISTS (
1078: SELECT NULL
1079: FROM bom_bill_of_materials cb,

Line 1104: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;

1100: AND ri.organization_id = p_organization);
1101:
1102: COMMIT;
1103: x_error_buffer := NULL;
1104: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
1105: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt in Check_Component ='||
1106: to_char(l_bom_lists_count));
1107: EXCEPTION
1108: WHEN l_subroutine_error THEN

Line 1105: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt in Check_Component ='||

1101:
1102: COMMIT;
1103: x_error_buffer := NULL;
1104: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
1105: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt in Check_Component ='||
1106: to_char(l_bom_lists_count));
1107: EXCEPTION
1108: WHEN l_subroutine_error THEN
1109: x_error_buffer := l_internal_error;

Line 1106: to_char(l_bom_lists_count));

1102: COMMIT;
1103: x_error_buffer := NULL;
1104: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
1105: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt in Check_Component ='||
1106: to_char(l_bom_lists_count));
1107: EXCEPTION
1108: WHEN l_subroutine_error THEN
1109: x_error_buffer := l_internal_error;
1110: WHEN others THEN

Line 1120: -- Deletes from BOM_LISTS according to access permissions granted by the

1116: --
1117: -- NAME
1118: -- Restrict_List
1119: -- DESCRIPTION
1120: -- Deletes from BOM_LISTS according to access permissions granted by the
1121: -- profile options: planning item access, standard item access
1122: -- and model item access. Also culls out bills that would not
1123: -- qualify for a change order because it does not have
1124: -- components which match all the criteria specified in

Line 1130: -- List id - A sequence id used to identify the list in BOM_LISTS. This

1126: -- REQUIRES
1127: -- Model Item Access - Yes (1) or No (2).
1128: -- Planning Item Access - Yes (1) or No (2).
1129: -- Standard Item Access - Yes (1) or No (2).
1130: -- List id - A sequence id used to identify the list in BOM_LISTS. This
1131: -- may either be a session id or a number obtained from the
1132: -- database sequence, BOM_LISTS_S.
1133: -- Organization Id - Organization stored in ENG_CHANGES_INTERFACE.
1134: -- MODIFIES

Line 1132: -- database sequence, BOM_LISTS_S.

1128: -- Planning Item Access - Yes (1) or No (2).
1129: -- Standard Item Access - Yes (1) or No (2).
1130: -- List id - A sequence id used to identify the list in BOM_LISTS. This
1131: -- may either be a session id or a number obtained from the
1132: -- database sequence, BOM_LISTS_S.
1133: -- Organization Id - Organization stored in ENG_CHANGES_INTERFACE.
1134: -- MODIFIES
1135: -- Error message. If no error, returns NULL.
1136: -- RETURNS

Line 1162: DELETE FROM bom_lists l

1158:
1159: --
1160: -- Eliminate common bills
1161: --
1162: DELETE FROM bom_lists l
1163: WHERE l.sequence_id = p_list_id
1164: AND EXISTS (
1165: SELECT NULL
1166: FROM bom_bill_of_materials b

Line 1176: DELETE FROM bom_lists l

1172:
1173: --
1174: -- Eliminate Packaging BOMs
1175: --
1176: DELETE FROM bom_lists l
1177: WHERE l.sequence_id = p_list_id
1178: AND EXISTS (
1179: SELECT NULL
1180: FROM bom_bill_of_materials b

Line 1194: DELETE FROM bom_lists l

1190:
1191: --
1192: -- Eliminate Product Families
1193: --
1194: DELETE FROM bom_lists l
1195: WHERE l.sequence_id = p_list_id
1196: AND EXISTS (
1197: SELECT NULL
1198: FROM mtl_system_items_b msi

Line 1207: DELETE FROM bom_lists l

1203:
1204: --
1205: -- Check profile values for item access
1206: --
1207: DELETE FROM bom_lists l
1208: WHERE l.sequence_id = p_list_id
1209: AND EXISTS (
1210: SELECT NULL
1211: FROM mtl_system_items_b i

Line 1231: DELETE FROM bom_lists l

1227:
1228: --
1229: -- Check item type
1230: --
1231: DELETE FROM bom_lists l
1232: WHERE l.sequence_id = p_list_id
1233: AND EXISTS (
1234: SELECT NULL
1235: FROM eng_revised_items_interface r,

Line 1246: DELETE FROM bom_lists l

1242:
1243: --
1244: -- Check if configuration bills are specified
1245: --
1246: DELETE FROM bom_lists l
1247: WHERE l.sequence_id = p_list_id
1248: AND EXISTS (
1249: SELECT NULL
1250: FROM eng_revised_items_interface r,

Line 1258: -- delete from bom_lists those records that have Invalid or Obsolete item status codes

1254: AND i.inventory_item_id = l.assembly_item_id
1255: AND r.change_notice = p_change_order
1256: AND r.organization_id = p_organization);
1257:
1258: -- delete from bom_lists those records that have Invalid or Obsolete item status codes
1259: DELETE FROM bom_lists l
1260: WHERE l.sequence_id = p_list_id
1261: AND EXISTS (SELECT NULL
1262: FROM eng_revised_items_interface r,

Line 1259: DELETE FROM bom_lists l

1255: AND r.change_notice = p_change_order
1256: AND r.organization_id = p_organization);
1257:
1258: -- delete from bom_lists those records that have Invalid or Obsolete item status codes
1259: DELETE FROM bom_lists l
1260: WHERE l.sequence_id = p_list_id
1261: AND EXISTS (SELECT NULL
1262: FROM eng_revised_items_interface r,
1263: mtl_system_items_b i,

Line 1280: DELETE FROM bom_lists l

1276: --
1277: -- Check unit effectivity. This code may have to be removed/changed in
1278: -- the future once we start supporting unit effectivity for mass change.
1279: --
1280: DELETE FROM bom_lists l
1281: WHERE l.sequence_id = p_list_id
1282: AND EXISTS (
1283: SELECT NULL
1284: FROM mtl_system_items_b i

Line 1296: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;

1292: IF l_subroutine_error_msg IS NOT NULL THEN
1293: RAISE l_internal_error;
1294: END IF;
1295: x_error_message := NULL;
1296: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
1297: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt in Restrict_List='||
1298: to_char(l_bom_lists_count));
1299: EXCEPTION
1300: WHEN l_internal_error THEN

Line 1297: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt in Restrict_List='||

1293: RAISE l_internal_error;
1294: END IF;
1295: x_error_message := NULL;
1296: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
1297: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt in Restrict_List='||
1298: to_char(l_bom_lists_count));
1299: EXCEPTION
1300: WHEN l_internal_error THEN
1301: x_error_message := l_subroutine_error_msg;

Line 1298: to_char(l_bom_lists_count));

1294: END IF;
1295: x_error_message := NULL;
1296: select count(*) into l_bom_lists_count from bom_lists where sequence_id = p_list_id;
1297: FND_FILE.PUT_LINE(FND_FILE.LOG,' Records in BOM_LISTS after delete stmt in Restrict_List='||
1298: to_char(l_bom_lists_count));
1299: EXCEPTION
1300: WHEN l_internal_error THEN
1301: x_error_message := l_subroutine_error_msg;
1302: WHEN others THEN

Line 1429: CURSOR c_get_bom_list(p_list_id IN bom_lists.sequence_id%TYPE,

1425: -- Also added condition l.organization_id = p_org_id
1426: -- This is done to avoid FULL Table scan on Bom_bill_of_materials Table
1427: -- and thus reduce the Cost
1428: --
1429: CURSOR c_get_bom_list(p_list_id IN bom_lists.sequence_id%TYPE,
1430: p_org_id IN bom_lists.organization_id%TYPE) IS
1431: SELECT l.assembly_item_id,
1432: l.alternate_designator,
1433: b.bill_sequence_id,

Line 1430: p_org_id IN bom_lists.organization_id%TYPE) IS

1426: -- This is done to avoid FULL Table scan on Bom_bill_of_materials Table
1427: -- and thus reduce the Cost
1428: --
1429: CURSOR c_get_bom_list(p_list_id IN bom_lists.sequence_id%TYPE,
1430: p_org_id IN bom_lists.organization_id%TYPE) IS
1431: SELECT l.assembly_item_id,
1432: l.alternate_designator,
1433: b.bill_sequence_id,
1434: itm.effectivity_control,

Line 1445: FROM bom_lists l,

1441: ri.revised_item_sequence_id,
1442: ri.increment_rev,
1443: ri.use_up_plan_name,
1444: ri.from_end_item_unit_number
1445: FROM bom_lists l,
1446: eng_revised_items_interface ri,
1447: bom_bill_of_materials b,
1448: mtl_system_items_b itm
1449: WHERE

Line 2227: -- Added update statement here to update the org_id in bom_lists Table

2223: --The error message is set to null on successful completion
2224: error_message := 'A fatal error occurred while processing mass_update.';
2225:
2226: -- Bug 1807268
2227: -- Added update statement here to update the org_id in bom_lists Table
2228: --
2229: UPDATE bom_lists
2230: SET organization_id = org_id
2231: WHERE sequence_id = list_id;

Line 2229: UPDATE bom_lists

2225:
2226: -- Bug 1807268
2227: -- Added update statement here to update the org_id in bom_lists Table
2228: --
2229: UPDATE bom_lists
2230: SET organization_id = org_id
2231: WHERE sequence_id = list_id;
2232:
2233: Restrict_List(list_id,