APPS.MSC_GET_NAME dependencies on STANDARD

Line 3490: p_standard_operation_id IN NUMBER) return varchar2 IS

3486: end supply_order_number;
3487:
3488: FUNCTION operation_code(p_plan_id IN NUMBER,
3489: p_sr_instance_id IN NUMBER,
3490: p_standard_operation_id IN NUMBER) return varchar2 IS
3491:
3492: v_operation_code varchar2(50);
3493:
3494: CURSOR Operation_Code_C IS

Line 3499: and standard_operation_id = p_standard_operation_id;

3495: select operation_code
3496: from msc_std_op_resources
3497: where plan_id = p_plan_id
3498: and sr_instance_id = p_sr_instance_id
3499: and standard_operation_id = p_standard_operation_id;
3500:
3501: BEGIN
3502: IF p_plan_id is null or
3503: p_sr_instance_id is null or

Line 3504: p_standard_operation_id is null THEN

3500:
3501: BEGIN
3502: IF p_plan_id is null or
3503: p_sr_instance_id is null or
3504: p_standard_operation_id is null THEN
3505: return null;
3506: END IF;
3507: OPEN Operation_Code_C;
3508: FETCH Operation_Code_C INTO v_operation_code;

Line 3828: FUNCTION standard_operation_code(p_plan_id IN NUMBER,

3824: return l_eam_parent_order_number;
3825:
3826: End eam_parent_work_order;
3827:
3828: FUNCTION standard_operation_code(p_plan_id IN NUMBER,
3829: p_sr_instance_id IN NUMBER,
3830: p_resource_id IN NUMBER,
3831: p_org_id IN NUMBER,
3832: p_from_setup_id IN NUMBER,

Line 3849: and res.standard_operation_id =mst.standard_operation_id;

3845: and mst.to_setup_id=p_to_setup_id
3846: and res.plan_id=mst.plan_id
3847: and res.sr_instance_id=mst.sr_instance_id
3848: and res.organization_id=mst.organization_id
3849: and res.standard_operation_id =mst.standard_operation_id;
3850:
3851: BEGIN
3852: IF p_plan_id is null or
3853: p_sr_instance_id is null or

Line 3868: END standard_operation_code;

3864: return v_operation_code;
3865:
3866: EXCEPTION when others THEN
3867: return null;
3868: END standard_operation_code;
3869:
3870: function get_op_seq_id(p_plan_id in number,
3871: p_sr_instance_id in number,
3872: p_routing_seq_id in number,

Line 4383: select standard_operation_code

4379: cursor get_std_op_code_c(p_plan_id number,
4380: p_sr_instance_id number,
4381: p_routing_sequence_id number,
4382: p_op_seq_id number) is
4383: select standard_operation_code
4384: from msc_routing_operations
4385: where plan_id = p_plan_id
4386: and sr_instance_id = p_sr_instance_id
4387: and routing_sequence_id = p_routing_sequence_id

Line 4877: v_operation_code := standard_operation_code(p_plan_id,

4873: CLOSE setup_c;
4874:
4875:
4876: IF v_count > 0 THEN
4877: v_operation_code := standard_operation_code(p_plan_id,
4878: p_sr_instance_id,
4879: v_resource_id,
4880: p_org_id,
4881: v_from_setup_id,