DBA Data[Home] [Help]

APPS.EAM_WO_CHANGE_STATUS_PVT dependencies on WIP_CONSTANTS

Line 54: ,p_to_status_type IN NUMBER := wip_constants.unreleased

50: ,p_commit IN VARCHAR2 := fnd_api.g_false
51: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
52: ,p_wip_entity_id IN NUMBER
53: ,p_organization_id IN NUMBER
54: ,p_to_status_type IN NUMBER := wip_constants.unreleased
55: ,p_user_id IN NUMBER := null
56: ,p_responsibility_id IN NUMBER := null
57: ,p_date_released IN DATE := sysdate
58: , p_report_type IN NUMBER := null

Line 187: IF l_to_status_type NOT IN (WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG, WIP_CONSTANTS.CLOSED,

183:
184: -- Validate status_id
185: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Status'); END IF;
186:
187: IF l_to_status_type NOT IN (WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG, WIP_CONSTANTS.CLOSED,
188: WIP_CONSTANTS.HOLD, WIP_CONSTANTS.CANCELLED, WIP_CONSTANTS.PEND_SCHED, WIP_CONSTANTS.DRAFT)
189: THEN
190:
191: raise fnd_api.g_exc_unexpected_error;

Line 188: WIP_CONSTANTS.HOLD, WIP_CONSTANTS.CANCELLED, WIP_CONSTANTS.PEND_SCHED, WIP_CONSTANTS.DRAFT)

184: -- Validate status_id
185: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Status'); END IF;
186:
187: IF l_to_status_type NOT IN (WIP_CONSTANTS.UNRELEASED,WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG, WIP_CONSTANTS.CLOSED,
188: WIP_CONSTANTS.HOLD, WIP_CONSTANTS.CANCELLED, WIP_CONSTANTS.PEND_SCHED, WIP_CONSTANTS.DRAFT)
189: THEN
190:
191: raise fnd_api.g_exc_unexpected_error;
192:

Line 295: p_to_status_type = wip_constants.unreleased

291: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Chaning to Unreleased Status'); END IF;
292:
293:
294: IF p_work_order_mode <> EAM_PROCESS_WO_PVT.G_OPR_CREATE and
295: p_to_status_type = wip_constants.unreleased
296: THEN
297: EAM_ASSET_LOG_PVT.INSERT_ROW
298: (
299: p_api_version => 1.0,

Line 459: IF (l_po_creation_time = WIP_CONSTANTS.AT_JOB_SCHEDULE_RELEASE) THEN

455: -- Create Requisitions for OSP
456: IF ((l_to_status_type in (3)) AND (l_current_status in (1,6,17))) THEN
457:
458: --IF po_creation_time for workorder is at_job_schedule_release then only create requisitions
459: IF (l_po_creation_time = WIP_CONSTANTS.AT_JOB_SCHEDULE_RELEASE) THEN
460: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Creating osp req at release and po_creation_time correct'); END IF;
461: create_osp_req_at_rel(
462: p_wip_entity_id => l_wip_entity_id,
463: p_organization_id => l_organization_id);

Line 558: ( p_to_status_type = wip_constants.released)

554: null;
555: END;
556:
557: IF p_work_order_mode <> EAM_PROCESS_WO_PVT.G_OPR_CREATE and
558: ( p_to_status_type = wip_constants.released)
559: THEN
560: EAM_ASSET_LOG_PVT.INSERT_ROW
561: (
562: p_api_version => 1.0,

Line 1035: AND WOR.AUTOCHARGE_TYPE = WIP_CONSTANTS.PO_RECEIPT

1031: AND WO.ORGANIZATION_ID = p_organization_id
1032: AND WOR.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
1033: AND WOR.ORGANIZATION_ID = WO.ORGANIZATION_ID
1034: AND WOR.OPERATION_SEQ_NUM = WO.OPERATION_SEQ_NUM
1035: AND WOR.AUTOCHARGE_TYPE = WIP_CONSTANTS.PO_RECEIPT
1036: AND WO.COUNT_POINT_TYPE <> WIP_CONSTANTS.NO_DIRECT;
1037: l_call_req_import VARCHAR2(10);
1038: l_request_id number;
1039: l_ou_id number;

Line 1036: AND WO.COUNT_POINT_TYPE <> WIP_CONSTANTS.NO_DIRECT;

1032: AND WOR.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
1033: AND WOR.ORGANIZATION_ID = WO.ORGANIZATION_ID
1034: AND WOR.OPERATION_SEQ_NUM = WO.OPERATION_SEQ_NUM
1035: AND WOR.AUTOCHARGE_TYPE = WIP_CONSTANTS.PO_RECEIPT
1036: AND WO.COUNT_POINT_TYPE <> WIP_CONSTANTS.NO_DIRECT;
1037: l_call_req_import VARCHAR2(10);
1038: l_request_id number;
1039: l_ou_id number;
1040: l_wip_error_flag Number := 0; /*Added for FP 6814440*/