APPS.PO_AUTOCREATE_DOC dependencies on PO_REQUISITION_LINES_ALL

Line 434: (SELECT 'Y' FROM po_requisition_lines_all prl1

430: pol.GROUP_LINE_ID IS NULL AND
431: pol.CLM_BASE_LINE_NUM is NULL AND
432: Nvl(pol.CLM_INFO_FLAG,'N') = 'N' AND
433: NOT EXISTS
434: (SELECT 'Y' FROM po_requisition_lines_all prl1
435: WHERE prl1.requisition_header_id = poh.requisition_header_id
436: AND prl1.GROUP_LINE_ID = pol.REQUISITION_LINE_ID
437: OR prl1.CLM_BASE_LINE_NUM = pol.REQUISITION_LINE_ID)
438: order by pol.requisition_line_id asc;

Line 888: x_suggested_vendor_name po_requisition_lines_all.suggested_vendor_name%type;

884: resultout OUT NOCOPY VARCHAR2 ) is
885:
886: x_req_line_id number;
887: x_suggested_buyer_id number;
888: x_suggested_vendor_name po_requisition_lines_all.suggested_vendor_name%type;
889: x_suggested_vendor_location varchar2(240);
890:
891: /* Bug 2577940 The vendor id and vendor site id should also be populated from Req line */
892: x_suggested_vendor_id po_requisition_lines_all.vendor_id%type;

Line 892: x_suggested_vendor_id po_requisition_lines_all.vendor_id%type;

888: x_suggested_vendor_name po_requisition_lines_all.suggested_vendor_name%type;
889: x_suggested_vendor_location varchar2(240);
890:
891: /* Bug 2577940 The vendor id and vendor site id should also be populated from Req line */
892: x_suggested_vendor_id po_requisition_lines_all.vendor_id%type;
893: x_suggested_vendor_site_id po_requisition_lines_all.vendor_site_id%type;
894: /* Bug 2577940 */
895:
896: x_source_doc_type_code varchar2(25);

Line 893: x_suggested_vendor_site_id po_requisition_lines_all.vendor_site_id%type;

889: x_suggested_vendor_location varchar2(240);
890:
891: /* Bug 2577940 The vendor id and vendor site id should also be populated from Req line */
892: x_suggested_vendor_id po_requisition_lines_all.vendor_id%type;
893: x_suggested_vendor_site_id po_requisition_lines_all.vendor_site_id%type;
894: /* Bug 2577940 */
895:
896: x_source_doc_type_code varchar2(25);
897: x_source_doc_po_header_id number;

Line 919: l_labor_req_line_id po_requisition_lines_all.labor_req_line_id%TYPE; --

915: x_vendor_site_id number;
916:
917: x_ga_flag varchar2(1) := 'N'; -- FPI GA
918: l_job_id number := null; --
919: l_labor_req_line_id po_requisition_lines_all.labor_req_line_id%TYPE; --
920: x_federal_flag VARCHAR2(1);
921:
922: begin
923:

Line 1249: x_suggested_vendor_name po_requisition_lines_all.suggested_vendor_name%type;

1245: actid IN NUMBER,
1246: funcmode IN VARCHAR2,
1247: resultout OUT NOCOPY VARCHAR2 ) is
1248:
1249: x_suggested_vendor_name po_requisition_lines_all.suggested_vendor_name%type;
1250: x_suggested_vendor_site varchar2(240);
1251:
1252: /* Bug 2577940 */
1253: x_suggested_vendor_id number;

Line 1255: x_vendor po_requisition_lines_all.suggested_vendor_name%type;

1251:
1252: /* Bug 2577940 */
1253: x_suggested_vendor_id number;
1254: x_suggested_vendor_site_id number;
1255: x_vendor po_requisition_lines_all.suggested_vendor_name%type;
1256: x_vendor_site varchar2(240);
1257: /* Bug 2577940 */
1258:
1259: x_valid_vendor varchar2(1);

Line 1631: x_item_currency PO_REQUISITION_LINES_ALL.currency_code%TYPE;

1627: x_supplier_id number;
1628: x_supplier_site_id number;
1629:
1630: x_use_contract_flag varchar2(1);
1631: x_item_currency PO_REQUISITION_LINES_ALL.currency_code%TYPE;
1632:
1633: x_progress varchar2(300) := '000';
1634:
1635: --

Line 6854: x_source_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;

6850: x_source_doc_line_num number;
6851: x_progress varchar2(300) := '000';
6852: x_contract_id_valid number;
6853: x_contract_currency_code varchar2(25);
6854: x_source_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
6855: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE; --
6856: l_base_currency PO_HEADERS_ALL.currency_code%TYPE;
6857: x_is_clm_flow VARCHAR2(1);
6858: begin

Line 7695: FROM po_requisition_lines_all prl

7691: --SQL WHY: This information is needed for passing dest inv org
7692: -- to get_asl_attributes
7693: SELECT prl.destination_organization_id
7694: INTO l_dest_org_id
7695: FROM po_requisition_lines_all prl
7696: WHERE requisition_line_id = l_req_line_id;
7697:
7698: PO_THIRD_PARTY_STOCK_GRP.Get_Asl_Attributes(
7699: p_api_version => 1.0