APPS.BOM_DELETE_ENTITY dependencies on BOM_DELETE_SUB_ENTITIES

Line 509: new_comp_seq bom_delete_sub_entities.component_sequence_id%type := NULL;

505: last_upd_by bom_delete_entities.last_updated_by%type;
506: crtd_by bom_delete_entities.created_by%type;
507: current_del_seq bom_delete_entities.delete_entity_sequence_id%type;
508: new_del_seq bom_delete_entities.delete_entity_sequence_id%type;
509: new_comp_seq bom_delete_sub_entities.component_sequence_id%type := NULL;
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;

Line 510: new_operation_seq bom_delete_sub_entities.operation_sequence_id%type;

506: crtd_by bom_delete_entities.created_by%type;
507: current_del_seq bom_delete_entities.delete_entity_sequence_id%type;
508: new_del_seq bom_delete_entities.delete_entity_sequence_id%type;
509: new_comp_seq bom_delete_sub_entities.component_sequence_id%type := NULL;
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;

Line 533: FROM BOM_DELETE_SUB_ENTITIES

529: CURSOR sub_entity IS
530: SELECT OPERATION_SEQ_NUM,EFFECTIVITY_DATE,
531: COMPONENT_ITEM_ID,COMPONENT_CONCAT_SEGMENTS,
532: ITEM_NUM,DISABLE_DATE,OPERATION_DEPARTMENT_CODE
533: FROM BOM_DELETE_SUB_ENTITIES
534: where DELETE_ENTITY_SEQUENCE_ID = current_del_seq;
535:
536: CURSOR compseq is
537: select component_sequence_id

Line 842: from bom_delete_sub_entities

838: if ((delete_type=5) and new_operation_seq is not NULL) then
839: begin
840: select 'x'
841: into temp
842: from bom_delete_sub_entities
843: where delete_entity_sequence_id = new_del_seq and
844: ((component_sequence_id = new_comp_seq) or
845: (operation_sequence_id = new_operation_seq));
846: exception

Line 848: insert into bom_delete_sub_entities

844: ((component_sequence_id = new_comp_seq) or
845: (operation_sequence_id = new_operation_seq));
846: exception
847: when no_data_found then
848: insert into bom_delete_sub_entities
849: (DELETE_ENTITY_SEQUENCE_ID,
850: COMPONENT_SEQUENCE_ID,
851: OPERATION_SEQUENCE_ID,
852: OPERATION_SEQ_NUM,

Line 913: from bom_delete_sub_entities

909: if new_comp_seq is not NULL then
910: begin
911: select 'x'
912: into temp
913: from bom_delete_sub_entities
914: where delete_entity_sequence_id = new_del_seq and
915: ((component_sequence_id = new_comp_seq) or
916: (operation_sequence_id = new_operation_seq));
917: exception

Line 919: insert into bom_delete_sub_entities

915: ((component_sequence_id = new_comp_seq) or
916: (operation_sequence_id = new_operation_seq));
917: exception
918: when no_data_found then
919: insert into bom_delete_sub_entities
920: (DELETE_ENTITY_SEQUENCE_ID,
921: COMPONENT_SEQUENCE_ID,
922: OPERATION_SEQUENCE_ID,
923: OPERATION_SEQ_NUM,

Line 1039: BOM_DELETE_SUB_ENTITIES Table

1035: Insert Component and Operation Info in Delete Sub Entities Table
1036:
1037: MODIFIES
1038: BOM_DELETE_ENTITIES Table
1039: BOM_DELETE_SUB_ENTITIES Table
1040: ---------------------------------------------------------------------------*/
1041: PROCEDURE insert_original_bills(group_id IN NUMBER,
1042: delete_type IN NUMBER)
1043: IS