APPS.WSMPJUPD dependencies on WSM_LOT_BASED_JOBS

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

3677: WHEN NO_DATA_FOUND THEN
3678: l_rtg_op_seq_num := null;
3679: END;
3680:
3681: -- Update the WSM_LOT_BASED_JOBS table...
3682: update wsm_lot_based_jobs
3683: set current_rtg_op_seq_num = l_rtg_op_seq_num,
3684: current_job_op_seq_num = l_new_op_added
3685: where wip_entity_id = l_wip_entity_id;

Line 3682: update wsm_lot_based_jobs

3678: l_rtg_op_seq_num := null;
3679: END;
3680:
3681: -- Update the WSM_LOT_BASED_JOBS table...
3682: update wsm_lot_based_jobs
3683: set current_rtg_op_seq_num = l_rtg_op_seq_num,
3684: current_job_op_seq_num = l_new_op_added
3685: where wip_entity_id = l_wip_entity_id;
3686:

Line 4139: UPDATE wsm_lot_based_jobs

4135:
4136: ELSIF (p_copy_mode = 2) THEN -- Make copies at end (for interface ONLY)
4137: l_stmt_num := 30;
4138:
4139: UPDATE wsm_lot_based_jobs
4140: SET internal_copy_type = 2
4141: WHERE wip_entity_id = p_wltx_resulting_jobs_tbl(l_rj_counter).wip_entity_id;
4142:
4143: if( g_log_level_statement >= l_log_level ) then

Line 4167: FROM wsm_lot_based_jobs

4163: SELECT nvl(internal_copy_type, 0),
4164: copy_parent_wip_entity_id
4165: INTO l_new_job_int_copy_type,
4166: l_rep_job_par_we_id
4167: FROM wsm_lot_based_jobs
4168: WHERE wip_entity_id = l_rep_wip_entity_id;
4169: -- for interface copy purpose.... end
4170:
4171: IF (l_new_job_int_copy_type < 1) THEN

Line 4258: UPDATE wsm_lot_based_jobs

4254: ELSIF (p_copy_mode = 2) THEN -- Make copies at end (for interface ONLY)
4255:
4256: l_stmt_num := 80;
4257:
4258: UPDATE wsm_lot_based_jobs
4259: SET internal_copy_type = l_new_job_int_copy_type
4260: WHERE wip_entity_id = p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id;
4261:
4262: if( g_log_level_statement >= l_log_level ) then

Line 4277: UPDATE wsm_lot_based_jobs

4273: IF (l_new_job_int_copy_type = 1) THEN -- If current job's copy_type = 1
4274:
4275: l_stmt_num := 100;
4276:
4277: UPDATE wsm_lot_based_jobs
4278: SET copy_parent_wip_entity_id = nvl(l_rep_job_par_we_id, l_rep_wip_entity_id)
4279: WHERE wip_entity_id = p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id;
4280:
4281: if( g_log_level_statement >= l_log_level ) then

Line 4401: UPDATE wsm_lot_based_jobs

4397: ELSIF (p_copy_mode = 2) THEN -- Make copies at end (for interface ONLY)
4398:
4399: l_stmt_num := 120;
4400:
4401: UPDATE wsm_lot_based_jobs
4402: SET internal_copy_type = 2
4403: WHERE wip_entity_id = p_wltx_resulting_jobs_tbl(l_job_counter).wip_entity_id;
4404:
4405: if( g_log_level_statement >= l_log_level ) then

Line 4532: UPDATE wsm_lot_based_jobs

4528:
4529: ELSIF (p_copy_mode = 2) THEN -- Make copies at end (for interface ONLY)
4530: l_stmt_num := 150;
4531:
4532: UPDATE wsm_lot_based_jobs
4533: SET internal_copy_type = 2
4534: WHERE wip_entity_id = l_rep_wip_entity_id;
4535:
4536: if( g_log_level_statement >= l_log_level ) then

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

4598:
4599: /*-----------------------------------------------------------------+
4600: | Name : CALL_INF_SCH_OR_SET_SCH_DATA
4601: | This procedure calls the Infinite Scheduler
4602: | or sets data in wsm_lot_based_jobs table the Inf.Scheduler
4603: -------------------------------------------------------------------*/
4604:
4605: PROCEDURE CALL_INF_SCH_OR_SET_SCH_DATA (p_txn_id IN NUMBER,
4606: p_copy_mode IN NUMBER,

Line 4640: FROM WSM_LOT_BASED_JOBS

4636: -- ST : Fix for bug 5181364
4637: -- Changed the scheduling path to forwards scheduling instead of midpoint forward
4638: SELECT decode(on_rec_path, 'Y', WIP_CONSTANTS.FORWARDS, WIP_CONSTANTS.CURRENT_OP)
4639: INTO l_schedule_mode
4640: FROM WSM_LOT_BASED_JOBS
4641: WHERE wip_entity_id = p_par_we_id;
4642:
4643: l_stmt_num := 30;
4644:

Line 4717: UPDATE wsm_lot_based_jobs

4713: ELSIF (p_copy_mode = 2) THEN -- Make copies at end (for interface ONLY)
4714:
4715: l_stmt_num := 60;
4716:
4717: UPDATE wsm_lot_based_jobs
4718: SET infinite_schedule = 'Y'
4719: WHERE wip_entity_id = p_par_we_id;
4720:
4721: END IF; --p_copy_mode

Line 6112: update wsm_lot_based_jobs

6108: END;
6109:
6110: l_stmt_num := 283;
6111: forall i in indices of l_new_rj_we_id_tbl
6112: update wsm_lot_based_jobs
6113: set CURRENT_RTG_OP_SEQ_NUM = l_current_rtg_op_seq_num,
6114: CURRENT_JOB_OP_SEQ_NUM = l_current_job_op_seq_num
6115: where wip_entity_id = l_new_rj_we_id_tbl(i)
6116: and CURRENT_RTG_OP_SEQ_NUM is null

Line 7192: INSERT into WSM_LOT_BASED_JOBS

7188:
7189: /*insert into WLBJ here as not handled in new CREATE_WSOR_WLBJ_RECORDS,the new MES columns are also handled here*/
7190: l_stmt_num:=105;
7191:
7192: INSERT into WSM_LOT_BASED_JOBS
7193: (WIP_ENTITY_ID,
7194: ORGANIZATION_ID,
7195: ON_REC_PATH,
7196: INTERNAL_COPY_TYPE,