DBA Data[Home] [Help]

APPS.WSM_LBJ_INTERFACE_PVT dependencies on WIP_REVISIONS

Line 8787: wip_revisions.bom_revision (

8783: v_wlji_bom_rev_date(v_idx) := l_rev_date;
8784: end if;
8785: -- BA: bug 3437412 should default to job start date
8786:
8787: wip_revisions.bom_revision (
8788: v_wlji_org_id(v_idx),
8789: v_wlji_item_id(v_idx),
8790: v_wlji_bom_revision(v_idx),
8791: v_wlji_bom_rev_date(v_idx),

Line 8793: wip_revisions.routing_revision (

8789: v_wlji_item_id(v_idx),
8790: v_wlji_bom_revision(v_idx),
8791: v_wlji_bom_rev_date(v_idx),
8792: l_rev_date);
8793: wip_revisions.routing_revision (
8794: v_wlji_org_id(v_idx),
8795: v_wlji_item_id(v_idx),
8796: v_wlji_rtg_revision(v_idx),
8797: v_wlji_rtg_rev_date(v_idx),

Line 9289: wip_revisions.bom_revision (

9285: else
9286: l_rev_date := SYSDATE;
9287: end if;
9288: l_stmt_num := 590.1;
9289: wip_revisions.bom_revision (
9290: v_wlji_org_id(v_idx),
9291: v_wlji_item_id(v_idx),
9292: v_wlji_bom_revision(v_idx),
9293: v_wlji_bom_rev_date(v_idx),

Line 9296: wip_revisions.routing_revision (

9292: v_wlji_bom_revision(v_idx),
9293: v_wlji_bom_rev_date(v_idx),
9294: l_rev_date);
9295: l_stmt_num := 590.2;
9296: wip_revisions.routing_revision (
9297: v_wlji_org_id(v_idx),
9298: v_wlji_item_id(v_idx),
9299: v_wlji_rtg_revision(v_idx),
9300: v_wlji_rtg_rev_date(v_idx),

Line 9646: wip_revisions.bom_revision (

9642: if l_chg_bom_rev = 1 then
9643: -- validate bom rev/rev_date
9644: if l_cur_job_type = 1 then -- standard job
9645: l_stmt_num:= 660.1;
9646: wip_revisions.bom_revision (
9647: v_wlji_org_id(v_idx),
9648: v_wlji_item_id(v_idx),
9649: v_wlji_bom_revision(v_idx),
9650: v_wlji_bom_rev_date(v_idx),

Line 9655: wip_revisions.bom_revision (

9651: l_rev_date);
9652: else
9653: if(v_wlji_bom_ref_id(v_idx) IS NOT NULL) then
9654: l_stmt_num:= 660.2;
9655: wip_revisions.bom_revision (
9656: v_wlji_org_id(v_idx),
9657: v_wlji_bom_ref_id(v_idx),
9658: v_wlji_bom_revision(v_idx),
9659: v_wlji_bom_rev_date(v_idx),

Line 9669: wip_revisions.routing_revision (

9665: if l_chg_rtg_rev = 1 then
9666: -- validate rtg rev/rev_date
9667: if l_cur_job_type = 1 then -- standard job
9668: l_stmt_num:= 670.1;
9669: wip_revisions.routing_revision (
9670: v_wlji_org_id(v_idx),
9671: v_wlji_item_id(v_idx),
9672: v_wlji_rtg_revision(v_idx),
9673: v_wlji_rtg_rev_date(v_idx),

Line 9678: wip_revisions.routing_revision (

9674: l_rev_date);
9675: else
9676: if(v_wlji_rtg_ref_id(v_idx) IS NOT NULL) then
9677: l_stmt_num:= 670.2;
9678: wip_revisions.routing_revision (
9679: v_wlji_org_id(v_idx),
9680: v_wlji_rtg_ref_id(v_idx),
9681: v_wlji_rtg_revision(v_idx),
9682: v_wlji_rtg_rev_date(v_idx),

Line 10703: --wip_revisions.bom_revision (

10699: -- which is not right, instead, we should validate / default
10700: -- the revision of the starting lot, so comment out the following
10701:
10702: --l_rev_date := sysdate;
10703: --wip_revisions.bom_revision (
10704: -- v_wlji_org_id(v_idx),
10705: -- v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id,
10706: -- l_source_item_rev,
10707: -- l_source_item_rev_date,