APPS.PO_AUTOCREATE_GROUPING_PVT dependencies on PO_LINES_ALL

Line 105: source_document_line_id PO_LINES_ALL.po_line_id%TYPE,

101: unit_meas_lookup_code PO_REQUISITION_LINES_ALL.unit_meas_lookup_code%TYPE,
102: transaction_reason PO_REQUISITION_LINES_ALL.transaction_reason_code%TYPE,
103: contract_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
104: source_document_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
105: source_document_line_id PO_LINES_ALL.po_line_id%TYPE,
106: cancel_flag PO_LINES_ALL.cancel_flag%TYPE,
107: closed_code PO_LINES_ALL.closed_code%TYPE,
108: supplier_ref_number PO_REQUISITION_LINES_ALL.supplier_ref_number%TYPE
109: ,group_line_id PO_REQUISITION_LINES_ALL.GROUP_LINE_ID%TYPE

Line 106: cancel_flag PO_LINES_ALL.cancel_flag%TYPE,

102: transaction_reason PO_REQUISITION_LINES_ALL.transaction_reason_code%TYPE,
103: contract_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
104: source_document_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
105: source_document_line_id PO_LINES_ALL.po_line_id%TYPE,
106: cancel_flag PO_LINES_ALL.cancel_flag%TYPE,
107: closed_code PO_LINES_ALL.closed_code%TYPE,
108: supplier_ref_number PO_REQUISITION_LINES_ALL.supplier_ref_number%TYPE
109: ,group_line_id PO_REQUISITION_LINES_ALL.GROUP_LINE_ID%TYPE
110: ,clm_info_flag PO_REQUISITION_LINES_ALL.CLM_INFO_FLAG%TYPE

Line 107: closed_code PO_LINES_ALL.closed_code%TYPE,

103: contract_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
104: source_document_id PO_REQUISITION_LINES_ALL.blanket_po_header_id%TYPE,
105: source_document_line_id PO_LINES_ALL.po_line_id%TYPE,
106: cancel_flag PO_LINES_ALL.cancel_flag%TYPE,
107: closed_code PO_LINES_ALL.closed_code%TYPE,
108: supplier_ref_number PO_REQUISITION_LINES_ALL.supplier_ref_number%TYPE
109: ,group_line_id PO_REQUISITION_LINES_ALL.GROUP_LINE_ID%TYPE
110: ,clm_info_flag PO_REQUISITION_LINES_ALL.CLM_INFO_FLAG%TYPE
111: ,CLM_BASE_LINE_NUM PO_REQUISITION_LINES_ALL.CLM_BASE_LINE_NUM%TYPE,

Line 461: l_po_line_num PO_LINES_ALL.line_num%TYPE;

457:
458: l_num_lines NUMBER;
459: l_key NUMBER;
460: l_req_line_id PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;
461: l_po_line_num PO_LINES_ALL.line_num%TYPE;
462: l_req_line_id_to_compare PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;
463: l_po_line_id_to_compare PO_LINES_ALL.po_line_id%TYPE;
464: l_progress_payment_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
465: l_message_code VARCHAR2(30) := NULL;

Line 463: l_po_line_id_to_compare PO_LINES_ALL.po_line_id%TYPE;

459: l_key NUMBER;
460: l_req_line_id PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;
461: l_po_line_num PO_LINES_ALL.line_num%TYPE;
462: l_req_line_id_to_compare PO_REQUISITION_LINES_ALL.requisition_line_id%TYPE;
463: l_po_line_id_to_compare PO_LINES_ALL.po_line_id%TYPE;
464: l_progress_payment_flag PO_DOC_STYLE_HEADERS.progress_payment_flag%TYPE;
465: l_message_code VARCHAR2(30) := NULL;
466: l_token_name VARCHAR2(30) := NULL;
467: l_token_value VARCHAR2(2000) := NULL;

Line 555: FROM po_lines_all

551: OR EXISTS(
552: -- Select all PO lines that have the same PO line number as the
553: -- current line in the loop.
554: SELECT 'PO lines with same PO line number'
555: FROM po_lines_all
556: WHERE po_header_id = p_add_to_po_header_id
557: AND line_num = POSGT.index_num2 -- Same PO line number
558: )),
559: 'N' -- NVL to 'N' if no other req/PO lines with same PO line number

Line 735: req_line_ip_category_id PO_LINES_ALL.ip_category_id%TYPE;

731: sol_group_line_id PON_AUCTION_ITEM_PRICES_ALL.group_line_id%TYPE;
732: sol_clm_info_flag PON_AUCTION_ITEM_PRICES_ALL.clm_info_flag%TYPE;
733: sol_clm_option_indicator PON_AUCTION_ITEM_PRICES_ALL.clm_option_indicator%TYPE;
734: sol_contract_type PON_AUCTION_HEADERS_ALL.contract_type%TYPE;
735: req_line_ip_category_id PO_LINES_ALL.ip_category_id%TYPE;
736: sol_ip_category_id PON_AUCTION_ITEM_PRICES_ALL.ip_category_id%TYPE;
737: sol_uom_code VARCHAR2(10);
738: req_line_uom VARCHAR2(10);
739: req_ship_to_location_id hr_locations.ship_to_location_id%TYPE;

Line 793: FROM po_requisition_lines_all prl,po_line_types_b plt, mtl_units_of_measure mom, po_lines_all pol

789: ,req_line_ip_category_id
790: ,req_line_uom
791: ,req_group_line_id
792: ,req_ship_to_location_id
793: FROM po_requisition_lines_all prl,po_line_types_b plt, mtl_units_of_measure mom, po_lines_all pol
794: WHERE prl.requisition_line_id = l_req_line_id
795: AND prl.line_type_id = plt.line_type_id
796: AND mom.unit_of_measure (+) = prl.unit_meas_lookup_code
797: AND pol.po_header_id(+) = prl.blanket_po_header_id AND pol.line_num(+) = prl.blanket_po_line_num;

Line 2932: po_lines_all SRC_DOC_LINE

2928: , PRL.CLM_BASE_LINE_NUM
2929: , PRL.category_id --bugfix#16097884
2930: INTO l_req_line_info
2931: FROM po_requisition_lines_all PRL,
2932: po_lines_all SRC_DOC_LINE
2933: WHERE PRL.requisition_line_id = p_req_line_id
2934: AND SRC_DOC_LINE.po_header_id(+) = PRL.blanket_po_header_id
2935: AND SRC_DOC_LINE.line_num(+) = PRL.blanket_po_line_num;
2936:

Line 5771: l_po_item_id PO_LINES_ALL.ITEM_ID%TYPE;

5767: d_position NUMBER := 0;
5768:
5769: l_req_line LINE_INFO;
5770: l_po_line LINE_INFO;
5771: l_po_item_id PO_LINES_ALL.ITEM_ID%TYPE;
5772: l_po_item_desc PO_LINES_ALL.ITEM_DESCRIPTION%TYPE;
5773:
5774: BEGIN
5775:

Line 5772: l_po_item_desc PO_LINES_ALL.ITEM_DESCRIPTION%TYPE;

5768:
5769: l_req_line LINE_INFO;
5770: l_po_line LINE_INFO;
5771: l_po_item_id PO_LINES_ALL.ITEM_ID%TYPE;
5772: l_po_item_desc PO_LINES_ALL.ITEM_DESCRIPTION%TYPE;
5773:
5774: BEGIN
5775:
5776: IF (PO_LOG.d_proc) THEN

Line 5790: FROM po_lines_all

5786: -- Fetch the po line id
5787: BEGIN
5788: SELECT item_id, item_description
5789: INTO l_po_item_id, l_po_item_desc
5790: FROM po_lines_all
5791: WHERE po_header_id = p_po_header_id
5792: AND line_num = p_po_line_num;
5793: EXCEPTION
5794: WHEN NO_DATA_FOUND THEN