APPS.WSM_MES_UTILITIES_PVT dependencies on WSM_PARAMETERS

Line 114: from wsm_parameters wp

110: select NVL(move_in_option, 0), -- default: optional
111: NVL(move_to_next_op_option, 0) -- default: optional
112: into l_move_in_option,
113: l_move_next_option
114: from wsm_parameters wp
115: where organization_id = p_org_id;
116:
117: -- check the mandatory steps on standard operation definition
118: -- NOTE: data migrated from wsm_operation_details to bso will be yes/no = 1,2

Line 345: from wsm_parameters wp

341: -- check to see if undo is allowed in the organization as set in the WSM organization parameters
342:
343: select allow_backward_move_flag
344: into l_org_allow_undo
345: from wsm_parameters wp
346: where organization_id = p_org_id;
347:
348: if ( l_org_allow_undo <> 1) then
349: x_allowed := 0;

Line 446: from wsm_parameters

442:
443: l_charge_jump_from_queue := 2;
444: select charge_jump_from_queue
445: into l_charge_jump_from_queue
446: from wsm_parameters
447: where organization_id = p_org_id;
448:
449: if(l_charge_jump_from_queue = 1 and p_intraop_step = 1) then
450: x_allowed := 0;

Line 524: FROM WSM_PARAMETERS

520:
521: -- Optional = 0, Always = 1, Never = 2
522: SELECT nvl(move_in_option, 0), nvl(move_to_next_op_option, 0) --bugfix 5336838 changed from default 2 to 0
523: INTO l_wsm_move_in, l_wsm_move_to_next_op
524: FROM WSM_PARAMETERS
525: WHERE organization_id = p_org_id;
526:
527: -- NOTE: data migrated from wsm_operation_details to bso will be yes/no = 1,2
528: -- and new data in bso is default null = no while updating std ops form gives yes/no = 0,1

Line 908: FROM wsm_parameters

904: if (p_txn_type = 2048) then /* Jump */
905:
906: SELECT nvl(charge_jump_from_queue,2)
907: INTO l_charge_jump_from_queue
908: FROM wsm_parameters
909: WHERE organization_id = l_org_id;
910:
911: if (l_charge_jump_from_queue = 2) then
912: return 1; /* Charge Jump From Queue = No and po reqs or headers exist */