[Home] [Help]
421: p_process_message := SUBSTR('jai_rcv_rgm_claims_pkg.get_location Error:'||SQLERRM,1,250);
422: END get_location;
423:
424: PROCEDURE generate_schedule(
425: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT NULL,
426: p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE DEFAULT NULL,
427: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
428: p_transaction_id IN rcv_transactions.transaction_id%TYPE DEFAULT NULL,
429: p_tax_type IN JAI_CMN_TAXES_ALL.tax_type%TYPE DEFAULT NULL,
1097: p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE DEFAULT NULL,
1098: p_receipt_num IN JAI_RCV_LINES.receipt_num%TYPE DEFAULT NULL,
1099: p_recoverable_amount IN jai_rcv_rgm_lines.recoverable_amount%TYPE DEFAULT NULL,
1100: p_recovered_amount IN jai_rcv_rgm_lines.recovered_amount%TYPE DEFAULT NULL,
1101: p_term_id IN jai_rgm_terms.term_id%TYPE DEFAULT -999,
1102: p_invoice_no IN JAI_RCV_TRANSACTIONS.vat_invoice_no%TYPE, --File.Sql.35 Cbabu DEFAULT '-X9X',
1103: p_invoice_date IN JAI_RCV_TRANSACTIONS.vat_invoice_date%TYPE, --File.Sql.35 Cbabu DEFAULT TO_DATE('01/01/1900','DD/MM/YYYY'),
1104: p_vendor_id IN po_vendors.vendor_id%TYPE DEFAULT -999,
1105: p_vendor_site_id IN po_vendor_sites_all.vendor_site_id%TYPE DEFAULT NULL,