APPS.BOMPCMBM dependencies on DUAL

Line 494: FROM DUAL;

490: AND NVL(ALTERNATE_BOM_DESIGNATOR,'NONE') = NVL(alternate,'NONE') ;
491:
492: SELECT BOM_DELETE_GROUPS_S.NEXTVAL
493: INTO delete_group_id
494: FROM DUAL;
495:
496: SELECT BOM_DELETE_ENTITIES_S.NEXTVAL
497: INTO delete_entity_id
498: FROM dual;

Line 498: FROM dual;

494: FROM DUAL;
495:
496: SELECT BOM_DELETE_ENTITIES_S.NEXTVAL
497: INTO delete_entity_id
498: FROM dual;
499:
500: if (length(delete_group_id) > 7) Then
501: del_group_name := substr(delete_group_id,length(delete_group_id) - 6,7);
502: else

Line 845: FROM SYS.DUAL;

841: RETURN NUMBER
842: IS
843: CURSOR Comp_Seq IS
844: SELECT Bom_Inventory_Components_S.NEXTVAL Component_Sequence
845: FROM SYS.DUAL;
846: BEGIN
847: FOR c_Comp_Seq IN Comp_Seq LOOP
848: RETURN c_Comp_Seq.Component_Sequence;
849: END LOOP ;

Line 3804: SELECT 1 from dual;

3800: and alternate_routing_designator = p_alt_desg
3801: )
3802: )
3803: UNION
3804: SELECT 1 from dual;
3805: */
3806: Cursor get_rtg_opns(p_assy_item_id NUMBER, p_org_id NUMBER, p_alt_desg VARCHAR2)
3807: IS
3808: Select OPERATION_SEQ_NUM

Line 3817: SELECT 1 from dual;

3813: and organization_id = p_org_id
3814: and nvl(alternate_routing_designator, 'XXX') = nvl(p_alt_desg, 'XXX'))
3815:
3816: UNION
3817: SELECT 1 from dual;
3818:
3819: l_rtg_exist varchar2(30);
3820: l_stmt_num number;
3821: found boolean;

Line 4627: SELECT bom_inventory_components_s.NEXTVAL INTO l_dest_new_comp_seq_id FROM dual;

4623: END;
4624: END IF;
4625: IF (l_return_status = 'S')
4626: THEN
4627: SELECT bom_inventory_components_s.NEXTVAL INTO l_dest_new_comp_seq_id FROM dual;
4628: -- changed values from other record
4629: l_component_rec.component_sequence_id := l_dest_new_comp_seq_id;
4630: l_component_rec.old_component_sequence_id := c_dest_comp_rec.component_sequence_id;
4631: l_component_rec.common_component_sequence_id := p_src_comp_seq_id;