APPS.BOM_DELETE_ITEMS dependencies on BOM_DELETE_SUB_ENTITIES

Line 9: -- | Description : Populate BOM_DELETE_ENTITIES and BOM_DELETE_SUB_ENTITIES |

5: -- | All rights reserved. |
6: -- +==========================================================================+
7: -- | |
8: -- | File Name : BOMDELTB.pls |
9: -- | Description : Populate BOM_DELETE_ENTITIES and BOM_DELETE_SUB_ENTITIES |
10: -- | when called by BOMFDDEL (Item, BOM and Routing Delete Form |
11: -- | under the following conditions: |
12: -- | - called on return from Item Catalog Search |
13: -- | - Component or Routing Where Used request |

Line 107: -- Populate BOM_DELETE_ENTITIES and BOM_DELETE_SUB_ENTITIES

103: -- NAME
104: -- POPULATE_DELETE
105:
106: -- DESCRIPTION
107: -- Populate BOM_DELETE_ENTITIES and BOM_DELETE_SUB_ENTITIES
108:
109: -- REQUIRES
110: -- org_id: organization id
111: -- last_login_id

Line 467: INSERT INTO BOM_DELETE_SUB_ENTITIES(

463: SELECT NVL(BILL_SEQUENCE_ID, 0)
464: FROM BOM_DELETE_ENTITIES
465: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id));
466:
467: INSERT INTO BOM_DELETE_SUB_ENTITIES(
468: DELETE_ENTITY_SEQUENCE_ID,
469: COMPONENT_SEQUENCE_ID,
470: OPERATION_SEQ_NUM,
471: EFFECTIVITY_DATE,

Line 517: BOM_DELETE_SUB_ENTITIES BDSE,

513: AND expiration_date >= BIC.DISABLE_DATE
514: AND BIC.COMPONENT_SEQUENCE_ID NOT IN(
515: SELECT NVL(COMPONENT_SEQUENCE_ID, 0)
516: FROM
517: BOM_DELETE_SUB_ENTITIES BDSE,
518: BOM_DELETE_ENTITIES BDE
519: WHERE BDE.DELETE_GROUP_SEQUENCE_ID = delete_group_id
520: AND BDE.DELETE_ENTITY_SEQUENCE_ID = BDSE.DELETE_ENTITY_SEQUENCE_ID);
521:

Line 603: INSERT INTO BOM_DELETE_SUB_ENTITIES(

599: -- NOT NULL NULL DROP ROW
600: -- NULL NOT NULL RETAIN ROW
601: -- NULL NULL RETAIN ROW
602:
603: INSERT INTO BOM_DELETE_SUB_ENTITIES(
604: DELETE_ENTITY_SEQUENCE_ID,
605: COMPONENT_SEQUENCE_ID,
606: OPERATION_SEQ_NUM,
607: EFFECTIVITY_DATE,

Line 655: BOM_DELETE_SUB_ENTITIES BDSE,

651: NVL(BIC.DISABLE_DATE, NVL(expiration_date + 1, TRUNC(SYSDATE)))
652: AND BIC.COMPONENT_SEQUENCE_ID NOT IN(
653: SELECT NVL(COMPONENT_SEQUENCE_ID, 0)
654: FROM
655: BOM_DELETE_SUB_ENTITIES BDSE,
656: BOM_DELETE_ENTITIES BDE
657: WHERE BDE.DELETE_GROUP_SEQUENCE_ID = delete_group_id
658: AND BDE.DELETE_ENTITY_SEQUENCE_ID = BDSE.DELETE_ENTITY_SEQUENCE_ID);
659: END IF; -- END OF COMPONENT WHERE USED SEARCH

Line 721: INSERT INTO BOM_DELETE_SUB_ENTITIES(

717: SELECT NVL(ROUTING_SEQUENCE_ID, 0)
718: FROM BOM_DELETE_ENTITIES
719: WHERE DELETE_GROUP_SEQUENCE_ID = delete_group_id));
720:
721: INSERT INTO BOM_DELETE_SUB_ENTITIES(
722: DELETE_ENTITY_SEQUENCE_ID,
723: OPERATION_SEQUENCE_ID,
724: OPERATION_SEQ_NUM,
725: EFFECTIVITY_DATE,

Line 763: BOM_DELETE_SUB_ENTITIES BDSE,

759: AND BOS.DISABLE_DATE <= expiration_date
760: AND BOS.OPERATION_SEQUENCE_ID NOT IN(
761: SELECT NVL(OPERATION_SEQUENCE_ID, 0)
762: FROM
763: BOM_DELETE_SUB_ENTITIES BDSE,
764: BOM_DELETE_ENTITIES BDE
765: WHERE BDE.DELETE_GROUP_SEQUENCE_ID = delete_group_id
766: AND BDE.DELETE_ENTITY_SEQUENCE_ID = BDSE.DELETE_ENTITY_SEQUENCE_ID);
767: RAISE finale;