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.BOM_DELETE_ENTITY dependencies on BOM_DELETE_ENTITIES

Line 318: del_ent_type bom_delete_entities.delete_entity_type%type;

314: temp varchar2(1);
315: common_bill bom_bill_of_materials.common_bill_sequence_id%type;
316: bill_seq_id bom_bill_of_materials.bill_sequence_id%type;
317: current_bill_seq bom_bill_of_materials.bill_sequence_id%type;
318: del_ent_type bom_delete_entities.delete_entity_type%type;
319: inv_item_id bom_delete_entities.inventory_item_id%type;
320: alt_desg bom_delete_entities.alternate_designator%type;
321: item_concat_seg bom_delete_entities.item_concat_segments%type;
322: last_upd_by bom_delete_entities.last_updated_by%type;

Line 319: inv_item_id bom_delete_entities.inventory_item_id%type;

315: common_bill bom_bill_of_materials.common_bill_sequence_id%type;
316: bill_seq_id bom_bill_of_materials.bill_sequence_id%type;
317: current_bill_seq bom_bill_of_materials.bill_sequence_id%type;
318: del_ent_type bom_delete_entities.delete_entity_type%type;
319: inv_item_id bom_delete_entities.inventory_item_id%type;
320: alt_desg bom_delete_entities.alternate_designator%type;
321: item_concat_seg bom_delete_entities.item_concat_segments%type;
322: last_upd_by bom_delete_entities.last_updated_by%type;
323: crtd_by bom_delete_entities.created_by%type;

Line 320: alt_desg bom_delete_entities.alternate_designator%type;

316: bill_seq_id bom_bill_of_materials.bill_sequence_id%type;
317: current_bill_seq bom_bill_of_materials.bill_sequence_id%type;
318: del_ent_type bom_delete_entities.delete_entity_type%type;
319: inv_item_id bom_delete_entities.inventory_item_id%type;
320: alt_desg bom_delete_entities.alternate_designator%type;
321: item_concat_seg bom_delete_entities.item_concat_segments%type;
322: last_upd_by bom_delete_entities.last_updated_by%type;
323: crtd_by bom_delete_entities.created_by%type;
324: current_del_seq bom_delete_entities.delete_entity_sequence_id%type;

Line 321: item_concat_seg bom_delete_entities.item_concat_segments%type;

317: current_bill_seq bom_bill_of_materials.bill_sequence_id%type;
318: del_ent_type bom_delete_entities.delete_entity_type%type;
319: inv_item_id bom_delete_entities.inventory_item_id%type;
320: alt_desg bom_delete_entities.alternate_designator%type;
321: item_concat_seg bom_delete_entities.item_concat_segments%type;
322: last_upd_by bom_delete_entities.last_updated_by%type;
323: crtd_by bom_delete_entities.created_by%type;
324: current_del_seq bom_delete_entities.delete_entity_sequence_id%type;
325:

Line 322: last_upd_by bom_delete_entities.last_updated_by%type;

318: del_ent_type bom_delete_entities.delete_entity_type%type;
319: inv_item_id bom_delete_entities.inventory_item_id%type;
320: alt_desg bom_delete_entities.alternate_designator%type;
321: item_concat_seg bom_delete_entities.item_concat_segments%type;
322: last_upd_by bom_delete_entities.last_updated_by%type;
323: crtd_by bom_delete_entities.created_by%type;
324: current_del_seq bom_delete_entities.delete_entity_sequence_id%type;
325:
326: CURSOR bom_entities IS

Line 323: crtd_by bom_delete_entities.created_by%type;

319: inv_item_id bom_delete_entities.inventory_item_id%type;
320: alt_desg bom_delete_entities.alternate_designator%type;
321: item_concat_seg bom_delete_entities.item_concat_segments%type;
322: last_upd_by bom_delete_entities.last_updated_by%type;
323: crtd_by bom_delete_entities.created_by%type;
324: current_del_seq bom_delete_entities.delete_entity_sequence_id%type;
325:
326: CURSOR bom_entities IS
327: SELECT bill_sequence_id,delete_entity_type,

Line 324: current_del_seq bom_delete_entities.delete_entity_sequence_id%type;

320: alt_desg bom_delete_entities.alternate_designator%type;
321: item_concat_seg bom_delete_entities.item_concat_segments%type;
322: last_upd_by bom_delete_entities.last_updated_by%type;
323: crtd_by bom_delete_entities.created_by%type;
324: current_del_seq bom_delete_entities.delete_entity_sequence_id%type;
325:
326: CURSOR bom_entities IS
327: SELECT bill_sequence_id,delete_entity_type,
328: inventory_item_id,alternate_designator,

Line 331: FROM bom_delete_entities

327: SELECT bill_sequence_id,delete_entity_type,
328: inventory_item_id,alternate_designator,
329: item_concat_segments,last_updated_by,
330: created_by,delete_entity_sequence_id
331: FROM bom_delete_entities
332: WHERE delete_group_sequence_id = group_id
333: AND organization_id = original_org;
334:
335: CURSOR common_bills IS

Line 381: from bom_delete_entities

377: LOOP --- COMMON LOOP
378: begin
379: select 'x'
380: into temp
381: from bom_delete_entities
382: where bill_sequence_id = c_common_bills.bill_sequence_id and
383: delete_group_sequence_id = group_id and
384: organization_id = current_org;
385: exception

Line 387: insert into bom_delete_entities

383: delete_group_sequence_id = group_id and
384: organization_id = current_org;
385: exception
386: when no_data_found then
387: insert into bom_delete_entities
388: (DELETE_ENTITY_SEQUENCE_ID,
389: DELETE_GROUP_SEQUENCE_ID,
390: DELETE_ENTITY_TYPE,
391: BILL_SEQUENCE_ID,

Line 411: select bom_delete_entities_s.nextval,

407: REQUEST_ID,
408: PROGRAM_APPLICATION_ID,
409: PROGRAM_ID,
410: PROGRAM_UPDATE_DATE)
411: select bom_delete_entities_s.nextval,
412: group_id,
413: del_ent_type,
414: get_bill_seq(c_common_bills.assembly_item_id,
415: current_org,

Line 444: update bom_delete_entities

440: common_bill_sequence_id = current_bill_seq and
441: bill_sequence_id <> current_bill_seq and
442: common_organization_id = original_org and
443: common_assembly_item_id = inv_item_id;
444: update bom_delete_entities
445: set delete_status_type = 5
446: where delete_group_sequence_id = group_id and
447: delete_entity_sequence_id = current_del_seq and
448: delete_status_type <> 4;

Line 466: delete from bom_delete_entities

462: IS
463: BEGIN
464: if (common_flag = 1) then
465: begin
466: delete from bom_delete_entities
467: where delete_group_sequence_id = group_id and
468: delete_status_type = 5;
469: exception
470: when others then

Line 475: update bom_delete_entities

471: null;
472: end;
473: elsif (common_flag = 2) then
474: begin
475: update bom_delete_entities
476: set delete_status_type = 1
477: where delete_group_sequence_id = group_id and
478: delete_status_type = 5;
479: exception

Line 499: current_rtg_seq bom_delete_entities.routing_sequence_id%type;

495: temp varchar2(1);
496: common_bill bom_bill_of_materials.common_bill_sequence_id%type;
497: bill_seq_id bom_bill_of_materials.bill_sequence_id%type;
498: current_bill_seq bom_bill_of_materials.bill_sequence_id%type;
499: current_rtg_seq bom_delete_entities.routing_sequence_id%type;
500: del_status bom_delete_entities.delete_status_type%type;
501: del_ent_type bom_delete_entities.delete_entity_type%type;
502: inv_item_id bom_delete_entities.inventory_item_id%type;
503: alt_desg bom_delete_entities.alternate_designator%type;

Line 500: del_status bom_delete_entities.delete_status_type%type;

496: common_bill bom_bill_of_materials.common_bill_sequence_id%type;
497: bill_seq_id bom_bill_of_materials.bill_sequence_id%type;
498: current_bill_seq bom_bill_of_materials.bill_sequence_id%type;
499: current_rtg_seq bom_delete_entities.routing_sequence_id%type;
500: del_status bom_delete_entities.delete_status_type%type;
501: del_ent_type bom_delete_entities.delete_entity_type%type;
502: inv_item_id bom_delete_entities.inventory_item_id%type;
503: alt_desg bom_delete_entities.alternate_designator%type;
504: item_concat_seg bom_delete_entities.item_concat_segments%type;

Line 501: del_ent_type bom_delete_entities.delete_entity_type%type;

497: bill_seq_id bom_bill_of_materials.bill_sequence_id%type;
498: current_bill_seq bom_bill_of_materials.bill_sequence_id%type;
499: current_rtg_seq bom_delete_entities.routing_sequence_id%type;
500: del_status bom_delete_entities.delete_status_type%type;
501: del_ent_type bom_delete_entities.delete_entity_type%type;
502: inv_item_id bom_delete_entities.inventory_item_id%type;
503: alt_desg bom_delete_entities.alternate_designator%type;
504: item_concat_seg bom_delete_entities.item_concat_segments%type;
505: last_upd_by bom_delete_entities.last_updated_by%type;

Line 502: inv_item_id bom_delete_entities.inventory_item_id%type;

498: current_bill_seq bom_bill_of_materials.bill_sequence_id%type;
499: current_rtg_seq bom_delete_entities.routing_sequence_id%type;
500: del_status bom_delete_entities.delete_status_type%type;
501: del_ent_type bom_delete_entities.delete_entity_type%type;
502: inv_item_id bom_delete_entities.inventory_item_id%type;
503: alt_desg bom_delete_entities.alternate_designator%type;
504: item_concat_seg bom_delete_entities.item_concat_segments%type;
505: last_upd_by bom_delete_entities.last_updated_by%type;
506: crtd_by bom_delete_entities.created_by%type;

Line 503: alt_desg bom_delete_entities.alternate_designator%type;

499: current_rtg_seq bom_delete_entities.routing_sequence_id%type;
500: del_status bom_delete_entities.delete_status_type%type;
501: del_ent_type bom_delete_entities.delete_entity_type%type;
502: inv_item_id bom_delete_entities.inventory_item_id%type;
503: alt_desg bom_delete_entities.alternate_designator%type;
504: item_concat_seg bom_delete_entities.item_concat_segments%type;
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;

Line 504: item_concat_seg bom_delete_entities.item_concat_segments%type;

500: del_status bom_delete_entities.delete_status_type%type;
501: del_ent_type bom_delete_entities.delete_entity_type%type;
502: inv_item_id bom_delete_entities.inventory_item_id%type;
503: alt_desg bom_delete_entities.alternate_designator%type;
504: item_concat_seg bom_delete_entities.item_concat_segments%type;
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;

Line 505: last_upd_by bom_delete_entities.last_updated_by%type;

501: del_ent_type bom_delete_entities.delete_entity_type%type;
502: inv_item_id bom_delete_entities.inventory_item_id%type;
503: alt_desg bom_delete_entities.alternate_designator%type;
504: item_concat_seg bom_delete_entities.item_concat_segments%type;
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;

Line 506: crtd_by bom_delete_entities.created_by%type;

502: inv_item_id bom_delete_entities.inventory_item_id%type;
503: alt_desg bom_delete_entities.alternate_designator%type;
504: item_concat_seg bom_delete_entities.item_concat_segments%type;
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;

Line 507: current_del_seq bom_delete_entities.delete_entity_sequence_id%type;

503: alt_desg bom_delete_entities.alternate_designator%type;
504: item_concat_seg bom_delete_entities.item_concat_segments%type;
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;

Line 508: new_del_seq bom_delete_entities.delete_entity_sequence_id%type;

504: item_concat_seg bom_delete_entities.item_concat_segments%type;
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;

Line 513: new_item_id bom_delete_entities.inventory_item_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;
515: oper_seq_num bom_inventory_components.operation_seq_num%type;
516: effective_date bom_inventory_components.effectivity_date%type;
517:

Line 523: FROM bom_delete_entities

519: SELECT bill_sequence_id,delete_entity_type,delete_status_type,
520: inventory_item_id,alternate_designator,routing_sequence_id,
521: item_concat_segments,last_updated_by,
522: created_by,delete_entity_sequence_id
523: FROM bom_delete_entities
524: WHERE
525: delete_group_sequence_id = group_id
526: AND organization_id = original_org
527: AND request_id = FND_GLOBAL.CONC_REQUEST_ID;

Line 610: from bom_delete_entities

606: then
607: begin
608: select 'x'
609: into temp
610: from bom_delete_entities
611: where bill_sequence_id= new_bill_seq and
612: inventory_item_id = new_item_id and
613: delete_group_sequence_id = group_id and
614: organization_id = current_org;

Line 617: select bom_delete_entities_s.nextval

613: delete_group_sequence_id = group_id and
614: organization_id = current_org;
615: exception
616: when no_data_found then
617: select bom_delete_entities_s.nextval
618: into new_del_seq
619: from dual;
620: insert into bom_delete_entities
621: (DELETE_ENTITY_SEQUENCE_ID,

Line 620: insert into bom_delete_entities

616: when no_data_found then
617: select bom_delete_entities_s.nextval
618: into new_del_seq
619: from dual;
620: insert into bom_delete_entities
621: (DELETE_ENTITY_SEQUENCE_ID,
622: DELETE_GROUP_SEQUENCE_ID,
623: DELETE_ENTITY_TYPE,
624: BILL_SEQUENCE_ID,

Line 683: from bom_delete_entities

679: then
680: begin
681: select 'x'
682: into temp
683: from bom_delete_entities
684: where routing_sequence_id= new_rtg_seq and
685: inventory_item_id = new_item_id and
686: delete_group_sequence_id = group_id and
687: organization_id = current_org;

Line 690: select bom_delete_entities_s.nextval

686: delete_group_sequence_id = group_id and
687: organization_id = current_org;
688: exception
689: when no_data_found then
690: select bom_delete_entities_s.nextval
691: into new_del_seq
692: from dual;
693: insert into bom_delete_entities
694: (DELETE_ENTITY_SEQUENCE_ID,

Line 693: insert into bom_delete_entities

689: when no_data_found then
690: select bom_delete_entities_s.nextval
691: into new_del_seq
692: from dual;
693: insert into bom_delete_entities
694: (DELETE_ENTITY_SEQUENCE_ID,
695: DELETE_GROUP_SEQUENCE_ID,
696: DELETE_ENTITY_TYPE,
697: BILL_SEQUENCE_ID,

Line 754: from bom_delete_entities

750: then
751: begin
752: select 'x'
753: into temp
754: from bom_delete_entities
755: where inventory_item_id = new_item_id and
756: delete_group_sequence_id = group_id and
757: delete_entity_type = 1 and
758: organization_id = current_org;

Line 761: select bom_delete_entities_s.nextval

757: delete_entity_type = 1 and
758: organization_id = current_org;
759: exception
760: when no_data_found then
761: select bom_delete_entities_s.nextval
762: into new_del_seq
763: from dual;
764: insert into bom_delete_entities
765: (DELETE_ENTITY_SEQUENCE_ID,

Line 764: insert into bom_delete_entities

760: when no_data_found then
761: select bom_delete_entities_s.nextval
762: into new_del_seq
763: from dual;
764: insert into bom_delete_entities
765: (DELETE_ENTITY_SEQUENCE_ID,
766: DELETE_GROUP_SEQUENCE_ID,
767: DELETE_ENTITY_TYPE,
768: BILL_SEQUENCE_ID,

Line 993: Insert the common bill details in Bom_delete_entities

989: NAME
990: insert_common_bills
991: Entities Table
992: DESCRIPTION
993: Insert the common bill details in Bom_delete_entities
994:
995: MODIFIES
996: BOM_DELETE_ENTITIES Table
997: ---------------------------------------------------------------------------*/

Line 996: BOM_DELETE_ENTITIES Table

992: DESCRIPTION
993: Insert the common bill details in Bom_delete_entities
994:
995: MODIFIES
996: BOM_DELETE_ENTITIES Table
997: ---------------------------------------------------------------------------*/
998:
999:
1000: PROCEDURE insert_common_bills(group_id IN NUMBER,

Line 1034: Insert the original bill details in Bom_delete_entities

1030: NAME
1031: insert_original_bills in Delete Entities Table
1032: and Component,Operation Info in Sub Entities Table
1033: DESCRIPTION
1034: Insert the original bill details in Bom_delete_entities
1035: Insert Component and Operation Info in Delete Sub Entities Table
1036:
1037: MODIFIES
1038: BOM_DELETE_ENTITIES Table

Line 1038: BOM_DELETE_ENTITIES Table

1034: Insert the original bill details in Bom_delete_entities
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)