APPS.PO_INTERFACE_S2 dependencies on PO_REQUISITION_LINES_ALL

Line 40: l_doc_type_code PO_REQUISITION_LINES_ALL.document_type_code%TYPE;

36:
37: x_source_line_num number := null;
38: x_progress varchar2(3) ;
39:
40: l_doc_type_code PO_REQUISITION_LINES_ALL.document_type_code%TYPE;
41: BEGIN
42:
43: x_progress:='000';
44:

Line 225: l_reqs_in_pool_flag PO_REQUISITION_LINES_ALL.reqs_in_pool_flag%TYPE;

221: p_req_line_id IN NUMBER
222: )
223: RETURN BOOLEAN
224: IS
225: l_reqs_in_pool_flag PO_REQUISITION_LINES_ALL.reqs_in_pool_flag%TYPE;
226: -- variable deletion
227:
228: BEGIN
229:

Line 233: FROM po_requisition_lines_all

229:
230: --
231: SELECT reqs_in_pool_flag
232: INTO l_reqs_in_pool_flag
233: FROM po_requisition_lines_all
234: WHERE requisition_line_id = p_req_line_id;
235:
236: IF (l_reqs_in_pool_flag = 'Y') THEN
237: return (TRUE);