APPS.BOM_DELETE_ENTITY dependencies on BOM_INVENTORY_COMPONENTS

Line 201: FROM bom_inventory_components

197: RETURN NUMBER
198: IS
199: CURSOR compseq is
200: select component_sequence_id
201: FROM bom_inventory_components
202: where bill_sequence_id = bill_seq and
203: component_item_id = component_id and
204: operation_seq_num = oper_seq_num and
205: effectivity_date = effective_date ;

Line 514: component_id bom_inventory_components.component_item_id%type;

510: new_operation_seq bom_delete_sub_entities.operation_sequence_id%type;
511: new_bill_seq bom_bill_of_materials.bill_sequence_id%type;
512: new_rtg_seq bom_operational_routings.routing_sequence_id%type;
513: new_item_id bom_delete_entities.inventory_item_id%type;
514: component_id bom_inventory_components.component_item_id%type;
515: oper_seq_num bom_inventory_components.operation_seq_num%type;
516: effective_date bom_inventory_components.effectivity_date%type;
517:
518: CURSOR bom_entities IS

Line 515: oper_seq_num bom_inventory_components.operation_seq_num%type;

511: new_bill_seq bom_bill_of_materials.bill_sequence_id%type;
512: new_rtg_seq bom_operational_routings.routing_sequence_id%type;
513: new_item_id bom_delete_entities.inventory_item_id%type;
514: component_id bom_inventory_components.component_item_id%type;
515: oper_seq_num bom_inventory_components.operation_seq_num%type;
516: effective_date bom_inventory_components.effectivity_date%type;
517:
518: CURSOR bom_entities IS
519: SELECT bill_sequence_id,delete_entity_type,delete_status_type,

Line 516: effective_date bom_inventory_components.effectivity_date%type;

512: new_rtg_seq bom_operational_routings.routing_sequence_id%type;
513: new_item_id bom_delete_entities.inventory_item_id%type;
514: component_id bom_inventory_components.component_item_id%type;
515: oper_seq_num bom_inventory_components.operation_seq_num%type;
516: effective_date bom_inventory_components.effectivity_date%type;
517:
518: CURSOR bom_entities IS
519: SELECT bill_sequence_id,delete_entity_type,delete_status_type,
520: inventory_item_id,alternate_designator,routing_sequence_id,

Line 538: FROM bom_inventory_components

534: where DELETE_ENTITY_SEQUENCE_ID = current_del_seq;
535:
536: CURSOR compseq is
537: select component_sequence_id
538: FROM bom_inventory_components
539: where bill_sequence_id = new_bill_seq and
540: component_item_id = component_id and
541: operation_seq_num = oper_seq_num and
542: trunc(effectivity_date) = trunc(effective_date) ;