APPS.WSMPJUPD dependencies on WSM_LOT_BASED_JOBS

Line 3687: -- Update the WSM_LOT_BASED_JOBS table...

3683: WHEN NO_DATA_FOUND THEN
3684: l_rtg_op_seq_num := null;
3685: END;
3686:
3687: -- Update the WSM_LOT_BASED_JOBS table...
3688: update wsm_lot_based_jobs
3689: set current_rtg_op_seq_num = l_rtg_op_seq_num,
3690: current_job_op_seq_num = l_new_op_added
3691: where wip_entity_id = l_wip_entity_id;

Line 3688: update wsm_lot_based_jobs

3684: l_rtg_op_seq_num := null;
3685: END;
3686:
3687: -- Update the WSM_LOT_BASED_JOBS table...
3688: update wsm_lot_based_jobs
3689: set current_rtg_op_seq_num = l_rtg_op_seq_num,
3690: current_job_op_seq_num = l_new_op_added
3691: where wip_entity_id = l_wip_entity_id;
3692:

Line 4147: UPDATE wsm_lot_based_jobs

4143: l_stmt_num := 30;
4144: -- Added for Bug 8507313.
4145: l_rj_counter := p_wltx_resulting_jobs_tbl.first;
4146:
4147: UPDATE wsm_lot_based_jobs
4148: SET internal_copy_type = 2
4149: WHERE wip_entity_id = p_wltx_resulting_jobs_tbl(l_rj_counter).wip_entity_id;
4150:
4151: if( g_log_level_statement >= l_log_level ) then

Line 4175: FROM wsm_lot_based_jobs

4171: SELECT nvl(internal_copy_type, 0),
4172: copy_parent_wip_entity_id
4173: INTO l_new_job_int_copy_type,
4174: l_rep_job_par_we_id
4175: FROM wsm_lot_based_jobs
4176: WHERE wip_entity_id = l_rep_wip_entity_id;
4177: -- for interface copy purpose.... end
4178:
4179: IF (l_new_job_int_copy_type < 1) THEN

Line 4266: UPDATE wsm_lot_based_jobs

4262: ELSIF (p_copy_mode = 2) THEN -- Make copies at end (for interface ONLY)
4263:
4264: l_stmt_num := 80;
4265:
4266: UPDATE wsm_lot_based_jobs
4267: SET internal_copy_type = l_new_job_int_copy_type
4268: WHERE wip_entity_id = p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id;
4269:
4270: if( g_log_level_statement >= l_log_level ) then

Line 4285: UPDATE wsm_lot_based_jobs

4281: IF (l_new_job_int_copy_type = 1) THEN -- If current job's copy_type = 1
4282:
4283: l_stmt_num := 100;
4284:
4285: UPDATE wsm_lot_based_jobs
4286: SET copy_parent_wip_entity_id = nvl(l_rep_job_par_we_id, l_rep_wip_entity_id)
4287: WHERE wip_entity_id = p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id;
4288:
4289: if( g_log_level_statement >= l_log_level ) then

Line 4409: UPDATE wsm_lot_based_jobs

4405: ELSIF (p_copy_mode = 2) THEN -- Make copies at end (for interface ONLY)
4406:
4407: l_stmt_num := 120;
4408:
4409: UPDATE wsm_lot_based_jobs
4410: SET internal_copy_type = 2
4411: WHERE wip_entity_id = p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id;
4412:
4413: if( g_log_level_statement >= l_log_level ) then

Line 4540: UPDATE wsm_lot_based_jobs

4536:
4537: ELSIF (p_copy_mode = 2) THEN -- Make copies at end (for interface ONLY)
4538: l_stmt_num := 150;
4539:
4540: UPDATE wsm_lot_based_jobs
4541: SET internal_copy_type = 2
4542: WHERE wip_entity_id = l_rep_wip_entity_id;
4543:
4544: if( g_log_level_statement >= l_log_level ) then

Line 4610: | or sets data in wsm_lot_based_jobs table the Inf.Scheduler

4606:
4607: /*-----------------------------------------------------------------+
4608: | Name : CALL_INF_SCH_OR_SET_SCH_DATA
4609: | This procedure calls the Infinite Scheduler
4610: | or sets data in wsm_lot_based_jobs table the Inf.Scheduler
4611: -------------------------------------------------------------------*/
4612:
4613: PROCEDURE CALL_INF_SCH_OR_SET_SCH_DATA (p_txn_id IN NUMBER,
4614: p_copy_mode IN NUMBER,

Line 4648: FROM WSM_LOT_BASED_JOBS

4644: -- ST : Fix for bug 5181364
4645: -- Changed the scheduling path to forwards scheduling instead of midpoint forward
4646: SELECT decode(on_rec_path, 'Y', WIP_CONSTANTS.FORWARDS, WIP_CONSTANTS.CURRENT_OP)
4647: INTO l_schedule_mode
4648: FROM WSM_LOT_BASED_JOBS
4649: WHERE wip_entity_id = p_par_we_id;
4650:
4651: l_stmt_num := 30;
4652:

Line 4725: UPDATE wsm_lot_based_jobs

4721: ELSIF (p_copy_mode = 2) THEN -- Make copies at end (for interface ONLY)
4722:
4723: l_stmt_num := 60;
4724:
4725: UPDATE wsm_lot_based_jobs
4726: SET infinite_schedule = 'Y'
4727: WHERE wip_entity_id = p_par_we_id;
4728:
4729: END IF; --p_copy_mode

Line 6176: update wsm_lot_based_jobs

6172: END;
6173:
6174: l_stmt_num := 283;
6175: forall i in indices of l_new_rj_we_id_tbl
6176: update wsm_lot_based_jobs
6177: set CURRENT_RTG_OP_SEQ_NUM = l_current_rtg_op_seq_num,
6178: CURRENT_JOB_OP_SEQ_NUM = l_current_job_op_seq_num
6179: where wip_entity_id = l_new_rj_we_id_tbl(i)
6180: and CURRENT_RTG_OP_SEQ_NUM is null

Line 7256: INSERT into WSM_LOT_BASED_JOBS

7252:
7253: /*insert into WLBJ here as not handled in new CREATE_WSOR_WLBJ_RECORDS,the new MES columns are also handled here*/
7254: l_stmt_num:=105;
7255:
7256: INSERT into WSM_LOT_BASED_JOBS
7257: (WIP_ENTITY_ID,
7258: ORGANIZATION_ID,
7259: ON_REC_PATH,
7260: INTERNAL_COPY_TYPE,