|
Package BANINST1.fb_invoice_header
Common Business interface for the Invoice Header API (INVOICE HEADER).
|
M_ENTITY_NAME
M_ENTITY_NAME CONSTANT VARCHAR2(14) := 'INVOICE_HEADER';
Business Entity Name
M_BASE_TABLE_NAME
M_BASE_TABLE_NAME CONSTANT VARCHAR2(7) := 'FABINVH';
Base table name
M_DOC_SEQNO_TYPE
M_DOC_SEQNO_TYPE CONSTANT VARCHAR2(10) := 'I';
Default sequence type for the invoice document number
M_INVOICE_DOC_TYPE
M_INVOICE_DOC_TYPE CONSTANT NUMBER := 3;
Invoice document type
invoice_header_rec
TYPE invoice_header_rec IS RECORD (
r_code fabinvh.fabinvh_code%TYPE,
r_pohd_code fabinvh.fabinvh_pohd_code%TYPE,
r_vend_pidm fabinvh.fabinvh_vend_pidm%TYPE,
r_open_paid_ind fabinvh.fabinvh_open_paid_ind%TYPE,
r_user_id fabinvh.fabinvh_user_id%TYPE,
r_vend_inv_code fabinvh.fabinvh_vend_inv_code%TYPE,
r_invoice_date fabinvh.fabinvh_invoice_date%TYPE,
r_pmt_due_date fabinvh.fabinvh_pmt_due_date%TYPE,
r_trans_date fabinvh.fabinvh_trans_date%TYPE,
r_cr_memo_ind fabinvh.fabinvh_cr_memo_ind%TYPE,
r_adjt_code fabinvh.fabinvh_adjt_code%TYPE,
r_adjt_date fabinvh.fabinvh_adjt_date%TYPE,
r_1099_ind fabinvh.fabinvh_1099_ind%TYPE,
r_1099_id fabinvh.fabinvh_1099_id%TYPE,
r_ityp_seq_code fabinvh.fabinvh_ityp_seq_code%TYPE,
r_text_ind fabinvh.fabinvh_text_ind%TYPE,
r_appr_ind fabinvh.fabinvh_appr_ind%TYPE,
r_complete_ind fabinvh.fabinvh_complete_ind%TYPE,
r_disc_code fabinvh.fabinvh_disc_code%TYPE,
r_trat_code fabinvh.fabinvh_trat_code%TYPE,
r_addl_chrg_amt fabinvh.fabinvh_addl_chrg_amt%TYPE,
r_hold_ind fabinvh.fabinvh_hold_ind%TYPE,
r_susp_ind fabinvh.fabinvh_susp_ind%TYPE,
r_susp_ind_addl fabinvh.fabinvh_susp_ind_addl%TYPE,
r_cancel_ind fabinvh.fabinvh_cancel_ind%TYPE,
r_cancel_date fabinvh.fabinvh_cancel_date%TYPE,
r_post_date fabinvh.fabinvh_post_date%TYPE,
r_atyp_code fabinvh.fabinvh_atyp_code%TYPE,
r_atyp_seq_num fabinvh.fabinvh_atyp_seq_num%TYPE,
r_grouping_ind fabinvh.fabinvh_grouping_ind%TYPE,
r_bank_code fabinvh.fabinvh_bank_code%TYPE,
r_ruiv_ind fabinvh.fabinvh_ruiv_ind%TYPE,
r_edit_defer_ind fabinvh.fabinvh_edit_defer_ind%TYPE,
r_override_tax_amt fabinvh.fabinvh_override_tax_amt%TYPE,
r_tgrp_code fabinvh.fabinvh_tgrp_code%TYPE,
r_submission_number fabinvh.fabinvh_submission_number%TYPE,
r_vend_check_pidm fabinvh.fabinvh_vend_check_pidm%TYPE,
r_invoice_type_ind fabinvh.fabinvh_invoice_type_ind%TYPE,
r_curr_code fabinvh.fabinvh_curr_code%TYPE,
r_disb_agent_ind fabinvh.fabinvh_disb_agent_ind%TYPE,
r_atyp_code_vend fabinvh.fabinvh_atyp_code_vend%TYPE,
r_atyp_seq_num_vend fabinvh.fabinvh_atyp_seq_num_vend%TYPE,
r_nsf_on_off_ind fabinvh.fabinvh_nsf_on_off_ind%TYPE,
r_single_acctg_ind fabinvh.fabinvh_single_acctg_ind%TYPE,
r_one_time_vend_name fabinvh.fabinvh_one_time_vend_name%TYPE,
r_one_time_house_number fabinvh.fabinvh_one_time_house_number%TYPE,
r_one_time_vend_addr1 fabinvh.fabinvh_one_time_vend_addr1%TYPE,
r_one_time_vend_addr2 fabinvh.fabinvh_one_time_vend_addr2%TYPE,
r_one_time_vend_addr3 fabinvh.fabinvh_one_time_vend_addr3%TYPE,
r_one_time_vend_addr4 fabinvh.fabinvh_one_time_vend_addr4%TYPE,
r_one_time_vend_city fabinvh.fabinvh_one_time_vend_city%TYPE,
r_one_time_vend_state fabinvh.fabinvh_one_time_vend_state%TYPE,
r_one_time_vend_zip fabinvh.fabinvh_one_time_vend_zip%TYPE,
r_one_time_vend_natn fabinvh.fabinvh_one_time_vend_natn%TYPE,
r_delivery_point fabinvh.fabinvh_delivery_point%TYPE,
r_correction_digit fabinvh.fabinvh_correction_digit%TYPE,
r_carrier_route fabinvh.fabinvh_carrier_route%TYPE,
r_ruiv_installment_ind fabinvh.fabinvh_ruiv_installment_ind%TYPE,
r_multiple_inv_ind fabinvh.fabinvh_multiple_inv_ind%TYPE,
r_phone_area fabinvh.fabinvh_phone_area%TYPE,
r_phone_number fabinvh.fabinvh_phone_number%TYPE,
r_phone_ext fabinvh.fabinvh_phone_ext%TYPE,
r_email_addr fabinvh.fabinvh_email_addr%TYPE,
r_ctry_code_fax fabinvh.fabinvh_ctry_code_fax%TYPE,
r_fax_area fabinvh.fabinvh_fax_area%TYPE,
r_fax_number fabinvh.fabinvh_fax_number%TYPE,
r_fax_ext fabinvh.fabinvh_fax_ext%TYPE,
r_cancel_code fabinvh.fabinvh_cancel_code%TYPE,
r_attention_to fabinvh.fabinvh_attention_to%TYPE,
r_vendor_contact fabinvh.fabinvh_vendor_contact%TYPE,
r_invd_re_establish_ind fabinvh.fabinvh_invd_re_establish_ind%TYPE,
r_ach_override_ind fabinvh.fabinvh_ach_override_ind%TYPE,
r_acht_code fabinvh.fabinvh_acht_code%TYPE,
r_origin_code fabinvh.fabinvh_origin_code%TYPE,
r_match_required fabinvh.fabinvh_match_required%TYPE,
r_create_user fabinvh.fabinvh_create_user%TYPE,
r_create_date fabinvh.fabinvh_create_date%TYPE,
r_complete_user fabinvh.fabinvh_complete_user%TYPE,
r_complete_date fabinvh.fabinvh_complete_date%TYPE,
r_data_origin fabinvh.fabinvh_data_origin%TYPE,
r_create_source fabinvh.fabinvh_create_source%TYPE,
r_cancel_user fabinvh.fabinvh_cancel_user%TYPE,
r_cancel_activity_date fabinvh.fabinvh_cancel_activity_date%TYPE,
r_ctry_code_phone fabinvh.fabinvh_ctry_code_phone%TYPE,
r_vend_hold_ovrd_ind fabinvh.fabinvh_vend_hold_ovrd_ind%TYPE,
r_vend_hold_ovrd_user fabinvh.fabinvh_vend_hold_ovrd_user%TYPE,
r_internal_record_id gb_common.internal_record_id_type);
Business Entity record type
invoice_header_ref
TYPE invoice_header_ref IS REF CURSOR RETURN invoice_header_rec;
Entity cursor variable type
invoice_header_tab
TYPE invoice_header_tab IS TABLE OF invoice_header_rec INDEX BY BINARY_INTEGER;
Entity table type
f_api_version
Function f_api_version RETURN PLS_INTEGER
Returns the API version number.
|
|
Version of the API signature. Changes only when the signature changes.
|
f_exists
Function f_exists(p_code fabinvh.fabinvh_code%TYPE DEFAULT NULL,
p_rowid gb_common.internal_record_id_type DEFAULT NULL)
RETURN VARCHAR2
Checks to see if a record exists. Code or rowid is required.
|
|
p_code
|
The unique identifier of an Invoice document. The code may be system-generated. VARCHAR2(8) Required Key
|
|
|
p_rowid
|
Database ROWID of the record to be selected. VARCHAR2(18)
|
f_exists_data
Function f_exists_data(p_code fabinvh.fabinvh_code%TYPE DEFAULT NULL,
p_rowid gb_common.internal_record_id_type DEFAULT NULL,
p_invhead_rec_out OUT invoice_header_rec)
RETURN BOOLEAN
Returns true if a record exists.
|
|
p_code
|
The unique identifier of an Invoice document. The code may be system-generated. VARCHAR2(8) Required Key
|
|
|
p_rowid
|
Database ROWID of the record to be selected. VARCHAR2(18)
|
|
|
p_invhead_rec_out
|
The out parameter that returns the invoice header record.
|
|
|
TRUE if found, otherwise FALSE
|
f_isequal
Function f_isequal(rec_one invoice_header_rec, rec_two invoice_header_rec)
RETURN VARCHAR2
Compares two records for equality.
Tests each field of rec_one against the corresponding field of rec_two. Two null values are considered equal.
|
|
Y if all values in records are equal, otherwise N. Nulls match Nulls.
|
f_query_all
Function f_query_all RETURN invoice_header_ref
Selects all invoice header records from the table.
|
|
A cursor variable that will fetch the set of records.
|
f_query_one
Function f_query_one(p_code fabinvh.fabinvh_code%TYPE)
RETURN invoice_header_ref
Selects one record using key.
|
|
p_code
|
The unique identifier of an Invoice document. The code may be system-generated. VARCHAR2(8) Required Key.
|
|
|
A cursor variable that will fetch exactly one record.
|
f_query_one_rec
Function f_query_one_rec(p_code fabinvh.fabinvh_code%TYPE DEFAULT NULL,
p_rowid gb_common.internal_record_id_type DEFAULT NULL)
RETURN invoice_header_rec
Returns one header record using key or rowid.
|
|
p_code
|
The unique identifier of an Invoice document. The code may be system-generated. VARCHAR2(8) Required Key
|
|
|
p_rowid
|
Database ROWID of the record to be selected.
|
|
|
The invoice header record.
|
f_query_by_rowid
Function f_query_by_rowid(p_rowid gb_common.internal_record_id_type)
RETURN invoice_header_ref
Selects one record using ROWID.
|
|
p_rowid
|
Database ROWID of the record to be selected. VARCHAR2(18) Required
|
|
|
A cursor variable that will fetch exactly one record.
|
f_query_one_string
Function f_query_one_string(p_code fabinvh.fabinvh_code%TYPE DEFAULT NULL,
p_rowid gb_common.internal_record_id_type DEFAULT NULL,
p_separation_char varchar2 DEFAULT ',')
RETURN VARCHAR2
Returns all of the header data row concatenated into a string in the header record using key or rowid.
Used in API testing.
|
|
p_code
|
The unique identifier of an Invoice document. The code may be system-generated. VARCHAR2(8) Required Key
|
|
|
p_rowid
|
Database ROWID of the record to be selected.
|
|
|
p_separation_char
|
The character that separates the column data in the return string. The default is the comma character.
|
|
|
A string which consists of the header column values concatenated with each other. VARCHAR2
|
f_query_one_lock
Function f_query_one_lock(p_code fabinvh.fabinvh_code%TYPE,
p_rowid gb_common.internal_record_id_type DEFAULT NULL)
RETURN invoice_header_ref
Selects one record and locks it.
|
|
p_code
|
The unique identifier of an Invoice document. The code may be system-generated. VARCHAR2(8) Required Key
|
|
|
p_rowid
|
Database ROWID of the record to be selected. VARCHAR2(18)
|
|
|
A cursor variable for one record, locking the record.
|
f_convert_rectype_to_rowtype
Function f_convert_rectype_to_rowtype(p_invhead_rec invoice_header_rec)
RETURN fabinvh%ROWTYPE
Function to convert a record of invoice_header_rec type to a record of fabinvh%rowtype.
|
|
p_invhead_rec
|
A PL/SQL record variable of type invoice header_rec.
|
|
|
One row of data from the invoice header table FABINVH of type fabinvh%rowtype.
|
f_convert_rowtype_to_rectype
Function f_convert_rowtype_to_rectype(p_fabinvh_row fabinvh%ROWTYPE)
RETURN invoice_header_rec
Function to convert a record of fabinvh%rowtype to a record of invoice_header_rec type.
|
|
p_fabinvh_row
|
A PL/SQL record variable of type fabinvh%rowtype.
|
f_gen_validate_invoice_code
Function f_gen_validate_invoice_code(p_code fabinvh.fabinvh_code%TYPE,
p_invoice_prefix_type VARCHAR2)
RETURN fabinvh.fabinvh_code%TYPE
Function to generate and validate an invoice document code.
|
|
p_code
|
The unique identifier of an Invoice document. The code may be system-generated. VARCHAR2(8) Required Key
|
|
|
p_invoice_prefix_type
|
The prefix character for an invoice document code. The default is 'I'. VARCHAR2(1)
|
|
|
VARCHAR2(8) Returns a validated invoice document code. Will raise an exception if any errors are raised during processing.
|
f_get_complete_ind
Function f_get_complete_ind(p_code fabinvh.fabinvh_code%TYPE)
RETURN VARCHAR2
Function that returns the value of the invoice header complete indicator.
|
|
p_code
|
The unique identifier of an invoice document. VARCHAR2(8) Required key.
|
|
|
VARCHAR2(1) THe completion indicator of the invoice header. (N) - indicates that the invoice is incomplete. (R) - indicates that the invoice has been completed and forwarded to the matching process. (Y) - indicates that the invoice has been completed.
|
p_create
Procedure p_create(p_code IN OUT fabinvh.fabinvh_code%TYPE,
p_invoice_prefix_type fobseqn.fobseqn_seqno_type%TYPE DEFAULT M_DOC_SEQNO_TYPE,
p_pohd_code fabinvh.fabinvh_pohd_code%TYPE DEFAULT NULL,
p_vend_pidm fabinvh.fabinvh_vend_pidm%TYPE DEFAULT NULL,
p_user_id fabinvh.fabinvh_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_vend_inv_code fabinvh.fabinvh_vend_inv_code%TYPE DEFAULT NULL,
p_invoice_date fabinvh.fabinvh_invoice_date%TYPE DEFAULT NULL,
p_pmt_due_date fabinvh.fabinvh_pmt_due_date%TYPE DEFAULT NULL,
p_trans_date fabinvh.fabinvh_trans_date%TYPE DEFAULT NULL,
p_cr_memo_ind fabinvh.fabinvh_cr_memo_ind%TYPE DEFAULT 'N',
p_adjt_code fabinvh.fabinvh_adjt_code%TYPE DEFAULT NULL,
p_adjt_date fabinvh.fabinvh_adjt_date%TYPE DEFAULT NULL,
p_1099_ind fabinvh.fabinvh_1099_ind%TYPE DEFAULT NULL,
p_1099_id fabinvh.fabinvh_1099_id%TYPE DEFAULT NULL,
p_ityp_seq_code fabinvh.fabinvh_ityp_seq_code%TYPE DEFAULT NULL,
p_disc_code fabinvh.fabinvh_disc_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_trat_code fabinvh.fabinvh_trat_code%TYPE DEFAULT NULL,
p_addl_chrg_amt fabinvh.fabinvh_addl_chrg_amt%TYPE DEFAULT NULL,
p_hold_ind fabinvh.fabinvh_hold_ind%TYPE DEFAULT 'N',
p_post_date fabinvh.fabinvh_post_date%TYPE DEFAULT NULL,
p_atyp_code fabinvh.fabinvh_atyp_code%TYPE DEFAULT NULL,
p_atyp_seq_num fabinvh.fabinvh_atyp_seq_num%TYPE DEFAULT NULL,
p_grouping_ind fabinvh.fabinvh_grouping_ind%TYPE DEFAULT NULL,
p_bank_code fabinvh.fabinvh_bank_code%TYPE DEFAULT NULL,
p_ruiv_ind fabinvh.fabinvh_ruiv_ind%TYPE DEFAULT NULL,
p_edit_defer_ind fabinvh.fabinvh_edit_defer_ind%TYPE DEFAULT NULL,
p_override_tax_amt fabinvh.fabinvh_override_tax_amt%TYPE DEFAULT NULL,
p_tgrp_code fabinvh.fabinvh_tgrp_code%TYPE DEFAULT NULL,
p_vend_check_pidm fabinvh.fabinvh_vend_check_pidm%TYPE DEFAULT NULL,
p_invoice_type_ind fabinvh.fabinvh_invoice_type_ind%TYPE DEFAULT NULL,
p_curr_code fabinvh.fabinvh_curr_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_disb_agent_ind fabinvh.fabinvh_disb_agent_ind%TYPE DEFAULT NULL,
p_atyp_code_vend fabinvh.fabinvh_atyp_code_vend%TYPE DEFAULT NULL,
p_atyp_seq_num_vend fabinvh.fabinvh_atyp_seq_num_vend%TYPE DEFAULT NULL,
p_nsf_on_off_ind fabinvh.fabinvh_nsf_on_off_ind%TYPE DEFAULT NULL,
p_single_acctg_ind fabinvh.fabinvh_single_acctg_ind%TYPE DEFAULT NULL,
p_one_time_vend_name fabinvh.fabinvh_one_time_vend_name%TYPE DEFAULT NULL,
p_one_time_house_number fabinvh.fabinvh_one_time_house_number%TYPE DEFAULT NULL,
p_one_time_vend_addr1 fabinvh.fabinvh_one_time_vend_addr1%TYPE DEFAULT NULL,
p_one_time_vend_addr2 fabinvh.fabinvh_one_time_vend_addr2%TYPE DEFAULT NULL,
p_one_time_vend_addr3 fabinvh.fabinvh_one_time_vend_addr3%TYPE DEFAULT NULL,
p_one_time_vend_addr4 fabinvh.fabinvh_one_time_vend_addr4%TYPE DEFAULT NULL,
p_one_time_vend_city fabinvh.fabinvh_one_time_vend_city%TYPE DEFAULT NULL,
p_one_time_vend_state fabinvh.fabinvh_one_time_vend_state%TYPE DEFAULT NULL,
p_one_time_vend_zip fabinvh.fabinvh_one_time_vend_zip%TYPE DEFAULT NULL,
p_one_time_vend_natn fabinvh.fabinvh_one_time_vend_natn%TYPE DEFAULT NULL,
p_delivery_point fabinvh.fabinvh_delivery_point%TYPE DEFAULT NULL,
p_correction_digit fabinvh.fabinvh_correction_digit%TYPE DEFAULT NULL,
p_carrier_route fabinvh.fabinvh_carrier_route%TYPE DEFAULT NULL,
p_ruiv_installment_ind fabinvh.fabinvh_ruiv_installment_ind%TYPE DEFAULT NULL,
p_multiple_inv_ind fabinvh.fabinvh_multiple_inv_ind%TYPE DEFAULT NULL,
p_phone_area fabinvh.fabinvh_phone_area%TYPE DEFAULT NULL,
p_phone_number fabinvh.fabinvh_phone_number%TYPE DEFAULT NULL,
p_phone_ext fabinvh.fabinvh_phone_ext%TYPE DEFAULT NULL,
p_email_addr fabinvh.fabinvh_email_addr%TYPE DEFAULT NULL,
p_ctry_code_fax fabinvh.fabinvh_ctry_code_fax%TYPE DEFAULT NULL,
p_fax_area fabinvh.fabinvh_fax_area%TYPE DEFAULT NULL,
p_fax_number fabinvh.fabinvh_fax_number%TYPE DEFAULT NULL,
p_fax_ext fabinvh.fabinvh_fax_ext%TYPE DEFAULT NULL,
p_attention_to fabinvh.fabinvh_attention_to%TYPE DEFAULT NULL,
p_vendor_contact fabinvh.fabinvh_vendor_contact%TYPE DEFAULT NULL,
p_ach_override_ind fabinvh.fabinvh_ach_override_ind%TYPE DEFAULT NULL,
p_acht_code fabinvh.fabinvh_acht_code%TYPE DEFAULT NULL,
p_origin_code fabinvh.fabinvh_origin_code%TYPE DEFAULT NULL,
p_match_required fabinvh.fabinvh_match_required%TYPE DEFAULT 'U',
p_data_origin fabinvh.fabinvh_data_origin%TYPE DEFAULT NULL,
p_ctry_code_phone fabinvh.fabinvh_ctry_code_phone%TYPE DEFAULT NULL,
p_vend_hold_ovrd_ind fabinvh.fabinvh_vend_hold_ovrd_ind%TYPE DEFAULT NULL,
p_vend_hold_ovrd_user fabinvh.fabinvh_vend_hold_ovrd_user%TYPE DEFAULT NULL,
p_rowid_out OUT gb_common.internal_record_id_type)
Creates an invoice header record in the invoice table FABINVH.
|
|
p_code
|
The unique identifier of an Invoice document. The code may be system-generated. VARCHAR2(8) Required Key
|
|
|
p_pohd_code
|
The Purchase Order or General Encumbrance document number which is referenced on the Invoice, if any. Only populated for Regular or General Encumbrance Invoice types. VARCHAR2(8)
|
|
|
p_vend_pidm
|
The unique internal identification number of the Invoice vendor. NUMBER(8)
|
|
|
p_user_id
|
The unique identification code of the user who last updated the Invoice document. VARCHAR2(30) Required
|
|
|
p_vend_inv_code
|
The Invoice number as supplied by the vendor. VARCHAR2(15)
|
|
|
p_invoice_date
|
A user-defined or system-generated Invoice date. Basis of calculated Payment Due Date if terms/discount are used. DATE
|
|
|
p_pmt_due_date
|
The date an Invoice is due. Can be user-defined or calculated based on Invoice terms/discount. DATE
|
|
|
p_trans_date
|
The date the invoice document will be recorded in the ledgers. DATE
|
|
|
p_cr_memo_ind
|
Indicates that the Invoice should be processed as a Credit Memo. If Y, the payment will be recorded as a Credit Memo. VARCHAR2(1) Required
|
|
|
p_adjt_code
|
This column is not currently used by the Banner Finance application. VARCHAR2(2)
|
|
|
p_adjt_date
|
This column is not currently used by the Banner Finance application. DATE
|
|
|
p_1099_ind
|
Indicates that the Invoice includes taxable payments. If Y, the payment will be recorded in the 1099 tables and accumulated for income tax reporting purposes. VARCHAR2(1)
|
|
|
p_1099_id
|
The 1099 tax reporting ID of the vendor. VARCHAR2(9)
|
|
|
p_ityp_seq_code
|
The internal value which represents the user selected income type (as defined in table FTVITYP) for 1099 processing and reporting purposes. Defaults from vendor record (as defined on FTVVEND). NUMBER(2)
|
|
|
p_disc_code
|
The discount code (as defined in table FTVDISC) to be used to define payment terms for the processing of the Invoice. VARCHAR2(2)
|
|
|
p_trat_code
|
This column is not currently used by the Banner Finance application. VARCHAR2(3)
|
|
|
p_addl_chrg_amt
|
The total dollar value of any additional charges, e.g., freight associated with this Invoice. NUMBER(17,2)
|
|
|
p_hold_ind
|
Indicates that the Invoice record has been placed on hold to prevent payment to a vendor. Indicator is set via the FAAINVE or FAAPAYC form. If Y, the document will be withheld from the payment process. VARCHAR2(1) Required.
|
|
|
p_post_date
|
This column is not currently used by the Banner Finance application. DATE
|
|
|
p_atyp_code
|
Used to identify the vendor address type to which the payment will be made. When using Check Vendor this value will be the address type for the vendor defined in FABINVH_VEND_CHECK_PIDM. VARCHAR2(2)
|
|
|
p_atyp_seq_num
|
Used to identify the vendor address type sequence to which the payment will be made. When using Check Vendor this value will be the address type sequence for the vendor defined in FABINVH_VEND_CHECK_PIDM. NUMBER(2)
|
|
|
p_grouping_ind
|
Indicates the relationship between the number of invoices processed and the number of checks. A value of 1 creates one check per invoice; a value of M combines many invoices on one check. VARCHAR2(1)
|
|
|
p_bank_code
|
The Bank Code (as defined in table GXVBANK) to be used for processing the payment of the Invoice. VARCHAR2(2)
|
|
|
p_ruiv_ind
|
Indicates that an invoice will be processed on a recurring basis on a specific schedule as defined in the form FAARUIV. VARCHAR2(1)
|
|
|
p_edit_defer_ind
|
Indicates that document editing of the Invoice will be deferred until after completion. VARCHAR2(1)
|
|
|
p_override_tax_amt
|
This column is not currently used by the Banner Finance application. NUMBER(17,2)
|
|
|
p_tgrp_code
|
The tax group (as defined in table FTVTGRP) to be used for the processing of the Invoice. VARCHAR2(4)
|
|
|
p_vend_check_pidm
|
The unique internal identification number of the Invoice check vendor or disbursing agent when one is identified. NUMBER(8)
|
|
|
p_curr_code
|
The currency (as defined in table GTVCURR) to be used for the processing of the Invoice. VARCHAR2(4)
|
|
|
p_disb_agent_ind
|
Indicates that the Invoice will use a Disbursing Agent for payment. The Disbursing Agent is associated to a foreign currency on form GUACURR. VARCHAR2(1)
|
|
|
p_atyp_code_vend
|
Identifies the address type for the Invoice vendor defined in FABINVH_VEND_PIDM. VARCHAR2(2)
|
|
|
p_atyp_seq_num_vend
|
Used to identify the address type sequence number for the Invoice vendor defined in FABINVH_VEND_PIDM. NUMBER(2)
|
|
|
p_nsf_on_off_ind
|
Indicates when non-sufficient funds checking will be done. If Y, checking will be performed at time of data entry. VARCHAR2(1)
|
|
|
p_single_acctg_ind
|
Indicates the Accounting Level used for the Invoice. Valid values are Y for Document Level Accounting and N for Commodity Level Accounting. VARCHAR2(1)
|
|
|
p_one_time_vend_name
|
Name for use with One Time Vendor. VARCHAR2(60)
|
|
|
p_one_time_house_number
|
Building or lot number on a street or in an area for One Time Vendor. VARCHAR2(10)
|
|
|
p_one_time_vend_addr1
|
Address Line 1 for use with One Time Vendor. VARCHAR2(75)
|
|
|
p_one_time_vend_addr2
|
Address Line 2 for use with One Time Vendor. VARCHAR2(75)
|
|
|
p_one_time_vend_addr3
|
Address Line 3 for use with One Time Vendor. VARCHAR2(75)
|
|
|
p_one_time_vend_addr4
|
Address Line 4 for use with One Time Vendor. VARCHAR2(75)
|
|
|
p_one_time_vend_city
|
City for use with One Time Vendor. VARCHAR2(50)
|
|
|
p_one_time_vend_state
|
State or Province for use with One Time Vendor. VARCHAR2(3)
|
|
|
p_one_time_vend_zip
|
Zip or Postal Code for use with One Time Vendor. VARCHAR2(30)
|
|
|
p_one_time_vend_natn
|
Nation for use with One Time Vendor. VARCHAR2(5)
|
|
|
p_delivery_point
|
This column is not currently used by the Banner Finance application. NUMBER(2)
|
|
|
p_correction_digit
|
This column is not currently used by the Banner Finance application. NUMBER(1)
|
|
|
p_carrier_route
|
This column is not currently used by the Banner Finance application. VARCHAR2(4)
|
|
|
p_ruiv_installment_ind
|
Indicates whether the Invoice when set up as recurring payment is an installment. It is used by the fixed asset module to determine the capitalization amount. VARCHAR2(1)
|
|
|
p_multiple_inv_ind
|
Indicates if multiple vendor invoices are associated with the Banner Invoice document. If Y, then additional information is stored in the table FARVINV. VARCHAR2(1)
|
|
|
p_ctry_code_phone
|
Code designating the region or country. VARCHAR2(4)
|
|
|
p_phone_area
|
This column is not currently used by the Banner Finance application. VARCHAR2(6)
|
|
|
p_phone_number
|
This column is not currently used by the Banner Finance application. VARCHAR2(12)
|
|
|
p_phone_ext
|
This column is not currently used by the Banner Finance application. VARCHAR2(10)
|
|
|
p_email_addr
|
This column is not currently used by the Banner Finance application. VARCHAR2(20)
|
|
|
p_ctry_code_fax
|
This column is not currently used by the Banner Finance application. VARCHAR2(4)
|
|
|
p_fax_area
|
This column is not currently used by the Banner Finance application. VARCHAR2(6)
|
|
|
p_fax_number
|
This column is not currently used by the Banner Finance application. VARCHAR2(12)
|
|
|
p_fax_ext
|
This column is not currently used by the Banner Finance application. VARCHAR2(10)
|
|
|
p_attention_to
|
This column is not currently used by the Banner Finance application. VARCHAR2(35)
|
|
|
p_vendor_contact
|
This column is not currently used by the Banner Finance application. VARCHAR2(35)
|
|
|
p_ach_override_ind
|
Indicates if the active ACH status of the vendor as defined in form GXADIRD should be overridden when processing payment for this Invoice. If Y, the Invoice payment will be made via check. VARCHAR2(1)
|
|
|
p_acht_code
|
ACH Transaction Type code required for International ACH Transaction (IAT) direct deposits. VARCHAR2(8)
|
|
|
p_origin_code
|
Identifies the source of the Invoice document. VARCHAR2(10)
|
|
|
p_match_required
|
Indicates if this Invoice must be forwarded through the matching process. Valid values are:
|
|
N
|
- No matching required.
|
|
|
Y
|
- Matching required
|
|
|
U
|
- The matching requirement is unspecified or undetermined. VARCHAR2(1) Required.
|
|
|
|
p_data_origin
|
Source system that generated the data. VARCHAR2(30)
|
|
|
p_vend_hold_ovrd_ind
|
Indicates an authorized user has approved an invoice for payment when the vendor has a payment hold. VARCHAR2(1)
|
|
|
p_vend_hold_ovrd_user
|
The Oracle ID of the last user who added the Vendor Hold Override. VARCHAR2(30)
|
|
|
p_rowid_out
|
Database ROWID of the record to be created. VARCHAR2(18) Required
|
p_create_header
Procedure p_create_header(invoice_header_data IN OUT invoice_header_rec,
invoice_prefix_type varchar2 DEFAULT M_DOC_SEQNO_TYPE)
Creates an invoice header record in the invoice table FABINVH.
|
|
invoice_header_data
|
All of the header data needed to create an invoice header record.
|
p_delete
Procedure p_delete(p_code fabinvh.fabinvh_code%TYPE DEFAULT NULL,
p_rowid gb_common.internal_record_id_type DEFAULT NULL,
p_user_id fabinvh.fabinvh_user_id%type DEFAULT gb_common.f_sct_user,
p_delete_mesg_out OUT gb_common_strings.err_type)
Deletes a record. Either the code or the rowid should be valued.
This procedure will delete only an incomplete document. It will not delete invoices that have items and accounting rows.
|
|
p_code
|
The unique identifier of an Invoice document. VARCHAR2(8).
|
|
|
p_rowid
|
Database ROWID of the record to be deleted. VARCHAR2(18)
|
|
|
p_user_id
|
The user id of the user deleting the invoice. VARCHAR2(30).
|
|
|
p_delete_mesg_out
|
Any notes or warnings to the user that were raised during the processing of the delete.
|
p_lock
Procedure p_lock(p_code fabinvh.fabinvh_code%TYPE,
p_rowid_inout IN OUT gb_common.internal_record_id_type)
Locks a record.
If ROWID is not passed in, the record is located using the key values and the ROWID of the locked row is passed in p_rowid_inout.
|
|
p_code
|
The unique identifier of an Invoice document. The code may be system-generated. VARCHAR2(8) Required Key
|
|
|
p_rowid_inout
|
Database ROWID of the record to be locked. VARCHAR2(18) Required
|
p_update
Procedure p_update(p_code fabinvh.fabinvh_code%TYPE,
p_pohd_code fabinvh.fabinvh_pohd_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_vend_pidm fabinvh.fabinvh_vend_pidm%TYPE DEFAULT dml_common.f_unspecified_number,
p_open_paid_ind fabinvh.fabinvh_open_paid_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_user_id fabinvh.fabinvh_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_vend_inv_code fabinvh.fabinvh_vend_inv_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_invoice_date fabinvh.fabinvh_invoice_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_pmt_due_date fabinvh.fabinvh_pmt_due_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_trans_date fabinvh.fabinvh_trans_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_cr_memo_ind fabinvh.fabinvh_cr_memo_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_adjt_code fabinvh.fabinvh_adjt_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_adjt_date fabinvh.fabinvh_adjt_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_1099_ind fabinvh.fabinvh_1099_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_1099_id fabinvh.fabinvh_1099_id%TYPE DEFAULT dml_common.f_unspecified_string,
p_ityp_seq_code fabinvh.fabinvh_ityp_seq_code%TYPE DEFAULT dml_common.f_unspecified_number,
p_appr_ind fabinvh.fabinvh_appr_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_complete_ind fabinvh.fabinvh_complete_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_disc_code fabinvh.fabinvh_disc_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_trat_code fabinvh.fabinvh_trat_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_addl_chrg_amt fabinvh.fabinvh_addl_chrg_amt%TYPE DEFAULT dml_common.f_unspecified_number,
p_hold_ind fabinvh.fabinvh_hold_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_cancel_ind fabinvh.fabinvh_cancel_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_cancel_date fabinvh.fabinvh_cancel_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_post_date fabinvh.fabinvh_post_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_atyp_code fabinvh.fabinvh_atyp_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_atyp_seq_num fabinvh.fabinvh_atyp_seq_num%TYPE DEFAULT dml_common.f_unspecified_number,
p_grouping_ind fabinvh.fabinvh_grouping_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_bank_code fabinvh.fabinvh_bank_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_ruiv_ind fabinvh.fabinvh_ruiv_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_edit_defer_ind fabinvh.fabinvh_edit_defer_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_override_tax_amt fabinvh.fabinvh_override_tax_amt%TYPE DEFAULT dml_common.f_unspecified_number,
p_tgrp_code fabinvh.fabinvh_tgrp_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_submission_number fabinvh.fabinvh_submission_number%TYPE DEFAULT dml_common.f_unspecified_number,
p_vend_check_pidm fabinvh.fabinvh_vend_check_pidm%TYPE DEFAULT dml_common.f_unspecified_number,
p_curr_code fabinvh.fabinvh_curr_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_disb_agent_ind fabinvh.fabinvh_disb_agent_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_atyp_code_vend fabinvh.fabinvh_atyp_code_vend%TYPE DEFAULT dml_common.f_unspecified_string,
p_atyp_seq_num_vend fabinvh.fabinvh_atyp_seq_num_vend%TYPE DEFAULT dml_common.f_unspecified_number,
p_nsf_on_off_ind fabinvh.fabinvh_nsf_on_off_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_single_acctg_ind fabinvh.fabinvh_single_acctg_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_one_time_vend_name fabinvh.fabinvh_one_time_vend_name%TYPE DEFAULT dml_common.f_unspecified_string,
p_one_time_house_number fabinvh.fabinvh_one_time_house_number%TYPE DEFAULT dml_common.f_unspecified_string,
p_one_time_vend_addr1 fabinvh.fabinvh_one_time_vend_addr1%TYPE DEFAULT dml_common.f_unspecified_string,
p_one_time_vend_addr2 fabinvh.fabinvh_one_time_vend_addr2%TYPE DEFAULT dml_common.f_unspecified_string,
p_one_time_vend_addr3 fabinvh.fabinvh_one_time_vend_addr3%TYPE DEFAULT dml_common.f_unspecified_string,
p_one_time_vend_addr4 fabinvh.fabinvh_one_time_vend_addr4%TYPE DEFAULT dml_common.f_unspecified_string,
p_one_time_vend_city fabinvh.fabinvh_one_time_vend_city%TYPE DEFAULT dml_common.f_unspecified_string,
p_one_time_vend_state fabinvh.fabinvh_one_time_vend_state%TYPE DEFAULT dml_common.f_unspecified_string,
p_one_time_vend_zip fabinvh.fabinvh_one_time_vend_zip%TYPE DEFAULT dml_common.f_unspecified_string,
p_one_time_vend_natn fabinvh.fabinvh_one_time_vend_natn%TYPE DEFAULT dml_common.f_unspecified_string,
p_delivery_point fabinvh.fabinvh_delivery_point%TYPE DEFAULT dml_common.f_unspecified_number,
p_correction_digit fabinvh.fabinvh_correction_digit%TYPE DEFAULT dml_common.f_unspecified_number,
p_carrier_route fabinvh.fabinvh_carrier_route%TYPE DEFAULT dml_common.f_unspecified_string,
p_ruiv_installment_ind fabinvh.fabinvh_ruiv_installment_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_multiple_inv_ind fabinvh.fabinvh_multiple_inv_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_phone_area fabinvh.fabinvh_phone_area%TYPE DEFAULT dml_common.f_unspecified_string,
p_phone_number fabinvh.fabinvh_phone_number%TYPE DEFAULT dml_common.f_unspecified_string,
p_phone_ext fabinvh.fabinvh_phone_ext%TYPE DEFAULT dml_common.f_unspecified_string,
p_email_addr fabinvh.fabinvh_email_addr%TYPE DEFAULT dml_common.f_unspecified_string,
p_ctry_code_fax fabinvh.fabinvh_ctry_code_fax%TYPE DEFAULT dml_common.f_unspecified_string,
p_fax_area fabinvh.fabinvh_fax_area%TYPE DEFAULT dml_common.f_unspecified_string,
p_fax_number fabinvh.fabinvh_fax_number%TYPE DEFAULT dml_common.f_unspecified_string,
p_fax_ext fabinvh.fabinvh_fax_ext%TYPE DEFAULT dml_common.f_unspecified_string,
p_cancel_code fabinvh.fabinvh_cancel_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_attention_to fabinvh.fabinvh_attention_to%TYPE DEFAULT dml_common.f_unspecified_string,
p_vendor_contact fabinvh.fabinvh_vendor_contact%TYPE DEFAULT dml_common.f_unspecified_string,
p_invd_re_establish_ind fabinvh.fabinvh_invd_re_establish_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_ach_override_ind fabinvh.fabinvh_ach_override_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_acht_code fabinvh.fabinvh_acht_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_origin_code fabinvh.fabinvh_origin_code%TYPE DEFAULT dml_common.f_unspecified_string,
p_match_required fabinvh.fabinvh_match_required%TYPE DEFAULT dml_common.f_unspecified_string,
p_data_origin fabinvh.fabinvh_data_origin%TYPE DEFAULT dml_common.f_unspecified_string,
p_cancel_user fabinvh.fabinvh_cancel_user%TYPE DEFAULT dml_common.f_unspecified_string,
p_cancel_activity_date fabinvh.fabinvh_cancel_activity_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_ctry_code_phone fabinvh.fabinvh_ctry_code_phone%TYPE DEFAULT dml_common.f_unspecified_string,
p_vend_hold_ovrd_ind fabinvh.fabinvh_vend_hold_ovrd_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_vend_hold_ovrd_user fabinvh.fabinvh_vend_hold_ovrd_user%TYPE DEFAULT dml_common.f_unspecified_string,
p_rowid gb_common.internal_record_id_type DEFAULT NULL,
p_default_if_null VARCHAR2 DEFAULT 'N')
Updates an already existing row of data in the invoice header table FABINVH.
|
|
p_code
|
The unique identifier of an Invoice document. The code may be system-generated. VARCHAR2(8) Required Key
|
|
|
p_pohd_code
|
The Purchase Order or General Encumbrance document number which is referenced on the Invoice, if any. Only populated for Regular or General Encumbrance Invoice types. VARCHAR2(8)
|
|
|
p_vend_pidm
|
The unique internal identification number of the Invoice vendor. NUMBER(8)
|
|
|
p_open_paid_ind
|
Indicates the payment status of the Invoice document. Valid values are O if the Invoice is open and P if the Invoice is paid. VARCHAR2(1) Required
|
|
|
p_user_id
|
The unique identification code of the user who last updated the Invoice document. VARCHAR2(30) Required
|
|
|
p_vend_inv_code
|
The Invoice number as supplied by the vendor. VARCHAR2(15)
|
|
|
p_invoice_date
|
A user-defined or system-generated Invoice date. Basis of calculated Payment Due Date if terms/discount are used. DATE
|
|
|
p_pmt_due_date
|
The date an Invoice is due. Can be user-defined or calculated based on Invoice terms/discount. DATE
|
|
|
p_trans_date
|
The date the Invoice document will be recorded in the ledgers. DATE
|
|
|
p_cr_memo_ind
|
Indicates that the Invoice should be processed as a Credit Memo. If Y, the payment will be recorded as a Credit Memo. VARCHAR2(1) Required
|
|
|
p_adjt_code
|
This column is not currently used by the Banner Finance application. VARCHAR2(2)
|
|
|
p_adjt_date
|
This column is not currently used by the Banner Finance application. DATE
|
|
|
p_1099_ind
|
Indicates that the Invoice includes taxable payments. If Y, the payment will be recorded in the 1099 tables and accumulated for income tax reporting purposes. VARCHAR2(1)
|
|
|
p_1099_id
|
The 1099 tax reporting ID of the vendor. VARCHAR2(9)
|
|
|
p_ityp_seq_code
|
The internal value which represents the user selected income type (as defined in table FTVITYP) for 1099 processing and reporting purposes. Defaults from vendor record (as defined on FTVVEND). NUMBER(2)
|
|
|
p_appr_ind
|
Indicates if the document has been approved. If Y, the document has received final approval. VARCHAR2(1)
|
|
|
p_complete_ind
|
Indicates if the document has been completed. If Y, the document has received been completed. VARCHAR2(1)
|
|
|
p_disc_code
|
The discount code (as defined in table FTVDISC) to be used to define payment terms for the processing of the Invoice. VARCHAR2(2)
|
|
|
p_trat_code
|
This column is not currently used by the Banner Finance application. VARCHAR2(3)
|
|
|
p_addl_chrg_amt
|
The total dollar value of any additional charges, e.g., freight associated with this Invoice. NUMBER(17,2)
|
|
|
p_hold_ind
|
Indicates that the Invoice record has been placed on hold to prevent payment to a vendor. Indicator is set via FAAINVE or FAAPAYC form. If Y, the document will be withheld from the payment process. VARCHAR2(1) Required
|
|
|
p_cancel_ind
|
Indicates if the Invoice has been cancelled. VARCHAR2(1) Required
|
|
|
p_cancel_date
|
The date that the Invoice was cancelled. DATE
|
|
|
p_post_date
|
This column is not currently used by the Banner Finance application. DATE
|
|
|
p_atyp_code
|
Used to identify the vendor address type to which the payment will be made. When using Check Vendor this value will be the address type for the vendor defined in FABINVH_VEND_CHECK_PIDM. VARCHAR2(2)
|
|
|
p_atyp_seq_num
|
Used to identify the vendor address type sequence to which the payment will be made. When using Check Vendor this value will be the address type sequence for the vendor defined in FABINVH_VEND_CHECK_PIDM. NUMBER(2)
|
|
|
p_grouping_ind
|
Indicates the relationship between the number of invoices processed and the number of checks. A value of 1 creates one check per invoice; a value of M combines many invoices on one check. VARCHAR2(1)
|
|
|
p_bank_code
|
The Bank Code (as defined in table GXVBANK) to be used for processing the payment of the Invoice. VARCHAR2(2)
|
|
|
p_ruiv_ind
|
Indicates that an invoice will be processed on a recurring basis on a specific schedule as defined in the form FAARUIV. VARCHAR2(1)
|
|
|
p_edit_defer_ind
|
Indicates that document editing of the Invoice will be deferred until after completion. VARCHAR2(1)
|
|
|
p_override_tax_amt
|
This column is not currently used by the Banner Finance application. NUMBER(17,2)
|
|
|
p_tgrp_code
|
The tax group (as defined in table FTVTGRP) to be used for the processing of the Invoice. VARCHAR2(4)
|
|
|
p_submission_number
|
The internal submission number for the Invoice record. Used for tracking recurring and re-established Invoice documents. NUMBER(3)
|
|
|
p_vend_check_pidm
|
The unique internal identification number of the Invoice check vendor or disbursing agent when one is identified. NUMBER(8)
|
|
|
p_invoice_type_ind
|
Indicates the type of Invoice. Valid values are D for Direct Pay/General Encumbrance or R for Regular. VARCHAR2(1) Required
|
|
|
p_curr_code
|
The currency (as defined in table GTVCURR) to be used for the processing of the Invoice. VARCHAR2(4)
|
|
|
p_disb_agent_ind
|
Indicates that the Invoice will use a Disbursing Agent for payment. The Disbursing Agent is associated to a foreign currency on form GUACURR. VARCHAR2(1)
|
|
|
p_atyp_code_vend
|
Identifies the address type for the Invoice vendor defined in FABINVH_VEND_PIDM. VARCHAR2(2)
|
|
|
p_atyp_seq_num_vend
|
Used to identify the address type sequence number for the Invoice vendor defined in FABINVH_VEND_PIDM. NUMBER(2)
|
|
|
p_nsf_on_off_ind
|
Indicates when non-sufficient funds checking will be done. If Y checking will be performed at time of data entry. VARCHAR2(1)
|
|
|
p_single_acctg_ind
|
Indicates the Accounting Level used for the Invoice. Valid values are Y for Document Level Accounting and N for Commodity Level Accounting. VARCHAR2(1)
|
|
|
p_one_time_vend_name
|
Name for use with One Time Vendor. VARCHAR2(60)
|
|
|
p_one_time_house_number
|
Building or lot number on a street or in an area for One Time Vendor. VARCHAR2(10)
|
|
|
p_one_time_vend_addr1
|
Address Line 1 for use with One Time Vendor. VARCHAR2(75)
|
|
|
p_one_time_vend_addr2
|
Address Line 2 for use with One Time Vendor. VARCHAR2(75)
|
|
|
p_one_time_vend_addr3
|
Address Line 3 for use with One Time Vendor. VARCHAR2(75)
|
|
|
p_one_time_vend_addr4
|
Address Line 4 for use with One Time Vendor. VARCHAR2(75)
|
|
|
p_one_time_vend_city
|
City for use with One Time Vendor. VARCHAR2(50)
|
|
|
p_one_time_vend_state
|
State or Province for use with One Time Vendor. VARCHAR2(3)
|
|
|
p_one_time_vend_zip
|
Zip or Postal Code for use with One Time Vendor. VARCHAR2(30)
|
|
|
p_one_time_vend_natn
|
Nation for use with One Time Vendor. VARCHAR2(5)
|
|
|
p_delivery_point
|
This column is not currently used by the Banner Finance application. NUMBER(2)
|
|
|
p_correction_digit
|
This column is not currently used by the Banner Finance application. NUMBER(1)
|
|
|
p_carrier_route
|
This column is not currently used by the Banner Finance application. VARCHAR2(4)
|
|
|
p_ruiv_installment_ind
|
Indicates whether the Invoice when set up as recurring payment is an installment. It is used by the fixed asset module to determine the capitalization amount. VARCHAR2(1)
|
|
|
p_multiple_inv_ind
|
Indicates if multiple vendor invoices are associated with the Banner Invoice document. If Y, then additional information is stored in the table FARVINV. VARCHAR2(1)
|
|
|
p_ctry_code_phone
|
Code designating the region or country. VARCHAR2(4)
|
|
|
p_phone_area
|
This column is not currently used by the Banner Finance application. VARCHAR2(6)
|
|
|
p_phone_number
|
This column is not currently used by the Banner Finance application. VARCHAR2(12)
|
|
|
p_phone_ext
|
This column is not currently used by the Banner Finance application. VARCHAR2(10)
|
|
|
p_email_addr
|
This column is not currently used by the Banner Finance application. VARCHAR2(20)
|
|
|
p_ctry_code_fax
|
This column is not currently used by the Banner Finance application. VARCHAR2(4)
|
|
|
p_fax_area
|
This column is not currently used by the Banner Finance application. VARCHAR2(6)
|
|
|
p_fax_number
|
This column is not currently used by the Banner Finance application. VARCHAR2(12)
|
|
|
p_fax_ext
|
This column is not currently used by the Banner Finance application. VARCHAR2(10)
|
|
|
p_cancel_code
|
This column is not currently used by the Banner Finance application. VARCHAR2(4)
|
|
|
p_attention_to
|
This column is not currently used by the Banner Finance application. VARCHAR2(35)
|
|
|
p_vendor_contact
|
This column is not currently used by the Banner Finance application. VARCHAR2(35)
|
|
|
p_invd_re_establish_ind
|
Indicates whether the Invoice is to be re-established at invoice cancellation time. Indicator is set based on population of Re-establish Indicator on FAAINVD. Indicator is cleared after invoice cancellation is posted. VARCHAR2(1)
|
|
|
p_ach_override_ind
|
Indicates if the active ACH status of the vendor as defined on form GXADIRD should be overridden when processing payment for this Invoice. If Y, the Invoice payment will be made via check and not via direct deposit. VARCHAR2(1)
|
|
|
p_acht_code
|
ACH Transaction Type code required for International ACH Transaction (IAT) direct deposits. VARCHAR2(8)
|
|
|
p_origin_code
|
Identifies the source of the Invoice document. VARCHAR2(10)
|
|
|
p_match_required
|
Indicates if this Invoice must be forwarded through the matching process. Valid values are:
|
|
N
|
- No matching required.
|
|
|
Y
|
- Matching required
|
|
|
U
|
- The matching requirement is unspecified/undetermined. VARCHAR2(1) Required* @param p_complete_user This field contains the Banner User ID of the user who completed this invoice and forwarded it to the next process. VARCHAR2(30)
|
|
|
|
p_complete_date
|
The date on which this invoice was completed and forwarded to the next process. DATE
|
|
|
p_data_origin
|
Source system that generated the data. VARCHAR2(30)
|
|
|
p_cancel_user
|
The userid of the user who cancelled the invoice VARCHAR2(30)
|
|
|
p_cancel_activity_date
|
The date on which the invoice was cancelled. DATE
|
|
|
p_vend_hold_ovrd_ind
|
Indicates an authorized user has approved an invoice for payment when the vendor has a payment hold. VARCHAR2(1)
|
|
|
p_vend_hold_ovrd_user
|
The Oracle ID of the last user who added the Vendor Hold Override. VARCHAR2(30)
|
|
|
p_rowid
|
Database ROWID of the record to be updated. VARCHAR2(18)
|
p_update_header
Procedure p_update_header(invoice_header_data IN OUT invoice_header_rec,
p_default_if_null varchar2 default 'N')
Updates an already existing row of data in the invoice header table FABINVH.
|
|
invoice_header_data
|
All of the header data needed to update an invoice header record.
|
|
|
p_default_if_null
|
Defaults the value N. If Y, then a null parameter value gets overridden with the value from the database. If N, then a null parameter value is considered a valid value.
|
p_update_internal
Procedure p_update_internal(p_check_code fabchka.fabchka_check_num%TYPE,
p_bank_code fabchka.fabchka_bank_code%TYPE,
p_user_id fabinvh.fabinvh_user_id%TYPE default gb_common.f_sct_user,
p_reestablish_ind VARCHAR2 default NULL,
p_cancel_date DATE default NULL)
Updates multiple header records when a check is cancelled or the check cancellation rolls back.
|
|
p_check_code
|
THe number of the check that is being cancelled. VARCHAR2(8)
|
|
|
p_bank_code
|
The bank code on the check. VARCHAR2(2)
|
|
|
p_user_id
|
The user id of the user performing this action. VARCHAR2(30)
|
|
|
p_reestablish_ind
|
Y - The invoices are being reestablished. N - The invoices are also being cancelled and not reestablished.
|
|
|
p_cancel_date
|
The date on which the check was cancelled. DATE
|