APPS.WIP_OPERATION_VALIDATE dependencies on STANDARD

Line 428: /************VALIDATE STANDARD OPERATIONS **************************/

424: end if ;
425:
426: end val_dept_resources;
427:
428: /************VALIDATE STANDARD OPERATIONS **************************/
429: procedure val_std_op(p_group_id in number,
430: p_wip_entity_id in number,
431: p_organization_id in number,
432: p_sub_type in number) is

Line 444: and standard_operation_id is not null

440: and load_type = wip_job_details.wip_operation
441: and substitution_type = p_sub_type
442: and wip_entity_id = p_wip_entity_id
443: and organization_id = p_organization_id
444: and standard_operation_id is not null
445: and standard_operation_id <> fnd_api.g_miss_num
446: and not exists (select 1
447: from bom_standard_operations
448: where standard_operation_id = wjdi.standard_operation_id

Line 445: and standard_operation_id <> fnd_api.g_miss_num

441: and substitution_type = p_sub_type
442: and wip_entity_id = p_wip_entity_id
443: and organization_id = p_organization_id
444: and standard_operation_id is not null
445: and standard_operation_id <> fnd_api.g_miss_num
446: and not exists (select 1
447: from bom_standard_operations
448: where standard_operation_id = wjdi.standard_operation_id
449: and organization_id = wjdi.organization_id);

Line 447: from bom_standard_operations

443: and organization_id = p_organization_id
444: and standard_operation_id is not null
445: and standard_operation_id <> fnd_api.g_miss_num
446: and not exists (select 1
447: from bom_standard_operations
448: where standard_operation_id = wjdi.standard_operation_id
449: and organization_id = wjdi.organization_id);
450:
451: l_error_exists boolean := false;

Line 448: where standard_operation_id = wjdi.standard_operation_id

444: and standard_operation_id is not null
445: and standard_operation_id <> fnd_api.g_miss_num
446: and not exists (select 1
447: from bom_standard_operations
448: where standard_operation_id = wjdi.standard_operation_id
449: and organization_id = wjdi.organization_id);
450:
451: l_error_exists boolean := false;
452: begin

Line 480: and standard_operation_id is not null

476: and load_type = wip_job_details.wip_operation
477: and substitution_type = p_sub_type
478: and wip_entity_id = p_wip_entity_id
479: and organization_id = p_organization_id
480: and standard_operation_id is not null
481: and standard_operation_id <> fnd_api.g_miss_num
482: and not exists (select 1
483: from bom_standard_operations
484: where standard_operation_id = wjdi.standard_operation_id

Line 481: and standard_operation_id <> fnd_api.g_miss_num

477: and substitution_type = p_sub_type
478: and wip_entity_id = p_wip_entity_id
479: and organization_id = p_organization_id
480: and standard_operation_id is not null
481: and standard_operation_id <> fnd_api.g_miss_num
482: and not exists (select 1
483: from bom_standard_operations
484: where standard_operation_id = wjdi.standard_operation_id
485: and organization_id = wjdi.organization_id);

Line 483: from bom_standard_operations

479: and organization_id = p_organization_id
480: and standard_operation_id is not null
481: and standard_operation_id <> fnd_api.g_miss_num
482: and not exists (select 1
483: from bom_standard_operations
484: where standard_operation_id = wjdi.standard_operation_id
485: and organization_id = wjdi.organization_id);
486: end if;
487: end val_std_op;

Line 484: where standard_operation_id = wjdi.standard_operation_id

480: and standard_operation_id is not null
481: and standard_operation_id <> fnd_api.g_miss_num
482: and not exists (select 1
483: from bom_standard_operations
484: where standard_operation_id = wjdi.standard_operation_id
485: and organization_id = wjdi.organization_id);
486: end if;
487: end val_std_op;
488: