APPS.PO_AUTOCREATE_DOC dependencies on PO_REQUISITION_LINES_ALL

Line 699: x_suggested_vendor_name po_requisition_lines_all.suggested_vendor_name%type;

695: resultout OUT NOCOPY VARCHAR2 ) is
696:
697: x_req_line_id number;
698: x_suggested_buyer_id number;
699: x_suggested_vendor_name po_requisition_lines_all.suggested_vendor_name%type;
700: x_suggested_vendor_location varchar2(240);
701:
702: /* Bug 2577940 The vendor id and vendor site id should also be populated from Req line */
703: x_suggested_vendor_id po_requisition_lines_all.vendor_id%type;

Line 703: x_suggested_vendor_id po_requisition_lines_all.vendor_id%type;

699: x_suggested_vendor_name po_requisition_lines_all.suggested_vendor_name%type;
700: x_suggested_vendor_location varchar2(240);
701:
702: /* Bug 2577940 The vendor id and vendor site id should also be populated from Req line */
703: x_suggested_vendor_id po_requisition_lines_all.vendor_id%type;
704: x_suggested_vendor_site_id po_requisition_lines_all.vendor_site_id%type;
705: /* Bug 2577940 */
706:
707: x_source_doc_type_code varchar2(25);

Line 704: x_suggested_vendor_site_id po_requisition_lines_all.vendor_site_id%type;

700: x_suggested_vendor_location varchar2(240);
701:
702: /* Bug 2577940 The vendor id and vendor site id should also be populated from Req line */
703: x_suggested_vendor_id po_requisition_lines_all.vendor_id%type;
704: x_suggested_vendor_site_id po_requisition_lines_all.vendor_site_id%type;
705: /* Bug 2577940 */
706:
707: x_source_doc_type_code varchar2(25);
708: x_source_doc_po_header_id number;

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

726: x_vendor_site_id number;
727:
728: x_ga_flag varchar2(1) := 'N'; -- FPI GA
729: l_job_id number := null; --
730: l_labor_req_line_id po_requisition_lines_all.labor_req_line_id%TYPE; --
731:
732: begin
733:
734: x_req_line_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

Line 1048: x_suggested_vendor_name po_requisition_lines_all.suggested_vendor_name%type;

1044: actid IN NUMBER,
1045: funcmode IN VARCHAR2,
1046: resultout OUT NOCOPY VARCHAR2 ) is
1047:
1048: x_suggested_vendor_name po_requisition_lines_all.suggested_vendor_name%type;
1049: x_suggested_vendor_site varchar2(240);
1050:
1051: /* Bug 2577940 */
1052: x_suggested_vendor_id number;

Line 1054: x_vendor po_requisition_lines_all.suggested_vendor_name%type;

1050:
1051: /* Bug 2577940 */
1052: x_suggested_vendor_id number;
1053: x_suggested_vendor_site_id number;
1054: x_vendor po_requisition_lines_all.suggested_vendor_name%type;
1055: x_vendor_site varchar2(240);
1056: /* Bug 2577940 */
1057:
1058: x_valid_vendor varchar2(1);

Line 1414: x_item_currency PO_REQUISITION_LINES_ALL.currency_code%TYPE;

1410: x_supplier_id number;
1411: x_supplier_site_id number;
1412:
1413: x_use_contract_flag varchar2(1);
1414: x_item_currency PO_REQUISITION_LINES_ALL.currency_code%TYPE;
1415:
1416: x_progress varchar2(300) := '000';
1417:
1418: --

Line 6418: x_source_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;

6414: x_source_doc_line_num number;
6415: x_progress varchar2(300) := '000';
6416: x_contract_id_valid number;
6417: x_contract_currency_code varchar2(25);
6418: x_source_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
6419: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE; --
6420: l_base_currency PO_HEADERS_ALL.currency_code%TYPE;
6421: begin
6422:

Line 7242: FROM po_requisition_lines_all prl

7238: --SQL WHY: This information is needed for passing dest inv org
7239: -- to get_asl_attributes
7240: SELECT prl.destination_organization_id
7241: INTO l_dest_org_id
7242: FROM po_requisition_lines_all prl
7243: WHERE requisition_line_id = l_req_line_id;
7244:
7245: PO_THIRD_PARTY_STOCK_GRP.Get_Asl_Attributes(
7246: p_api_version => 1.0