APPS.MSC_GET_NAME dependencies on STANDARD

Line 3947: p_standard_operation_id IN NUMBER) return varchar2 IS

3943: end supply_order_number;
3944:
3945: FUNCTION operation_code(p_plan_id IN NUMBER,
3946: p_sr_instance_id IN NUMBER,
3947: p_standard_operation_id IN NUMBER) return varchar2 IS
3948:
3949: v_operation_code varchar2(50);
3950:
3951: CURSOR Operation_Code_C IS

Line 3956: and standard_operation_id = p_standard_operation_id;

3952: select operation_code
3953: from msc_std_op_resources
3954: where plan_id = p_plan_id
3955: and sr_instance_id = p_sr_instance_id
3956: and standard_operation_id = p_standard_operation_id;
3957:
3958: BEGIN
3959: IF p_plan_id is null or
3960: p_sr_instance_id is null or

Line 3961: p_standard_operation_id is null THEN

3957:
3958: BEGIN
3959: IF p_plan_id is null or
3960: p_sr_instance_id is null or
3961: p_standard_operation_id is null THEN
3962: return null;
3963: END IF;
3964: OPEN Operation_Code_C;
3965: FETCH Operation_Code_C INTO v_operation_code;

Line 4285: FUNCTION standard_operation_code(p_plan_id IN NUMBER,

4281: return l_eam_parent_order_number;
4282:
4283: End eam_parent_work_order;
4284:
4285: FUNCTION standard_operation_code(p_plan_id IN NUMBER,
4286: p_sr_instance_id IN NUMBER,
4287: p_resource_id IN NUMBER,
4288: p_org_id IN NUMBER,
4289: p_from_setup_id IN NUMBER,

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

4302: and mst.to_setup_id=p_to_setup_id
4303: and res.plan_id=mst.plan_id
4304: and res.sr_instance_id=mst.sr_instance_id
4305: and res.organization_id=mst.organization_id
4306: and res.standard_operation_id =mst.standard_operation_id;
4307:
4308: BEGIN
4309: IF p_plan_id is null or
4310: p_sr_instance_id is null or

Line 4325: END standard_operation_code;

4321: return v_operation_code;
4322:
4323: EXCEPTION when others THEN
4324: return null;
4325: END standard_operation_code;
4326:
4327: function get_op_seq_id(p_plan_id in number,
4328: p_sr_instance_id in number,
4329: p_routing_seq_id in number,

Line 4876: select standard_operation_code

4872: cursor get_std_op_code_c(p_plan_id number,
4873: p_sr_instance_id number,
4874: p_routing_sequence_id number,
4875: p_op_seq_id number) is
4876: select standard_operation_code
4877: from msc_routing_operations
4878: where plan_id = p_plan_id
4879: and sr_instance_id = p_sr_instance_id
4880: and routing_sequence_id = p_routing_sequence_id

Line 5390: v_operation_code := standard_operation_code(p_plan_id,

5386: CLOSE setup_c;
5387:
5388:
5389: IF v_count > 0 THEN
5390: v_operation_code := standard_operation_code(p_plan_id,
5391: p_sr_instance_id,
5392: v_resource_id,
5393: p_org_id,
5394: v_from_setup_id,