[Home] [Help]
5340: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
5341: IS
5342: -- cursor to find any line payments with po line number
5343: Cursor c_po_ln_number_lines is
5344: SELECT 'x' from aso_payments
5345: where quote_header_id = p_qte_header_rec.quote_header_id
5346: and cust_po_line_number is not null
5347: and cust_po_number is null;
5348:
5347: and cust_po_number is null;
5348:
5349: -- cursor to find po line number from header payment
5350: Cursor c_ln_hd_po_number is
5351: SELECT cust_po_number from aso_payments
5352: where quote_header_id = p_qte_header_rec.quote_header_id
5353: and quote_line_id is null;
5354:
5355: -- cursor to find po number and po line number for line payment
5353: and quote_line_id is null;
5354:
5355: -- cursor to find po number and po line number for line payment
5356: Cursor c_ln_po_line_number is
5357: SELECT cust_po_number, cust_po_line_number from aso_payments
5358: where quote_header_id = p_qte_header_rec.quote_header_id
5359: and quote_line_id = p_qte_line_rec.quote_line_id;
5360:
5361: l_cust_po_line_number varchar2(50);
9539: l_inv_cust_party_id number;
9540:
9541: cursor c_get_payment_type_code(p_qte_hdr_id number) is
9542: select payment_type_code
9543: from aso_payments
9544: where quote_header_id = p_qte_hdr_id
9545: and quote_line_id is null;
9546:
9547: cursor c_get_lines_with_null_payment(p_qte_hdr_id number) is
9545: and quote_line_id is null;
9546:
9547: cursor c_get_lines_with_null_payment(p_qte_hdr_id number) is
9548: select b.invoice_to_cust_party_id
9549: from aso_payments a, aso_quote_lines_all b
9550: where a.quote_header_id = b.quote_header_id
9551: and a.quote_line_id = b.quote_line_id
9552: and b.quote_header_id = p_qte_hdr_id
9553: and a.quote_line_id is not null