[Home] [Help]
318:
319: select nvl(min(period_start_date), sysdate+1)
320: into l_open_acct_per_date
321: from org_acct_periods
322: where organization_id = (select organization_id from wip_discrete_jobs where wip_entity_id = p_wip_entity_id)
323: and open_flag = 'Y';
324:
325: if (l_act_st_date is not null) and (l_act_duration is not null) then
326: if (l_act_end_date > sysdate) then
1466:
1467: -- get start quantity
1468: select start_quantity
1469: into l_start_quantity
1470: from wip_discrete_jobs wdj
1471: where wdj.wip_entity_id = p_wip_entity_id;
1472:
1473: if(l_start_quantity <> 1 ) then
1474: eam_execution_jsp.add_message(p_app_short_name => 'EAM', p_msg_name => 'EAM_HANDOVER_S_QUANTITY_INV');
2681: */
2682: if(p_one_step_issue = fnd_api.g_true) then
2683: l_wo_changed := TRUE;
2684: select material_issue_by_mo into l_material_issue_by_mo_temp
2685: from wip_discrete_jobs
2686: where
2687: wip_entity_id = p_wip_entity_id and
2688: organization_id = p_organization_id;
2689: update wip_discrete_jobs set material_issue_by_mo='N'
2685: from wip_discrete_jobs
2686: where
2687: wip_entity_id = p_wip_entity_id and
2688: organization_id = p_organization_id;
2689: update wip_discrete_jobs set material_issue_by_mo='N'
2690: where
2691: wip_entity_id = p_wip_entity_id and
2692: organization_id = p_organization_id;
2693: end if; -- end of p_one_step_issue check
2856: END IF ; -- Material does not exist
2857:
2858: /* To check whether the WDJ table was changed before call to WO API */
2859: if(l_wo_changed = true) then
2860: update wip_discrete_jobs set material_issue_by_mo=l_material_issue_by_mo_temp
2861: where
2862: wip_entity_id = p_wip_entity_id and
2863: organization_id = p_organization_id;
2864: end if; -- end of l_wo_changed check
4219:
4220: select status_type , nvl(firm_planned_flag,2), scheduled_start_date,
4221: scheduled_completion_date
4222: into l_status_type, l_firm, l_start_date, l_completion_date
4223: from wip_discrete_jobs
4224: where wip_entity_id = l_wip_entity_id
4225: and organization_id = l_organization_id;
4226:
4227: -- Get WPS Parameters