APPS.WSM_JOBCOPIES_PUB dependencies on WIP_DISCRETE_JOBS

Line 68: l_rtg_revision WIP_DISCRETE_JOBS.ROUTING_REVISION%TYPE; -- Added for 12.1 Refresh Bom/Routing Revision Date Project

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

Line 69: l_bom_revision WIP_DISCRETE_JOBS.BOM_REVISION%TYPE; -- 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
73: fnd_profile.value('CLIENT_TIMEZONE_ID') <>

Line 95: FROM wip_discrete_jobs wdj,

91: -- wdj.bom_revision_date, --commented for 12.1 refresh bom/routing revision date project
92: decode(l_bom_rev_basis,2,l_new_rev_date_bom,wdj.bom_revision_date) bom_revision_date,--12.1 Routing/BOM Revision Date Refresh Programme
93: wdj.wip_supply_type,
94: wdj.status_type
95: FROM wip_discrete_jobs wdj,
96: wip_entities we
97: WHERE we.organization_id = p_org_id
98: AND we.organization_id = wdj.organization_id
99: AND we.wip_entity_id = wdj.wip_entity_id

Line 363: FROM wip_discrete_jobs wdj,

359:
360: IF (g_debug = 'Y') THEN
361: SELECT count(*)
362: INTO l_count
363: FROM wip_discrete_jobs wdj,
364: wip_entities we
365: WHERE we.organization_id = p_org_id
366: AND we.organization_id = wdj.organization_id
367: AND we.wip_entity_id = wdj.wip_entity_id

Line 469: WIP_DISCRETE_JOBS WDJ

465: l_stmt_num := 75;
466: SELECT OAP.acct_period_id
467: INTO l_acct_period_id
468: FROM ORG_ACCT_PERIODS OAP,
469: WIP_DISCRETE_JOBS WDJ
470: WHERE WDJ.WIP_ENTITY_ID = cur_refresh_jobs.wip_entity_id
471: AND WDJ.ORGANIZATION_ID = cur_refresh_jobs.organization_id
472: AND OAP.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
473: AND INV_LE_TIMEZONE_PUB.GET_LE_DAY_FOR_INV_ORG (WDJ.DATE_CLOSED,

Line 587: UPDATE WIP_DISCRETE_JOBS

583: END;
584: END IF;
585:
586:
587: UPDATE WIP_DISCRETE_JOBS
588: SET routing_revision_date = cur_refresh_jobs.routing_revision_date,
589: routing_revision = nvl(l_rtg_revision,routing_revision),
590: bom_revision_date = cur_refresh_jobs.bom_revision_date,
591: bom_revision = nvl(l_bom_revision,bom_revision)