DBA Data[Home] [Help]

APPS.WSMPOPRN dependencies on WSM_LOT_BASED_JOBS

Line 707: UPDATE WSM_LOT_BASED_JOBS

703: 'WSMPOPRN.add_operation: Inserted '||sql%rowcount||' records in WO.');
704: end if;
705: -- EA: bugfix 2626658/2681671
706: --mes
707: UPDATE WSM_LOT_BASED_JOBS
708: SET current_job_op_seq_num = x_to_op,
709: current_rtg_op_seq_num = null
710: WHERE WIP_ENTITY_ID = x_wip_entity_id;
711:

Line 968: UPDATE WSM_LOT_BASED_JOBS wlbj

964: END IF; --g_aps_wps=1
965: IF (g_aps_wps_profile='Y') THEN
966: l_stat_num := 70;
967:
968: UPDATE WSM_LOT_BASED_JOBS wlbj
969: SET wlbj.on_rec_path = l_recommended_op
970: WHERE wlbj.wip_entity_id = X_Wip_Entity_Id
971: AND wlbj.organization_id = X_Organization_Id
972: AND wlbj.on_rec_path <> l_recommended_op;

Line 3816: UPDATE WSM_LOT_BASED_JOBS

3812: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
3813: AND WO.OPERATION_SEQ_NUM = p_to_job_op_seq_num
3814: AND BSOSC.STANDARD_OPERATION_ID = WO.STANDARD_OPERATION_ID;
3815:
3816: UPDATE WSM_LOT_BASED_JOBS
3817: SET current_job_op_seq_num = p_to_job_op_seq_num,
3818: current_rtg_op_seq_num = p_to_rtg_op_seq_num
3819: WHERE WIP_ENTITY_ID = p_wip_entity_id;
3820: