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 589: DELETE FROM BOM_DELETE_ERRORS

585: ** rerun the delete on it
586: */
587: if (curr_del_entity_type=4 ) then
588: curr_comp_seq_id := sub_entity_record.component_seq_id;
589: DELETE FROM BOM_DELETE_ERRORS
590: WHERE DELETE_ENTITY_SEQUENCE_ID = current_seq_id
591: AND COMPONENT_SEQUENCE_ID = curr_comp_seq_id;
592: elsif ( curr_del_entity_type= 5) then
593: curr_op_seq_id := sub_entity_record.operation_seq_id;

Line 594: DELETE FROM BOM_DELETE_ERRORS

590: WHERE DELETE_ENTITY_SEQUENCE_ID = current_seq_id
591: AND COMPONENT_SEQUENCE_ID = curr_comp_seq_id;
592: elsif ( curr_del_entity_type= 5) then
593: curr_op_seq_id := sub_entity_record.operation_seq_id;
594: DELETE FROM BOM_DELETE_ERRORS
595: WHERE DELETE_ENTITY_SEQUENCE_ID = current_seq_id
596: AND OPERATION_SEQUENCE_ID = curr_op_seq_id;
597: end if;
598:

Line 875: INSERT INTO BOM_DELETE_ERRORS (

871: end if;
872: if (cnt =0 AND cur_rec.delete_on_success_flag = 1) OR
873: (cnt <> 0 and cur_rec.delete_on_success_flag =2) then
874: error_sequence_number := error_sequence_number +1;
875: INSERT INTO BOM_DELETE_ERRORS (
876: DELETE_ENTITY_SEQUENCE_ID,
877: COMPONENT_SEQUENCE_ID,
878: OPERATION_SEQUENCE_ID,
879: ERROR_SEQUENCE_NUMBER,