[Home] [Help]
64: l_rout_rev_basis NUMBER; -- Added for 12.1 Refresh Bom/Routing Revision Date Project
65: l_new_rev_date_rou DATE; -- Added for 12.1 Refresh Bom/Routing Revision Date Project
66: l_bom_rev_basis NUMBER; -- Added for 12.1 Refresh Bom/Routing Revision Date Project
67: l_new_rev_date_bom DATE; -- Added for 12.1 Refresh Bom/Routing Revision Date Project
68: l_rtg_revision WIP_DISCRETE_JOBS.ROUTING_REVISION%TYPE; -- Added for 12.1 Refresh Bom/Routing Revision Date Project
69: l_bom_revision WIP_DISCRETE_JOBS.BOM_REVISION%TYPE; -- Added for 12.1 Refresh Bom/Routing Revision Date Project
70: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
71: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
72: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
65: l_new_rev_date_rou DATE; -- Added for 12.1 Refresh Bom/Routing Revision Date Project
66: l_bom_rev_basis NUMBER; -- Added for 12.1 Refresh Bom/Routing Revision Date Project
67: l_new_rev_date_bom DATE; -- Added for 12.1 Refresh Bom/Routing Revision Date Project
68: l_rtg_revision WIP_DISCRETE_JOBS.ROUTING_REVISION%TYPE; -- Added for 12.1 Refresh Bom/Routing Revision Date Project
69: l_bom_revision WIP_DISCRETE_JOBS.BOM_REVISION%TYPE; -- Added for 12.1 Refresh Bom/Routing Revision Date Project
70: l_timezone_enabled boolean := ( fnd_profile.value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y' AND
71: fnd_profile.value('CLIENT_TIMEZONE_ID') IS NOT NULL AND
72: fnd_profile.value('SERVER_TIMEZONE_ID') IS NOT NULL AND
73: fnd_profile.value('CLIENT_TIMEZONE_ID') <>
95: -- wdj.bom_revision_date, --commented for 12.1 refresh bom/routing revision date project
96: decode(l_bom_rev_basis,2,l_new_rev_date_bom,wdj.bom_revision_date) bom_revision_date,
97: wdj.wip_supply_type,
98: wdj.status_type
99: FROM wip_discrete_jobs wdj,
100: wip_entities we
101: WHERE we.organization_id = p_org_id
102: AND we.organization_id = wdj.organization_id
103: AND we.wip_entity_id = wdj.wip_entity_id
329:
330: IF (g_debug = 'Y') THEN
331: SELECT count(*)
332: INTO l_count
333: FROM wip_discrete_jobs wdj,
334: wip_entities we
335: WHERE we.organization_id = p_org_id
336: AND we.organization_id = wdj.organization_id
337: AND we.wip_entity_id = wdj.wip_entity_id
433: l_stmt_num := 75;
434: SELECT OAP.acct_period_id
435: INTO l_acct_period_id
436: FROM ORG_ACCT_PERIODS OAP,
437: WIP_DISCRETE_JOBS WDJ
438: WHERE WDJ.WIP_ENTITY_ID = cur_refresh_jobs.wip_entity_id
439: AND WDJ.ORGANIZATION_ID = cur_refresh_jobs.organization_id
440: AND OAP.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
441: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (WDJ.DATE_CLOSED,
471: WIP_OPERATION_RESOURCE_USAGE WORU,
472: WIP_SUB_OPERATION_RESOURCES WSOR,
473: WIP_OPERATION_RESOURCES WOR,
474: WIP_OPERATIONS WO,
475: WIP_DISCRETE_JOBS WDJ,
476: WSM_COPY_OPERATIONS WCO,
477: WSM_COPY_OP_NETWORKS WCON,
478: WSM_COPY_OP_RESOURCES WCOR,
479: WSM_COPY_OP_RESOURCE_USAGE WCORU,
502:
503: /* select 1 bulk collect into l_num_tbl
504: from WIP_OPERATION_RESOURCES WOR,
505: WIP_OPERATIONS WO,
506: WIP_DISCRETE_JOBS WDJ,
507: WSM_COPY_OPERATIONS WCO,
508: WSM_COPY_OP_RESOURCES WCOR
509: where WO.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
510: and WO.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
519: for update NOWAIT;
520: */
521:
522: select 1 bulk collect into l_num_tbl
523: from WIP_DISCRETE_JOBS WDJ
524: where WDJ.WIP_ENTITY_ID = cur_refresh_jobs.wip_entity_id
525: and WDJ.ORGANIZATION_ID = cur_refresh_jobs.organization_id
526: for update NOWAIT;
527: l_num_tbl.delete;
634: END;
635: END IF;
636:
637:
638: UPDATE WIP_DISCRETE_JOBS
639: SET routing_revision_date = cur_refresh_jobs.routing_revision_date,
640: routing_revision = nvl(l_rtg_revision,routing_revision),
641: bom_revision_date = cur_refresh_jobs.bom_revision_date,
642: bom_revision = nvl(l_bom_revision,bom_revision)