DBA Data[Home] [Help]

APPS.PO_REQS_CONTROL_SV dependencies on PO_REQ_LINES_SV

Line 135: IF po_req_lines_sv.val_reqs_po_shipment(X_req_header_id,

131:
132: -- dbms_output.put_line('Enter val_reqs_action');
133:
134: X_progress := '000';
135: IF po_req_lines_sv.val_reqs_po_shipment(X_req_header_id,
136: X_req_line_id) = FALSE THEN
137: -- dbms_output.put_line('val_reqs_po_shipment return FALSE');
138: /* DEBUG - display req. has open PO shipment message */
139:

Line 162: IF po_req_lines_sv.val_reqs_oe_shipment (X_req_header_id,

158: RETURN (FALSE);
159: END IF;
160:
161: IF X_oe_installed_flag = 'Y' THEN
162: IF po_req_lines_sv.val_reqs_oe_shipment (X_req_header_id,
163: X_req_line_id) = FALSE THEN
164: -- dbms_output.put_line('val_reqs_oe_shipment return FALSE');
165: /* DEBUG - display req. has open OE shipment message */
166: IF SubStr(X_req_control_action,1,6) = 'CANCEL' THEN

Line 189: ** Desc: Call po_req_lines_sv.val_reqs_qty_received to verify if internal

185:
186: END IF;
187:
188: /* Bug# 2607180: kagarwal
189: ** Desc: Call po_req_lines_sv.val_reqs_qty_received to verify if internal
190: ** requisition lines which are sourced from inventory, have been received
191: ** or not. For this we will check if the 'SHIPMENT' supply exists for the
192: ** requisition lines.
193: **

Line 197: IF po_req_lines_sv.val_reqs_qty_received (X_req_header_id,

193: **
194: ** If 'SHIPMENT' supply exists return FALSE.
195: */
196:
197: IF po_req_lines_sv.val_reqs_qty_received (X_req_header_id,
198: X_req_line_id) = FALSE THEN
199: IF SubStr(X_req_control_action,1,6) = 'CANCEL' THEN
200: X_action_code := SubStr(X_req_control_action,1,6);
201: ELSE

Line 224: IF po_req_lines_sv.val_reqs_qty_delivered (X_req_header_id,

220:
221:
222: IF X_encumbrance_flag = 'Y' THEN
223:
224: IF po_req_lines_sv.val_reqs_qty_delivered (X_req_header_id,
225: X_req_line_id) = FALSE THEN
226:
227: -- dbms_output.put_line('val_reqs_qty_delivered return FALSE');
228: /* DEBUG - display PO_RQCON_NOT_DELIVERED message */

Line 235: po_req_lines_sv.update_reqs_lines_incomplete (X_req_header_id,

231:
232: END IF;
233:
234: IF SubStr(X_req_control_action,1,6) = 'CANCEL' THEN
235: po_req_lines_sv.update_reqs_lines_incomplete (X_req_header_id,
236: X_req_line_id,
237: X_req_control_error_rc,
238: X_oe_installed_flag);
239: IF X_req_control_error_rc = 'Y' THEN

Line 367: po_req_lines_sv.update_reqs_lines_status (X_req_header_id,

363:
364: -- END IF;
365:
366:
367: po_req_lines_sv.update_reqs_lines_status (X_req_header_id,
368: X_req_line_id,
369: X_req_control_action,
370: X_req_control_reason,
371: X_req_action_date,