APPS.PO_COPY_DOCUMENTS_S dependencies on PO_LINES

Line 535: l_po_category_id po_lines.category_id%TYPE;

531: x_item_id mtl_system_items.inventory_item_id%type;
532: x_new_tax_flag varchar2(1):=null;
533:
534: -- Bug#5401155
535: l_po_category_id po_lines.category_id%TYPE;
536: l_ip_category_id po_lines.ip_category_id%TYPE;
537: l_item_description po_lines.item_description%TYPE;
538: l_item_id po_lines.item_id%TYPE;
539: l_org_id po_lines.org_id%TYPE;

Line 536: l_ip_category_id po_lines.ip_category_id%TYPE;

532: x_new_tax_flag varchar2(1):=null;
533:
534: -- Bug#5401155
535: l_po_category_id po_lines.category_id%TYPE;
536: l_ip_category_id po_lines.ip_category_id%TYPE;
537: l_item_description po_lines.item_description%TYPE;
538: l_item_id po_lines.item_id%TYPE;
539: l_org_id po_lines.org_id%TYPE;
540:

Line 537: l_item_description po_lines.item_description%TYPE;

533:
534: -- Bug#5401155
535: l_po_category_id po_lines.category_id%TYPE;
536: l_ip_category_id po_lines.ip_category_id%TYPE;
537: l_item_description po_lines.item_description%TYPE;
538: l_item_id po_lines.item_id%TYPE;
539: l_org_id po_lines.org_id%TYPE;
540:
541: -- Bug#5401155: fetch category_id, description, item_id, org_id - needed to create default attributes

Line 538: l_item_id po_lines.item_id%TYPE;

534: -- Bug#5401155
535: l_po_category_id po_lines.category_id%TYPE;
536: l_ip_category_id po_lines.ip_category_id%TYPE;
537: l_item_description po_lines.item_description%TYPE;
538: l_item_id po_lines.item_id%TYPE;
539: l_org_id po_lines.org_id%TYPE;
540:
541: -- Bug#5401155: fetch category_id, description, item_id, org_id - needed to create default attributes
542: CURSOR lines_cursor(x_get_po_header_id number) IS

Line 539: l_org_id po_lines.org_id%TYPE;

535: l_po_category_id po_lines.category_id%TYPE;
536: l_ip_category_id po_lines.ip_category_id%TYPE;
537: l_item_description po_lines.item_description%TYPE;
538: l_item_id po_lines.item_id%TYPE;
539: l_org_id po_lines.org_id%TYPE;
540:
541: -- Bug#5401155: fetch category_id, description, item_id, org_id - needed to create default attributes
542: CURSOR lines_cursor(x_get_po_header_id number) IS
543: SELECT po_line_id, category_id, item_description, item_id, org_id

Line 544: FROM po_lines pl

540:
541: -- Bug#5401155: fetch category_id, description, item_id, org_id - needed to create default attributes
542: CURSOR lines_cursor(x_get_po_header_id number) IS
543: SELECT po_line_id, category_id, item_description, item_id, org_id
544: FROM po_lines pl
545: WHERE pl.po_header_id = x_get_po_header_id
546: ORDER BY pl.po_line_id;
547:
548: BEGIN

Line 567: select po_lines_s.nextval

563: --dbms_output.put_line('progress 005');
564: x_progress:= '004';
565:
566: /* get the new line id */
567: select po_lines_s.nextval
568: into x_to_po_line_id
569: from dual;
570:
571: -- R11: User-defined tax defaulting enhancements. When copying a document where

Line 619: FROM po_lines pol

615: END;
616:
617: SELECT pol.item_id
618: INTO x_item_id
619: FROM po_lines pol
620: WHERE pol.po_line_id = x_from_po_line_id;
621:
622: END IF;
623:

Line 638: insert into po_lines(

634: /* create the new line */
635: --
636: -- Added order_type_lookup_code, purchase_basis and
637: -- matching_basis as part of denormalization
638: insert into po_lines(
639: PO_LINE_ID
640: ,LAST_UPDATE_DATE
641: ,LAST_UPDATED_BY
642: ,PO_HEADER_ID

Line 823: from po_lines

819: ,order_type_lookup_code
820: ,purchase_basis
821: ,matching_basis
822: ,l_ip_category_id --Bug#5401155
823: from po_lines
824: where po_line_id = x_from_po_line_id;
825:
826: --dbms_output.put_line('progress 006');
827: IF(x_copy_attachments = 'Y') THEN

Line 833: copy_attachments('PO_LINES',

829: x_progress:= '006';
830:
831: --API to copy attachments from requisition line to po line
832: fnd_attached_documents2_pkg.
833: copy_attachments('PO_LINES',
834: x_from_po_line_id,
835: '',
836: '',
837: '',

Line 839: 'PO_LINES',

835: '',
836: '',
837: '',
838: '',
839: 'PO_LINES',
840: x_to_po_line_id,
841: '',
842: '',
843: '',

Line 942: from po_lines pol

938:
939: /* get the new line loc id, and the original po_header_id */
940: select po_line_locations_s.nextval, pol.po_header_id
941: into x_to_po_line_location_id, x_to_po_header_id
942: from po_lines pol
943: where pol.po_line_id = x_to_po_line_id;
944:
945: x_progress:= '005';
946: --dbms_output.put_line('progress cs 5' || x_to_po_header_id);