APPS.WSM_LBJ_INTERFACE_PVT dependencies on WSM_LOT_BASED_JOBS

Line 11537: from wsm_lot_based_jobs

11533:
11534: BEGIN
11535: select on_rec_path
11536: into l_on_reco_path
11537: from wsm_lot_based_jobs
11538: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
11539: l_stmt_num := 985.1;
11540: if(l_on_reco_path = 'Y' ) then
11541: if(l_scheduling_mode = WIP_CONSTANTS.FORWARDS) then

Line 11587: /* update wsm_lot_based_jobs

11583:
11584: --
11585: -- Begin R12Dev Update to set the current_job/rtg_op_seq_num on WLBJ
11586: --Bug 4748165
11587: /* update wsm_lot_based_jobs
11588: set (current_job_op_seq_num,
11589: current_rtg_op_seq_num)
11590: =(select wo.operation_seq_num,
11591: wo.wsm_op_seq_num

Line 17068: update wsm_lot_based_jobs

17064: -- }} End: Update WCO, WCON to mark the recommended operation
17065:
17066: l_stmt_num := 70.5;
17067: -- mark wlbj.on_rec_path flag
17068: update wsm_lot_based_jobs
17069: set on_rec_path = l_on_reco_path
17070: where wip_entity_id = p_wip_entity_id
17071: and organization_id = p_org_id;
17072:

Line 17197: update wsm_lot_based_jobs

17193: where wip_entity_id = p_wip_entity_id
17194: and recommended = 'N';
17195:
17196: -- mark wlbj.on_rec_path flag
17197: update wsm_lot_based_jobs
17198: set on_rec_path = l_on_reco_path
17199: where wip_entity_id = p_wip_entity_id
17200: and organization_id = p_org_id;
17201:

Line 21446: update wsm_lot_based_jobs

21442: ||l_stmt_num||'): '|| SQL%ROWCOUNT);
21443: end if;
21444: -- }} Update quantity
21445: if (p_status_type = 3) then
21446: update wsm_lot_based_jobs
21447: set (current_job_op_seq_num,
21448: current_rtg_op_seq_num)
21449: =(select wo.operation_seq_num,
21450: wo.wsm_op_seq_num

Line 21472: update wsm_lot_based_jobs

21468: --
21469: /*
21470: if (p_status_type = 3) then
21471:
21472: update wsm_lot_based_jobs
21473: set (current_job_op_seq_num,
21474: current_rtg_op_seq_num)
21475: =(select wo.operation_seq_num,
21476: wo.wsm_op_seq_num

Line 21889: insert into wsm_lot_based_jobs (

21885:
21886: l_stmt_num := 135;
21887: -- insert into WLBJ
21888: if g_skip_wlbj <> 1 THEN --OPTII-PERF: This will be created in create_jobcopies
21889: insert into wsm_lot_based_jobs (
21890: wip_entity_id,
21891: organization_id,
21892: on_rec_path,
21893: internal_copy_type,