APPS.WSMPOPRN dependencies on WSM_PARAMETERS

Line 211: FROM wsm_parameters

207: SELECT --nvl(last_operation_seq_num, 9999), -- DEL: CZH.I_9999
208: nvl(op_seq_num_increment, 10)
209: INTO --l_last_op_seq, -- DEL: CZH.I_9999
210: l_op_seq_incr
211: FROM wsm_parameters
212: WHERE organization_id = X_Organization_Id;
213:
214: -- BC: CZH.BUG2168828, should call disable_operations even move to last operation
215: IF (x_from_op = x_to_op)

Line 250: FROM wsm_parameters

246: FROM wip_operations
247: WHERE WIP_ENTITY_ID = x_wip_entity_id
248: AND operation_seq_num NOT IN
249: ( SELECT nvl(last_operation_seq_num, 9999)
250: FROM wsm_parameters
251: WHERE organization_id = x_organization_id ) ;
252: EXCEPTION
253: WHEN NO_DATA_FOUND THEN
254: l_max_op_seq := 0;

Line 1167: -- FROM wsm_parameters

1163: AND operation_seq_num > x_from_op;
1164: -- BD: CZH.I_9999
1165: --AND operation_seq_num NOT IN
1166: -- (SELECT nvl(last_operation_seq_num, 9999)
1167: -- FROM wsm_parameters
1168: -- WHERE organization_id = x_organization_id ) ;
1169: -- ED: CZH.I_9999
1170:
1171: -- bug 3203505 change order of update WOR and WRO

Line 1179: -- FROM wsm_parameters

1175: AND operation_seq_num > x_from_op;
1176: -- BD: CZH.I_9999
1177: --AND operation_seq_num NOT IN
1178: -- (SELECT nvl(last_operation_seq_num, 9999)
1179: -- FROM wsm_parameters
1180: -- WHERE organization_id = x_organization_id ) ;
1181: -- ED: CZH.I_9999
1182:
1183: UPDATE wip_requirement_operations

Line 1191: -- FROM wsm_parameters

1187: AND operation_seq_num > x_from_op;
1188: -- BD: CZH.I_9999
1189: --AND operation_seq_num NOT IN
1190: -- (SELECT nvl(last_operation_seq_num, 9999)
1191: -- FROM wsm_parameters
1192: -- WHERE organization_id = x_organization_id ) ;
1193: -- ED: CZH.I_9999
1194:
1195: EXCEPTION

Line 1901: from wsm_parameters

1897: --End Fix bug #1504009
1898:
1899: select JOB_COMPLETION_SEPARATOR,nvl(REUSE_JOBNAME,1)
1900: into l_sep,l_reuse_jobname
1901: from wsm_parameters
1902: where organization_id = p_org_id;
1903:
1904: -- The below condition is modified for 12.1 enhancement.
1905: -- If reuse job name is set to 'yes' then only we need to append sector extension.