APPS.EAM_WO_DEFAULT_PVT dependencies on WIP_EAM_PARAMETERS

Line 76: FROM wip_eam_parameters

72: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_wip_entity_name_prefix : Start ================'); END IF;
73:
74: SELECT work_order_prefix
75: INTO l_wip_entity_name_prefix
76: FROM wip_eam_parameters
77: WHERE organization_id = p_organization_id;
78:
79: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_wip_entity_name_prefix : End wip_entity_name prefix: '||l_wip_entity_name_prefix||' =============='); END IF;
80:

Line 108: FROM wip_eam_parameters

104: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug(to_char(sysdate,'DD-MON-YY HH:MI:SS')||' EAM_WO_DEFAULT_PVT.get_pm_wip_entity_prefix : Start ================'); END IF;
105:
106: SELECT PM_WORK_ORDER_PREFIX
107: INTO l_pm_wip_entity_prefix
108: FROM wip_eam_parameters
109: WHERE organization_id = p_organization_id;
110:
111: --l_pm_wip_entity_prefix := 'PM_PREFIX';
112:

Line 752: from WIP_EAM_PARAMETERS

748: END IF;
749:
750: IF x_eam_wo_rec.owning_department IS NULL THEN
751: select default_department_id into x_eam_wo_rec.owning_department
752: from WIP_EAM_PARAMETERS
753: where organization_id = p_eam_wo_rec.organization_id;
754: END IF;
755:
756: IF l_priority IS NOT NULL AND

Line 794: from WIP_EAM_PARAMETERS

790: END IF;
791:
792: IF x_eam_wo_rec.owning_department IS NULL THEN
793: select default_department_id into x_eam_wo_rec.owning_department
794: from WIP_EAM_PARAMETERS
795: where organization_id = p_eam_wo_rec.organization_id;
796: END IF;
797:
798: IF l_priority IS NOT NULL AND

Line 867: from WIP_EAM_PARAMETERS

863: END IF;
864:
865: IF x_eam_wo_rec.owning_department IS NULL THEN
866: select default_department_id into x_eam_wo_rec.owning_department
867: from WIP_EAM_PARAMETERS
868: where organization_id = p_eam_wo_rec.organization_id;
869: END IF;
870:
871: -- added for bug 15984843

Line 911: from WIP_EAM_PARAMETERS

907: IF x_eam_wo_rec.owning_department IS NULL
908: THEN
909: BEGIN
910: select default_department_id into x_eam_wo_rec.owning_department
911: from WIP_EAM_PARAMETERS
912: where organization_id = p_eam_wo_rec.organization_id;
913: EXCEPTION
914: WHEN OTHERS THEN
915: NULL;

Line 1015: FROM wip_eam_parameters

1011: THEN
1012: SELECT
1013: nvl(issue_zero_cost_flag,'N')
1014: INTO x_eam_wo_rec.issue_zero_cost_flag
1015: FROM wip_eam_parameters
1016: WHERE organization_id = p_eam_wo_rec.organization_id;
1017:
1018: END IF;
1019:

Line 1052: from wip_eam_parameters

1048: -- Defaulting Firm Planned Flag when auto firm flag on create checked.
1049: IF p_eam_wo_rec.transaction_type = EAM_PROCESS_WO_PUB.G_OPR_CREATE
1050: THEN
1051: select nvl(auto_firm_on_create,'N') into l_auto_firm_create_flag
1052: from wip_eam_parameters
1053: where organization_id = p_eam_wo_rec.organization_id;
1054: IF l_auto_firm_create_flag = 'Y' THEN
1055: x_eam_wo_rec.firm_planned_flag := 1;
1056: END IF;

Line 1076: from wip_eam_parameters

1072: and p_eam_wo_rec.status_type = 3
1073: )
1074: THEN
1075: select nvl(auto_firm_flag,'N') into l_auto_firm_flag
1076: from wip_eam_parameters
1077: where organization_id = p_eam_wo_rec.organization_id;
1078: IF l_auto_firm_flag = 'Y' THEN
1079: x_eam_wo_rec.firm_planned_flag := 1;
1080: END IF;

Line 1149: from wip_eam_parameters

1145: p_eam_wo_rec.material_issue_by_mo = FND_API.G_MISS_CHAR
1146: THEN
1147: select nvl(material_issue_by_mo,'N')
1148: into x_eam_wo_rec.material_issue_by_mo
1149: from wip_eam_parameters
1150: where organization_id = p_eam_wo_rec.organization_id;
1151: END IF;
1152:
1153: -- Defaulting the job_quantity