APPS.EAM_OP_COMP_VALIDATE_PVT dependencies on WIP_DISCRETE_JOBS

Line 141: FROM wip_discrete_jobs

137:
138: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_COMPLETE
139: THEN
140: SELECT shutdown_type into l_shutdown_type
141: FROM wip_discrete_jobs
142: WHERE wip_entity_id = p_eam_op_comp_rec.wip_entity_id;
143:
144: IF l_shutdown_type IS NOT NULL THEN
145: IF p_eam_op_comp_rec.shutdown_start_date IS NULL OR p_eam_op_comp_rec.shutdown_end_date IS NULL THEN

Line 381: WHERE organization_id = (select organization_id from wip_discrete_jobs where wip_entity_id = p_eam_op_comp_rec.wip_entity_id)

377: BEGIN
378: SELECT NVL(MIN(period_start_date), sysdate+1)
379: INTO l_open_acct_per_date
380: FROM org_acct_periods
381: WHERE organization_id = (select organization_id from wip_discrete_jobs where wip_entity_id = p_eam_op_comp_rec.wip_entity_id)
382: AND open_flag = 'Y';
383:
384: IF sysdate < l_open_acct_per_date THEN -- p_transaction_date < l_open_acct_per_date
385: raise fnd_api.g_exc_unexpected_error;

Line 564: FROM wip_discrete_jobs

560: IF p_eam_op_comp_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UNCOMPLETE THEN
561: begin
562: SELECT status_type
563: INTO l_job_status
564: FROM wip_discrete_jobs
565: WHERE wip_entity_id = p_eam_op_comp_rec.wip_entity_id;
566: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Checking status_type ...'); END IF;
567:
568: IF (l_job_status = 4 ) THEN