[Home] [Help]
352: p_process_message := SUBSTR('jai_rcv_rgm_claims_pkg.get_location Error:'||SQLERRM,1,250);
353: END get_location;
354:
355: PROCEDURE generate_schedule(
356: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT NULL,
357: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
358: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
359: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,
360: p_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE DEFAULT NULL,
1027: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
1028: p_receipt_num IN JAI_RCV_LINES.receipt_num%TYPE DEFAULT NULL,
1029: p_recoverable_amount IN jai_rcv_rgm_lines.recoverable_amount%TYPE DEFAULT NULL,
1030: p_recovered_amount IN jai_rcv_rgm_lines.recovered_amount%TYPE DEFAULT NULL,
1031: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT -999,
1032: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE, --File.Sql.35 Cbabu DEFAULT '-X9X',
1033: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE, --File.Sql.35 Cbabu DEFAULT TO_DATE('01/01/1900','DD/MM/YYYY'),
1034: p_vendor_id IN po_vendors.vendor_id%TYPE DEFAULT -999,
1035: p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE DEFAULT NULL,