APPS.WIP_OPERATIONS_INFO dependencies on WIP_CONSTANTS

Line 77: wip_constants.get_ora_error(

73: return;
74:
75: exception
76: when others then
77: wip_constants.get_ora_error(
78: application => 'WIP',
79: proc_name => 'WIP_OPERATIONS_PKG.DERIVE_INFO');
80: fnd_message.raise_error;
81: end derive_info;

Line 109: WIP_CONSTANTS.YES allow_moves

105: wo.department_id,
106: bd.department_code,
107: wo.minimum_transfer_quantity,
108: wo.quantity_waiting_to_move,
109: WIP_CONSTANTS.YES allow_moves
110: from bom_standard_operations bso,
111: bom_departments bd,
112: wip_operations wo
113: where wo.operation_seq_num =

Line 143: and ws.intraoperation_step_type = WIP_CONSTANTS.TOMOVE

139: and (ws.line_id is NULL
140: or
141: ws.line_id = c_line_id)
142: and ws.operation_seq_num = wo.operation_seq_num
143: and ws.intraoperation_step_type = WIP_CONSTANTS.TOMOVE
144: and ws.shop_floor_status_code = wsc.shop_floor_status_code
145: and wsc.status_move_flag = WIP_CONSTANTS.NO
146: and nvl(wsc.disable_date, SYSDATE + 1) > SYSDATE);
147:

Line 145: and wsc.status_move_flag = WIP_CONSTANTS.NO

141: ws.line_id = c_line_id)
142: and ws.operation_seq_num = wo.operation_seq_num
143: and ws.intraoperation_step_type = WIP_CONSTANTS.TOMOVE
144: and ws.shop_floor_status_code = wsc.shop_floor_status_code
145: and wsc.status_move_flag = WIP_CONSTANTS.NO
146: and nvl(wsc.disable_date, SYSDATE + 1) > SYSDATE);
147:
148: cursor get_last_operation_no(
149: c_org_id number,

Line 160: WIP_CONSTANTS.NO allow_moves

156: wo.department_id,
157: bd.department_code,
158: wo.minimum_transfer_quantity,
159: wo.quantity_waiting_to_move,
160: WIP_CONSTANTS.NO allow_moves
161: from bom_standard_operations bso,
162: bom_departments bd,
163: wip_operations wo
164: where wo.operation_seq_num =

Line 194: and ws.intraoperation_step_type = WIP_CONSTANTS.TOMOVE

190: and (ws.line_id is NULL
191: or
192: ws.line_id = c_line_id)
193: and ws.operation_seq_num = wo.operation_seq_num
194: and ws.intraoperation_step_type = WIP_CONSTANTS.TOMOVE
195: and ws.shop_floor_status_code = wsc.shop_floor_status_code
196: and wsc.status_move_flag = WIP_CONSTANTS.NO
197: and nvl(wsc.disable_date, SYSDATE + 1) > SYSDATE);
198:

Line 196: and wsc.status_move_flag = WIP_CONSTANTS.NO

192: ws.line_id = c_line_id)
193: and ws.operation_seq_num = wo.operation_seq_num
194: and ws.intraoperation_step_type = WIP_CONSTANTS.TOMOVE
195: and ws.shop_floor_status_code = wsc.shop_floor_status_code
196: and wsc.status_move_flag = WIP_CONSTANTS.NO
197: and nvl(wsc.disable_date, SYSDATE + 1) > SYSDATE);
198:
199: yes_vals get_last_operation_yes%ROWTYPE;
200: no_vals get_last_operation_no%ROWTYPE;

Line 222: p_last_move_allowed := WIP_CONSTANTS.YES;

218: p_last_dept_id := yes_vals.department_id;
219: p_last_dept_code := yes_vals.department_code;
220: p_last_op_min_transfer_qty := yes_vals.minimum_transfer_quantity;
221: p_last_op_move_quantity := yes_vals.quantity_waiting_to_move;
222: p_last_move_allowed := WIP_CONSTANTS.YES;
223: elsif (get_last_operation_no%FOUND) then
224: p_last_op_seq := no_vals.operation_seq_num;
225: p_last_op_code := no_vals.operation_code;
226: p_last_dept_id := no_vals.department_id;

Line 230: p_last_move_allowed := WIP_CONSTANTS.NO;

226: p_last_dept_id := no_vals.department_id;
227: p_last_dept_code := no_vals.department_code;
228: p_last_op_min_transfer_qty := no_vals.minimum_transfer_quantity;
229: p_last_op_move_quantity := no_vals.quantity_waiting_to_move;
230: p_last_move_allowed := WIP_CONSTANTS.NO;
231: else
232: p_last_op_seq := -1;
233: p_last_op_code := NULL;
234: p_last_dept_id := NULL;

Line 238: p_last_move_allowed := WIP_CONSTANTS.YES;

234: p_last_dept_id := NULL;
235: p_last_dept_code := NULL;
236: p_last_op_min_transfer_qty := NULL;
237: p_last_op_move_quantity := NULL;
238: p_last_move_allowed := WIP_CONSTANTS.YES;
239: end if;
240:
241: close get_last_operation_yes;
242: close get_last_operation_no;