[Home] [Help]
474:
475: IS
476:
477: -- declaring local variables
478: l_vendor_id po_vendors.vendor_id%TYPE;
479: l_supplier_name po_vendors.vendor_name%TYPE;
480: l_po_number po_headers_all.segment1%TYPE;
481: l_header_id po_headers_all.po_header_id%TYPE;
482: l_line_id po_lines_all.po_line_id%TYPE;
475: IS
476:
477: -- declaring local variables
478: l_vendor_id po_vendors.vendor_id%TYPE;
479: l_supplier_name po_vendors.vendor_name%TYPE;
480: l_po_number po_headers_all.segment1%TYPE;
481: l_header_id po_headers_all.po_header_id%TYPE;
482: l_line_id po_lines_all.po_line_id%TYPE;
483: l_line_num po_lines_all.line_num%TYPE;
521: ,po.org_id Poorgid
522: ,substr(pa_expenditures_utils.getorgtlname(po.org_id),1,30) PoOuname
523: ,pod.project_id PoProjectId
524: From po_headers_all po
525: ,po_vendors v
526: ,po_distributions_all pod
527: Where po.vendor_id = v.vendor_id
528: and NVL(po.closed_code,'XX') NOT IN ('FINALLY CLOSED','CLOSED')
529: and pod.po_header_id = po.po_header_id
542: ,po.org_id Poorgid
543: ,substr(pa_expenditures_utils.getorgtlname(po.org_id),1,30) PoOuname
544: ,pod.project_id PoProjectId
545: From po_headers_all po
546: ,po_vendors v
547: ,po_distributions_all pod
548: Where po.vendor_id = v.vendor_id
549: and NVL(po.closed_code,'XX') NOT IN ('FINALLY CLOSED','CLOSED')
550: and pod.po_header_id = po.po_header_id
713: l_ou_name :=null;
714: x_rowid :=null;
715: x_ci_transaction_id :=null;
716: l_error_msg_code := null;
717: l_check_vendor_query := 'select v.vendor_id SupplierId ,v.vendor_name SupplierName From po_vendors v ';
718:
719: /*Check the ci_id and P_CHANGE_TYPE (should be either CREATE or UPDATE) are valid or not*/
720: if p_ci_id is null or p_ci_id = G_PA_MISS_NUM
721: or p_change_type is null or p_change_type = G_PA_MISS_CHAR then