DBA Data[Home] [Help]

APPS.WSM_LBJ_INTERFACE_PVT dependencies on WIP_REVISIONS

Line 8885: wip_revisions.bom_revision (

8881: v_wlji_bom_rev_date(v_idx) := l_rev_date;
8882: end if;
8883: -- BA: bug 3437412 should default to job start date
8884:
8885: wip_revisions.bom_revision (
8886: v_wlji_org_id(v_idx),
8887: v_wlji_item_id(v_idx),
8888: v_wlji_bom_revision(v_idx),
8889: v_wlji_bom_rev_date(v_idx),

Line 8891: wip_revisions.routing_revision (

8887: v_wlji_item_id(v_idx),
8888: v_wlji_bom_revision(v_idx),
8889: v_wlji_bom_rev_date(v_idx),
8890: l_rev_date);
8891: wip_revisions.routing_revision (
8892: v_wlji_org_id(v_idx),
8893: v_wlji_item_id(v_idx),
8894: v_wlji_rtg_revision(v_idx),
8895: v_wlji_rtg_rev_date(v_idx),

Line 9387: wip_revisions.bom_revision (

9383: else
9384: l_rev_date := SYSDATE;
9385: end if;
9386: l_stmt_num := 590.1;
9387: wip_revisions.bom_revision (
9388: v_wlji_org_id(v_idx),
9389: v_wlji_item_id(v_idx),
9390: v_wlji_bom_revision(v_idx),
9391: v_wlji_bom_rev_date(v_idx),

Line 9394: wip_revisions.routing_revision (

9390: v_wlji_bom_revision(v_idx),
9391: v_wlji_bom_rev_date(v_idx),
9392: l_rev_date);
9393: l_stmt_num := 590.2;
9394: wip_revisions.routing_revision (
9395: v_wlji_org_id(v_idx),
9396: v_wlji_item_id(v_idx),
9397: v_wlji_rtg_revision(v_idx),
9398: v_wlji_rtg_rev_date(v_idx),

Line 9744: wip_revisions.bom_revision (

9740: if l_chg_bom_rev = 1 then
9741: -- validate bom rev/rev_date
9742: if l_cur_job_type = 1 then -- standard job
9743: l_stmt_num:= 660.1;
9744: wip_revisions.bom_revision (
9745: v_wlji_org_id(v_idx),
9746: v_wlji_item_id(v_idx),
9747: v_wlji_bom_revision(v_idx),
9748: v_wlji_bom_rev_date(v_idx),

Line 9753: wip_revisions.bom_revision (

9749: l_rev_date);
9750: else
9751: if(v_wlji_bom_ref_id(v_idx) IS NOT NULL) then
9752: l_stmt_num:= 660.2;
9753: wip_revisions.bom_revision (
9754: v_wlji_org_id(v_idx),
9755: v_wlji_bom_ref_id(v_idx),
9756: v_wlji_bom_revision(v_idx),
9757: v_wlji_bom_rev_date(v_idx),

Line 9767: wip_revisions.routing_revision (

9763: if l_chg_rtg_rev = 1 then
9764: -- validate rtg rev/rev_date
9765: if l_cur_job_type = 1 then -- standard job
9766: l_stmt_num:= 670.1;
9767: wip_revisions.routing_revision (
9768: v_wlji_org_id(v_idx),
9769: v_wlji_item_id(v_idx),
9770: v_wlji_rtg_revision(v_idx),
9771: v_wlji_rtg_rev_date(v_idx),

Line 9776: wip_revisions.routing_revision (

9772: l_rev_date);
9773: else
9774: if(v_wlji_rtg_ref_id(v_idx) IS NOT NULL) then
9775: l_stmt_num:= 670.2;
9776: wip_revisions.routing_revision (
9777: v_wlji_org_id(v_idx),
9778: v_wlji_rtg_ref_id(v_idx),
9779: v_wlji_rtg_revision(v_idx),
9780: v_wlji_rtg_rev_date(v_idx),

Line 10805: --wip_revisions.bom_revision (

10801: -- which is not right, instead, we should validate / default
10802: -- the revision of the starting lot, so comment out the following
10803:
10804: --l_rev_date := sysdate;
10805: --wip_revisions.bom_revision (
10806: -- v_wlji_org_id(v_idx),
10807: -- v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id,
10808: -- l_source_item_rev,
10809: -- l_source_item_rev_date,