DBA Data[Home] [Help]

APPS.BOM_DELETE_GROUPS_API dependencies on BOM_DELETE_ERRORS

Line 461: DELETE FROM BOM_DELETE_ERRORS

457: rerun the delete on it
458: */
459:
460: IF (curr_del_entity_type=1 OR curr_del_entity_type=2 OR curr_del_entity_type=3 )THEN
461: DELETE FROM BOM_DELETE_ERRORS
462: WHERE DELETE_ENTITY_SEQUENCE_ID = current_seq_id;
463: END IF;
464:
465: stmt_num := 5;

Line 584: DELETE FROM BOM_DELETE_ERRORS

580: ** rerun the delete on it
581: */
582: if (curr_del_entity_type=4 ) then
583: curr_comp_seq_id := sub_entity_record.component_seq_id;
584: DELETE FROM BOM_DELETE_ERRORS
585: WHERE DELETE_ENTITY_SEQUENCE_ID = current_seq_id
586: AND COMPONENT_SEQUENCE_ID = curr_comp_seq_id;
587: elsif ( curr_del_entity_type= 5) then
588: curr_op_seq_id := sub_entity_record.operation_seq_id;

Line 589: DELETE FROM BOM_DELETE_ERRORS

585: WHERE DELETE_ENTITY_SEQUENCE_ID = current_seq_id
586: AND COMPONENT_SEQUENCE_ID = curr_comp_seq_id;
587: elsif ( curr_del_entity_type= 5) then
588: curr_op_seq_id := sub_entity_record.operation_seq_id;
589: DELETE FROM BOM_DELETE_ERRORS
590: WHERE DELETE_ENTITY_SEQUENCE_ID = current_seq_id
591: AND OPERATION_SEQUENCE_ID = curr_op_seq_id;
592: end if;
593:

Line 870: INSERT INTO BOM_DELETE_ERRORS (

866: end if;
867: if (cnt =0 AND cur_rec.delete_on_success_flag = 1) OR
868: (cnt <> 0 and cur_rec.delete_on_success_flag =2) then
869: error_sequence_number := error_sequence_number +1;
870: INSERT INTO BOM_DELETE_ERRORS (
871: DELETE_ENTITY_SEQUENCE_ID,
872: COMPONENT_SEQUENCE_ID,
873: OPERATION_SEQUENCE_ID,
874: ERROR_SEQUENCE_NUMBER,