APPS.EAM_WO_DEFAULT_PVT dependencies on WIP_EAM_PARAMETERS

Line 70: FROM wip_eam_parameters

66: BEGIN
67:
68: SELECT work_order_prefix
69: INTO l_wip_entity_name_prefix
70: FROM wip_eam_parameters
71: WHERE organization_id = p_organization_id;
72:
73: RETURN l_wip_entity_name_prefix;
74:

Line 562: from WIP_EAM_PARAMETERS

558: END IF;
559:
560: IF x_eam_wo_rec.owning_department IS NULL THEN
561: select default_department_id into x_eam_wo_rec.owning_department
562: from WIP_EAM_PARAMETERS
563: where organization_id = p_eam_wo_rec.organization_id;
564: END IF;
565:
566: IF l_priority IS NOT NULL AND

Line 604: from WIP_EAM_PARAMETERS

600: END IF;
601:
602: IF x_eam_wo_rec.owning_department IS NULL THEN
603: select default_department_id into x_eam_wo_rec.owning_department
604: from WIP_EAM_PARAMETERS
605: where organization_id = p_eam_wo_rec.organization_id;
606: END IF;
607:
608: IF l_priority IS NOT NULL AND

Line 677: from WIP_EAM_PARAMETERS

673: END IF;
674:
675: IF x_eam_wo_rec.owning_department IS NULL THEN
676: select default_department_id into x_eam_wo_rec.owning_department
677: from WIP_EAM_PARAMETERS
678: where organization_id = p_eam_wo_rec.organization_id;
679: END IF;
680: END IF;
681:

Line 777: FROM wip_eam_parameters

773: THEN
774: SELECT
775: nvl(issue_zero_cost_flag,'N')
776: INTO x_eam_wo_rec.issue_zero_cost_flag
777: FROM wip_eam_parameters
778: WHERE organization_id = p_eam_wo_rec.organization_id;
779:
780: END IF;
781:

Line 809: from wip_eam_parameters

805: -- Defaulting Firm Planned Flag when auto firm flag on create checked.
806: IF p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_CREATE
807: THEN
808: select nvl(auto_firm_on_create,'N') into l_auto_firm_create_flag
809: from wip_eam_parameters
810: where organization_id = p_eam_wo_rec.organization_id;
811: IF l_auto_firm_create_flag = 'Y' THEN
812: x_eam_wo_rec.firm_planned_flag := 1;
813: END IF;

Line 831: from wip_eam_parameters

827: and p_eam_wo_rec.status_type = 3
828: )
829: THEN
830: select nvl(auto_firm_flag,'N') into l_auto_firm_flag
831: from wip_eam_parameters
832: where organization_id = p_eam_wo_rec.organization_id;
833: IF l_auto_firm_flag = 'Y' THEN
834: x_eam_wo_rec.firm_planned_flag := 1;
835: END IF;

Line 905: from wip_eam_parameters

901: p_eam_wo_rec.material_issue_by_mo = FND_API.G_MISS_CHAR
902: THEN
903: select nvl(material_issue_by_mo,'N')
904: into x_eam_wo_rec.material_issue_by_mo
905: from wip_eam_parameters
906: where organization_id = p_eam_wo_rec.organization_id;
907: END IF;
908:
909: -- Defaulting the job_quantity