APPS.BOMPCMBM dependencies on DUAL

Line 396: FROM DUAL;

392: AND NVL(ALTERNATE_BOM_DESIGNATOR,'NONE') = NVL(alternate,'NONE') ;
393:
394: SELECT BOM_DELETE_GROUPS_S.NEXTVAL
395: INTO delete_group_id
396: FROM DUAL;
397:
398: SELECT BOM_DELETE_ENTITIES_S.NEXTVAL
399: INTO delete_entity_id
400: FROM dual;

Line 400: FROM dual;

396: FROM DUAL;
397:
398: SELECT BOM_DELETE_ENTITIES_S.NEXTVAL
399: INTO delete_entity_id
400: FROM dual;
401:
402: if (length(delete_group_id) > 7) Then
403: del_group_name := substr(delete_group_id,length(delete_group_id) - 6,7);
404: else

Line 700: FROM SYS.DUAL;

696: RETURN NUMBER
697: IS
698: CURSOR Comp_Seq IS
699: SELECT Bom_Inventory_Components_S.NEXTVAL Component_Sequence
700: FROM SYS.DUAL;
701: BEGIN
702: FOR c_Comp_Seq IN Comp_Seq LOOP
703: RETURN c_Comp_Seq.Component_Sequence;
704: END LOOP ;

Line 3512: SELECT 1 from dual;

3508: and alternate_routing_designator = p_alt_desg
3509: )
3510: )
3511: UNION
3512: SELECT 1 from dual;
3513: */
3514: Cursor get_rtg_opns(p_assy_item_id NUMBER, p_org_id NUMBER, p_alt_desg VARCHAR2)
3515: IS
3516: Select OPERATION_SEQ_NUM

Line 3525: SELECT 1 from dual;

3521: and organization_id = p_org_id
3522: and nvl(alternate_routing_designator, 'XXX') = nvl(p_alt_desg, 'XXX'))
3523:
3524: UNION
3525: SELECT 1 from dual;
3526:
3527: l_rtg_exist varchar2(30);
3528: l_stmt_num number;
3529: found boolean;

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

4275: END;
4276: END IF;
4277: IF (l_return_status = 'S')
4278: THEN
4279: SELECT bom_inventory_components_s.NEXTVAL INTO l_dest_new_comp_seq_id FROM dual;
4280: -- changed values from other record
4281: l_component_rec.component_sequence_id := l_dest_new_comp_seq_id;
4282: l_component_rec.old_component_sequence_id := c_dest_comp_rec.component_sequence_id;
4283: l_component_rec.common_component_sequence_id := p_src_comp_seq_id;