[Home] [Help]
5337: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
5338: IS
5339: -- cursor to find any line payments with po line number
5340: Cursor c_po_ln_number_lines is
5341: SELECT 'x' from aso_payments
5342: where quote_header_id = p_qte_header_rec.quote_header_id
5343: and cust_po_line_number is not null
5344: and cust_po_number is null;
5345:
5344: and cust_po_number is null;
5345:
5346: -- cursor to find po line number from header payment
5347: Cursor c_ln_hd_po_number is
5348: SELECT cust_po_number from aso_payments
5349: where quote_header_id = p_qte_header_rec.quote_header_id
5350: and quote_line_id is null;
5351:
5352: -- cursor to find po number and po line number for line payment
5350: and quote_line_id is null;
5351:
5352: -- cursor to find po number and po line number for line payment
5353: Cursor c_ln_po_line_number is
5354: SELECT cust_po_number, cust_po_line_number from aso_payments
5355: where quote_header_id = p_qte_header_rec.quote_header_id
5356: and quote_line_id = p_qte_line_rec.quote_line_id;
5357:
5358: l_cust_po_line_number varchar2(50);
9491: l_inv_cust_party_id number;
9492:
9493: cursor c_get_payment_type_code(p_qte_hdr_id number) is
9494: select payment_type_code
9495: from aso_payments
9496: where quote_header_id = p_qte_hdr_id
9497: and quote_line_id is null;
9498:
9499: cursor c_get_lines_with_null_payment(p_qte_hdr_id number) is
9497: and quote_line_id is null;
9498:
9499: cursor c_get_lines_with_null_payment(p_qte_hdr_id number) is
9500: select b.invoice_to_cust_party_id
9501: from aso_payments a, aso_quote_lines_all b
9502: where a.quote_header_id = b.quote_header_id
9503: and a.quote_line_id = b.quote_line_id
9504: and b.quote_header_id = p_qte_hdr_id
9505: and a.quote_line_id is not null