Package BANINST1.fb_invoice

Package BANINST1.fb_invoice_acctg

Common Business interface for the Invoice Accounting API (fb_invoice_acctg).

Program units

f_api_version	Returns the API version number.
f_exists	Checks to see if a record exists.
f_isequal	Compares two records for equality.
f_query_all	Selects all records for the entity.
f_query_one	Selects one record using key.
f_query_by_rowid	Selects one record using ROWID.
f_query_one_lock	Selects one record and locks it.
f_exists_doclevel_acctg	Retrieves whether accounting rows copied over from purchase order exist for a regular document level invoice
f_get_max_seq_num	Selects the maximum sequence number used for the invoice code and item.
f_convert_rectype_to_rowtype	Converts a record of invoice_acctg_rec type to a record of farinva%rowtype.
p_create	Creates a record.
p_create_accounting	Creates an accounting record.
p_delete	Deletes a record.
p_lock	Locks a record.
p_update	Updates a record.
p_update_internal	Updates records using direct dml.
p_delete_internal	Delete records using direct dml.
p_do_inv_nsf	Updates farinva and check available balance.

Types

invoice_acctg_rec	Business Entity record type
invoice_acctg_ref	Entity cursor variable type
invoice_acctg_tab	Entity table type

Constants

M_ENTITY_NAME	Business Entity Name
M_BASE_TABLE_NAME	Base table name

M_ENTITY_NAME

M_ENTITY_NAME    CONSTANT VARCHAR2(13) := 'INVOICE_ACCTG';

Business Entity Name

M_BASE_TABLE_NAME

M_BASE_TABLE_NAME    CONSTANT VARCHAR2(7) := 'FARINVA';

Base table name

invoice_acctg_rec

TYPE invoice_acctg_rec IS RECORD (
  r_invh_code               farinva.farinva_invh_code%TYPE,
  r_pohd_code               farinva.farinva_pohd_code%TYPE,
  r_item                    farinva.farinva_item%TYPE,
  r_po_item                 farinva.farinva_po_item%TYPE,
  r_seq_num                 farinva.farinva_seq_num%TYPE,
  r_user_id                 farinva.farinva_user_id%TYPE,
  r_fsyr_code               farinva.farinva_fsyr_code%TYPE,
  r_period                  farinva.farinva_period%TYPE,
  r_eoy_accr_status_ind     farinva.farinva_eoy_accr_status_ind%TYPE,
  r_rucl_code               farinva.farinva_rucl_code%TYPE,
  r_disc_rucl_code          farinva.farinva_disc_rucl_code%TYPE,
  r_tax_rucl_code           farinva.farinva_tax_rucl_code%TYPE,
  r_addl_rucl_code          farinva.farinva_addl_rucl_code%TYPE,
  r_coas_code               farinva.farinva_coas_code%TYPE,
  r_acci_code               farinva.farinva_acci_code%TYPE,
  r_fund_code               farinva.farinva_fund_code%TYPE,
  r_orgn_code               farinva.farinva_orgn_code%TYPE,
  r_acct_code               farinva.farinva_acct_code%TYPE,
  r_prog_code               farinva.farinva_prog_code%TYPE,
  r_actv_code               farinva.farinva_actv_code%TYPE,
  r_locn_code               farinva.farinva_locn_code%TYPE,
  r_bank_code               farinva.farinva_bank_code%TYPE,
  r_invd_amt                farinva.farinva_invd_amt%TYPE,
  r_disc_amt                farinva.farinva_disc_amt%TYPE,
  r_tax_amt                 farinva.farinva_tax_amt%TYPE,
  r_addl_chrg_amt           farinva.farinva_addl_chrg_amt%TYPE,
  r_appr_amt                farinva.farinva_appr_amt%TYPE,
  r_prev_paid_amt           farinva.farinva_prev_paid_amt%TYPE,
  r_nsf_override_ind        farinva.farinva_nsf_override_ind%TYPE,
  r_ityp_seq_code           farinva.farinva_ityp_seq_code%TYPE,
  r_proj_code               farinva.farinva_proj_code%TYPE,
  r_susp_ind                farinva.farinva_susp_ind%TYPE,
  r_nsf_susp_ind            farinva.farinva_nsf_susp_ind%TYPE,
  r_partial_liq_ind         farinva.farinva_partial_liq_ind%TYPE,
  r_appr_ind                farinva.farinva_appr_ind%TYPE,
  r_open_paid_ind           farinva.farinva_open_paid_ind%TYPE,
  r_convert_amt             farinva.farinva_convert_amt%TYPE,
  r_convert_disc_amt        farinva.farinva_convert_disc_amt%TYPE,
  r_convert_tax_amt         farinva.farinva_convert_tax_amt%TYPE,
  r_convert_addl_chrg_amt   farinva.farinva_convert_addl_chrg_amt%TYPE,
  r_appr_amt_pct            farinva.farinva_appr_amt_pct%TYPE,
  r_disc_amt_pct            farinva.farinva_disc_amt_pct%TYPE,
  r_addl_amt_pct            farinva.farinva_addl_amt_pct%TYPE,
  r_tax_amt_pct             farinva.farinva_tax_amt_pct%TYPE,
  r_cap_amt                 farinva.farinva_cap_amt%TYPE,
  r_data_origin             farinva.farinva_data_origin%TYPE,
  r_create_user             farinva.farinva_create_user%TYPE,
  r_create_date             farinva.farinva_create_date%TYPE,
  r_internal_record_id      Gb_Common.internal_record_id_type);

Business Entity record type

invoice_acctg_ref

TYPE invoice_acctg_ref IS REF CURSOR RETURN invoice_acctg_rec;

Entity cursor variable type

invoice_acctg_tab

TYPE invoice_acctg_tab IS TABLE OF invoice_acctg_rec INDEX BY BINARY_INTEGER;

Entity table type

f_api_version

Function f_api_version RETURN PLS_INTEGER

Returns the API version number.

Returns

Version of the API signature. Changes only when the signature changes.

f_exists

Function f_exists(p_invh_code farinva.farinva_invh_code%TYPE,
                  p_item      farinva.farinva_item%TYPE DEFAULT NULL,
                  p_seq_num   farinva.farinva_seq_num%TYPE DEFAULT NULL,
                  p_rowid     Gb_Common.internal_record_id_type DEFAULT NULL)
  RETURN VARCHAR2

Checks to see if a record exists.

Parameters

	p_invh_code	The unique identifier of an Invoice document. VARCHAR2(8) Required Key
	p_item	The reference number which associates an invoice accounting record to the related invoice commodity item. If 0, then invoice accounting record applies to all invoice commodity items (Document Level Accounting). If not 0, then invoice accounting record applies to the invoice commodity item of that number (Commodity Level Accounting). NUMBER(4) Required Key
	p_seq_num	The system-generated unique number associated with the Item Number of the accounting record. NUMBER(4) Required Key
	p_rowid	Database ROWID of the record to be selected. VARCHAR2(18)

Returns

Y if found, otherwise N.

f_isequal

Function f_isequal(rec_one invoice_acctg_rec, rec_two invoice_acctg_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.

Parameters

	rec_one	The first record to compare. Type invoice_acctg_rec Required
	rec_two	The second record to compare. Type invoice_acctg_rec Required

Returns

Y if all values in records are equal, otherwise N. Nulls match Nulls.

f_query_all

Function f_query_all(p_invh_code farinva.farinva_invh_code%TYPE,
                     p_item      farinva.farinva_item%TYPE DEFAULT NULL,
                     p_seq_num   farinva.farinva_seq_num%TYPE DEFAULT NULL)
  RETURN invoice_acctg_ref

Selects all records for the entity.

Parameters

	p_invh_code	The unique identifier of an Invoice document. VARCHAR2(8) Required Key
	p_item	The reference number which associates an invoice accounting record to the related invoice commodity item. If 0, then invoice accounting record applies to all invoice commodity items (Document Level Accounting). If not 0, then invoice accounting record applies to the invoice commodity item of that number (Commodity Level Accounting). NUMBER(4) Required Key
	p_seq_num	The system-generated unique number associated with the Item Number of the accounting record. NUMBER(4) Required Key

Returns

A cursor variable that will fetch the set of records.

f_query_one

Function f_query_one(p_invh_code farinva.farinva_invh_code%TYPE,
                     p_item      farinva.farinva_item%TYPE,
                     p_seq_num   farinva.farinva_seq_num%TYPE)
  RETURN invoice_acctg_ref

Selects one record using key.

Parameters

	p_invh_code	The unique identifier of an Invoice document. VARCHAR2(8) Required Key
	p_item	The reference number which associates an invoice accounting record to the related invoice commodity item. If 0, then invoice accounting record applies to all invoice commodity items (Document Level Accounting). If not 0, then invoice accounting record applies to the invoice commodity item of that number (Commodity Level Accounting). NUMBER(4) Required Key
	p_seq_num	The system-generated unique number associated with the Item Number of the accounting record. NUMBER(4) Required Key

Returns

A cursor variable that will fetch exactly one record.

f_query_by_rowid

Function f_query_by_rowid(p_rowid Gb_Common.internal_record_id_type)
  RETURN invoice_acctg_ref

Selects one record using ROWID.

Parameters

p_rowid

Database ROWID of the record to be selected. VARCHAR2(18) Required

Returns

A cursor variable that will fetch exactly one record.

f_query_one_lock

Function f_query_one_lock(p_invh_code farinva.farinva_invh_code%TYPE,
                          p_item      farinva.farinva_item%TYPE,
                          p_seq_num   farinva.farinva_seq_num%TYPE,
                          p_rowid     Gb_Common.internal_record_id_type DEFAULT NULL)
  RETURN invoice_acctg_ref

Selects one record and locks it.

Parameters

	p_invh_code	The unique identifier of an Invoice document. VARCHAR2(8) Required Key
	p_item	The reference number which associates an invoice accounting record to the related invoice commodity item. If 0, then invoice accounting record applies to all invoice commodity items (Document Level Accounting). If not 0, then invoice accounting record applies to the invoice commodity item of that number (Commodity Level Accounting). NUMBER(4) Required Key
	p_seq_num	The system-generated unique number associated with the Item Number of the accounting record. NUMBER(4) Required Key
	p_rowid	Database ROWID of the record to be selected. VARCHAR2(18)

Returns

A cursor variable for one record, locking the record.

f_exists_doclevel_acctg

Function f_exists_doclevel_acctg(p_invh_code farinva.farinva_invh_code%TYPE,
                                 p_pohd_code farinva.farinva_pohd_code%type,
                                 p_seq_num   farinva.farinva_seq_num%TYPE DEFAULT NULL,
                                 p_coas_code farinva.farinva_coas_code%TYPE DEFAULT NULL,
                                 p_acci_code farinva.farinva_acci_code%TYPE DEFAULT NULL,
                                 p_fund_code farinva.farinva_fund_code%TYPE DEFAULT null,
                                 p_orgn_code farinva.farinva_orgn_code%TYPE DEFAULT NULL,
                                 p_acct_code farinva.farinva_acct_code%TYPE DEFAULT NULL,
                                 p_prog_code farinva.farinva_prog_code%TYPE DEFAULT NULL,
                                 p_actv_code farinva.farinva_actv_code%TYPE DEFAULT NULL,
                                 p_locn_code farinva.farinva_locn_code%TYPE DEFAULT NULL)
  RETURN VARCHAR2

Retrieves whether accounting rows copied over from purchase order exist for a regular document level invoice

Parameters

	p_invh_code	The unique identifier of an Invoice document. VARCHAR2(8) Required Key
	p_pohd_code	The purchase order code. VARCHAR2(8) Required
	p_seq_num	The system-generated unique number associated with the Item Number of the accounting record. NUMBER(4) Required Key
	p_coas_code	The Chart of Accounts code (as defined in table FTVCOAS) referenced by the invoice transactions. VARCHAR2(1)
	p_acci_code	The Index Code (as defined in table FTVACCI) that may be entered to default various accounting elements. VARCHAR2(6)
	p_fund_code	The Fund Code (as defined in table FTVFUND) referenced by the invoice transactions. VARCHAR2(6)
	p_orgn_code	The Organization Code (as defined in table FTVORGN) referenced by the invoice transactions. VARCHAR2(6)
	p_acct_code	The Account Code (as defined in table FTVACCT) referenced by the invoice transactions. May default from the Commodity Code. VARCHAR2(6)
	p_prog_code	The Program Code (as defined in table FTVPROG) referenced by the invoice transactions. VARCHAR2(6)
	p_actv_code	The Activity Code (as defined in table FTVACTV) referenced by the invoice transactions. VARCHAR2(6)
	p_locn_code	The Location Code (as defined in table FTVLOCN) referenced by the invoice transactions. VARCHAR2(6)

Returns

'Y' or 'N'; 'Y' if copied accounting rows exist, 'N' if copied accounting rows do not exist.

f_get_max_seq_num

Function f_get_max_seq_num(p_invh_code FARINVA.FARINVA_INVH_CODE%TYPE,
                           p_item      FARINVA.FARINVA_ITEM%TYPE)
  RETURN NUMBER

Selects the maximum sequence number used for the invoice code and item.

Parameters

	p_invh_code	The unique identifier of an Invoice document. VARCHAR2(8) Required Key
	p_item	The reference number which associates an invoice accounting record to the related invoice commodity item.

Returns

A number representing the maximum sequence number.

f_convert_rectype_to_rowtype

Function f_convert_rectype_to_rowtype(p_invacctg_rec invoice_acctg_rec)
  RETURN farinva%ROWTYPE

Converts a record of invoice_acctg_rec type to a record of farinva%rowtype.

Parameters

p_invhead_rec

A pl/sql record variable of type invoice header_rec

Returns

fabinvh%rowtype

p_create

Procedure p_create(p_invh_code        farinva.farinva_invh_code%TYPE,
                   p_pohd_code        farinva.farinva_pohd_code%TYPE DEFAULT NULL,
                   p_item             farinva.farinva_item%TYPE,
                   p_po_item          farinva.farinva_po_item%TYPE DEFAULT NULL,
                   p_seq_num          farinva.farinva_seq_num%TYPE,
                   p_user_id          farinva.farinva_user_id%TYPE DEFAULT Gb_Common.f_sct_user,
                   p_rucl_code        farinva.farinva_rucl_code%TYPE DEFAULT NULL,
                   p_disc_rucl_code   farinva.farinva_disc_rucl_code%TYPE DEFAULT NULL,
                   p_tax_rucl_code    farinva.farinva_tax_rucl_code%TYPE DEFAULT NULL,
                   p_addl_rucl_code   farinva.farinva_addl_rucl_code%TYPE DEFAULT NULL,
                   p_coas_code        farinva.farinva_coas_code%TYPE DEFAULT NULL,
                   p_acci_code        farinva.farinva_acci_code%TYPE DEFAULT NULL,
                   p_fund_code        farinva.farinva_fund_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_orgn_code        farinva.farinva_orgn_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_acct_code        farinva.farinva_acct_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_prog_code        farinva.farinva_prog_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_actv_code        farinva.farinva_actv_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_locn_code        farinva.farinva_locn_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_bank_code        farinva.farinva_bank_code%TYPE DEFAULT NULL,
                   p_disc_amt         farinva.farinva_disc_amt%TYPE DEFAULT NULL,
                   p_tax_amt          farinva.farinva_tax_amt%TYPE DEFAULT NULL,
                   p_addl_chrg_amt    farinva.farinva_addl_chrg_amt%TYPE DEFAULT NULL,
                   p_appr_amt         farinva.farinva_appr_amt%TYPE DEFAULT NULL,
                   p_nsf_override_ind farinva.farinva_nsf_override_ind%TYPE DEFAULT NULL,
                   p_ityp_seq_code    farinva.farinva_ityp_seq_code%TYPE DEFAULT NULL,
                   p_proj_code        farinva.farinva_proj_code%TYPE DEFAULT NULL,
                   p_susp_ind         farinva.farinva_susp_ind%TYPE DEFAULT NULL,
                   p_nsf_susp_ind     farinva.farinva_nsf_susp_ind%TYPE DEFAULT NULL,
                   p_appr_amt_pct     farinva.farinva_appr_amt_pct%TYPE DEFAULT NULL,
                   p_disc_amt_pct     farinva.farinva_disc_amt_pct%TYPE DEFAULT NULL,
                   p_addl_amt_pct     farinva.farinva_addl_amt_pct%TYPE DEFAULT NULL,
                   p_tax_amt_pct      farinva.farinva_tax_amt_pct%TYPE DEFAULT NULL,
                   p_data_origin      farinva.farinva_data_origin%TYPE DEFAULT NULL,
                   p_rowid_out        OUT Gb_Common.internal_record_id_type)

Creates a record.

Parameters

	p_invh_code	The unique identifier of an Invoice document. 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_item	The reference number which associates an invoice accounting record to the related invoice commodity item. If 0, then invoice accounting record applies to all invoice commodity items (Document Level Accounting). If not 0, then invoice accounting record applies to the invoice commodity item of that number (Commodity Level Accounting). NUMBER(4) Required Key
	p_po_item	The item number of the Purchase Order that is referenced by this invoice item. NUMBER(4)
	p_seq_num	The system-generated unique number associated with the Item Number of the accounting record. NUMBER(4) Required Key
	p_user_id	The unique identification code of the user who last updated the Invoice document. VARCHAR2(30) Required
	p_rucl_code	The rule class associated with the approved amount. The value passed in is considered only if the BATCH_MODE context is set. VARCHAR2(4)
	p_disc_rucl_code	The rule class associated with the Discount amount. The value passed in is considered only if the BATCH_MODE context is set. VARCHAR2(4)
	p_tax_rucl_code	The rule class associated with the Tax amount. The value passed in is considered only if the BATCH_MODE context is set. VARCHAR2(4)
	p_addl_rucl_code	The rule class associated with the Additional amount. The value passed in is considered only if the BATCH_MODE context is set. VARCHAR2(4)
	p_coas_code	The Chart of Accounts code (as defined in table FTVCOAS) referenced by the invoice transactions. VARCHAR2(1)
	p_acci_code	The Index Code (as defined in table FTVACCI) that may be entered to default various accounting elements. VARCHAR2(6)
	p_fund_code	The Fund Code (as defined in table FTVFUND) referenced by the invoice transactions. VARCHAR2(6)
	p_orgn_code	The Organization Code (as defined in table FTVORGN) referenced by the invoice transactions. VARCHAR2(6)
	p_acct_code	The Account Code (as defined in table FTVACCT) referenced by the invoice transactions. May default from the Commodity Code. VARCHAR2(6)
	p_prog_code	The Program Code (as defined in table FTVPROG) referenced by the invoice transactions. VARCHAR2(6)
	p_actv_code	The Activity Code (as defined in table FTVACTV) referenced by the invoice transactions. VARCHAR2(6)
	p_locn_code	The Location Code (as defined in table FTVLOCN) referenced by the invoice transactions. VARCHAR2(6)
	p_bank_code	The Bank Code (as defined from table GXVBANK) to be used for processing the payment of the Invoice. This value may default from the Fund Code. VARCHAR2(2)
	p_disc_amt	The discount amount to be distributed to this invoice accounting record. NUMBER(17,2)
	p_tax_amt	The tax amount to be distributed to this invoice accounting record. NUMBER(17,2)
	p_addl_chrg_amt	The additional amount to be distributed to this invoice accounting record. NUMBER(17,2)
	p_appr_amt	The approved amount to be distributed to this invoice accounting record. NUMBER(17,2)
	p_nsf_override_ind	This indicator permits authorized users on the form FOMPROF to bypass a non-sufficient funds condition. VARCHAR2(1)
	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_proj_code	The Project Code (as defined in table FTVPROJ) affected by the invoice transactions. This code is used for Cost Accounting purposes. VARCHAR2(8)
	p_appr_amt_pct	The percentage of the approved amount for the commodity item/document to be distributed to this invoice accounting record. This amount is also derived if no percentage is entered. NUMBER(21,16)
	p_disc_amt_pct	The percentage of the discount amount for the commodity item/document to be distributed to this invoice accounting record. This amount is also derived if no percentage is entered. NUMBER(21,16)
	p_addl_amt_pct	The percentage of the additional amount for the commodity item/document to be distributed to this invoice accounting record. This amount is also derived if no percentage is entered. NUMBER(21,16)
	p_tax_amt_pct	The percentage of the tax amount for the commodity item/document to be distributed to this invoice accounting record. This amount is also derived if no percentage is entered. NUMBER(21,16)
	p_data_origin	Source system that generated the data. VARCHAR2(30)
	p_rowid_out	Database ROWID of the record to be created. VARCHAR2(18) Required

p_create_accounting

Procedure p_create_accounting(p_inv_acctg_rec IN OUT invoice_acctg_rec)

Creates an accounting record.

Parameters

p_inv_acctg_rec

All of the accounting data needed to create an invoice accounting record.

p_delete

Procedure p_delete(p_invh_code farinva.farinva_invh_code%TYPE,
                   p_item      farinva.farinva_item%TYPE,
                   p_seq_num   farinva.farinva_seq_num%TYPE,
                   p_user_id   farinva.farinva_user_id%type default gb_common.f_sct_user,
                   p_rowid     Gb_Common.internal_record_id_type DEFAULT NULL)

Deletes a record.

Parameters

	p_invh_code	The unique identifier of an Invoice document. VARCHAR2(8) Required Key
	p_item	The reference number which associates an invoice accounting record to the related invoice commodity item. If 0, then invoice accounting record applies to all invoice commodity items (Document Level Accounting). If not 0, then invoice accounting record applies to the invoice commodity item of that number (Commodity Level Accounting). NUMBER(4) Required Key
	p_seq_num	The system-generated unique number associated with the Item Number of the accounting record. NUMBER(4) Required Key
	p_user_id	The unique identification code of the user who last updated the Invoice document. VARCHAR2(30)
	p_rowid	Database ROWID of the record to be deleted. VARCHAR2(18)

p_lock

Procedure p_lock(p_invh_code   farinva.farinva_invh_code%TYPE,
                 p_item        farinva.farinva_item%TYPE,
                 p_seq_num     farinva.farinva_seq_num%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.

Parameters

	p_invh_code	The unique identifier of an Invoice document. VARCHAR2(8) Required Key
	p_item	The reference number which associates an invoice accounting record to the related invoice commodity item. If 0, then invoice accounting record applies to all invoice commodity items (Document Level Accounting). If not 0, then invoice accounting record applies to the invoice commodity item of that number (Commodity Level Accounting). NUMBER(4) Required Key
	p_seq_num	The system-generated unique number associated with the Item Number of the accounting record. NUMBER(4) Required Key
	p_rowid_inout	Database ROWID of the record to be locked. VARCHAR2(18) Required

p_update

Procedure p_update(p_invh_code             farinva.farinva_invh_code%TYPE,
                   p_pohd_code             farinva.farinva_pohd_code%TYPE DEFAULT Dml_Common.f_unspecified_string,
                   p_item                  farinva.farinva_item%TYPE,
                   p_po_item               farinva.farinva_po_item%TYPE DEFAULT Dml_Common.f_unspecified_number,
                   p_seq_num               farinva.farinva_seq_num%TYPE,
                   p_user_id               farinva.farinva_user_id%TYPE DEFAULT Gb_Common.f_sct_user,
                   p_fsyr_code             farinva.farinva_fsyr_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_period                farinva.farinva_period%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_eoy_accr_status_ind   farinva.farinva_eoy_accr_status_ind%TYPE DEFAULT Dml_Common.f_unspecified_string,
                   p_rucl_code             farinva.farinva_rucl_code%TYPE DEFAULT Dml_Common.f_unspecified_string,
                   p_disc_rucl_code        farinva.farinva_disc_rucl_code%TYPE DEFAULT Dml_Common.f_unspecified_string,
                   p_tax_rucl_code         farinva.farinva_tax_rucl_code%TYPE DEFAULT Dml_Common.f_unspecified_string,
                   p_addl_rucl_code        farinva.farinva_addl_rucl_code%TYPE DEFAULT Dml_Common.f_unspecified_string,
                   p_coas_code             farinva.farinva_coas_code%TYPE DEFAULT Dml_Common.f_unspecified_string,
                   p_acci_code             farinva.farinva_acci_code%TYPE DEFAULT Dml_Common.f_unspecified_string,
                   p_fund_code             farinva.farinva_fund_code%TYPE DEFAULT Dml_Common.f_unspecified_string,
                   p_orgn_code             farinva.farinva_orgn_code%TYPE DEFAULT Dml_Common.f_unspecified_string,
                   p_acct_code             farinva.farinva_acct_code%TYPE DEFAULT Dml_Common.f_unspecified_string,
                   p_prog_code             farinva.farinva_prog_code%TYPE DEFAULT Dml_Common.f_unspecified_string,
                   p_actv_code             farinva.farinva_actv_code%TYPE DEFAULT Dml_Common.f_unspecified_string,
                   p_locn_code             farinva.farinva_locn_code%TYPE DEFAULT Dml_Common.f_unspecified_string,
                   p_bank_code             farinva.farinva_bank_code%TYPE DEFAULT Dml_Common.f_unspecified_string,
                   p_invd_amt              farinva.farinva_invd_amt%TYPE DEFAULT Dml_Common.f_unspecified_number,
                   p_disc_amt              farinva.farinva_disc_amt%TYPE DEFAULT Dml_Common.f_unspecified_number,
                   p_tax_amt               farinva.farinva_tax_amt%TYPE DEFAULT Dml_Common.f_unspecified_number,
                   p_addl_chrg_amt         farinva.farinva_addl_chrg_amt%TYPE DEFAULT Dml_Common.f_unspecified_number,
                   p_appr_amt              farinva.farinva_appr_amt%TYPE DEFAULT Dml_Common.f_unspecified_number,
                   p_prev_paid_amt         farinva.farinva_prev_paid_amt%TYPE DEFAULT Dml_Common.f_unspecified_number,
                   p_nsf_override_ind      farinva.farinva_nsf_override_ind%TYPE DEFAULT Dml_Common.f_unspecified_string,
                   p_ityp_seq_code         farinva.farinva_ityp_seq_code%TYPE DEFAULT Dml_Common.f_unspecified_number,
                   p_proj_code             farinva.farinva_proj_code%TYPE DEFAULT Dml_Common.f_unspecified_string,
                   p_susp_ind              farinva.farinva_susp_ind%TYPE DEFAULT DML_COMMON.F_unspecified_string,
                   p_nsf_susp_ind          farinva.farinva_nsf_susp_ind%TYPE DEFAULT dml_common.f_unspecified_string, --ADDED BY WEI
                   p_partial_liq_ind       farinva.farinva_partial_liq_ind%TYPE DEFAULT Dml_Common.f_unspecified_string,
                   p_appr_ind              farinva.farinva_appr_ind%TYPE DEFAULT Dml_Common.f_unspecified_string,
                   p_open_paid_ind         farinva.farinva_open_paid_ind%TYPE DEFAULT Dml_Common.f_unspecified_string,
                   p_convert_amt           farinva.farinva_convert_amt%TYPE DEFAULT Dml_Common.f_unspecified_number,
                   p_convert_disc_amt      farinva.farinva_convert_disc_amt%TYPE DEFAULT Dml_Common.f_unspecified_number,
                   p_convert_tax_amt       farinva.farinva_convert_tax_amt%TYPE DEFAULT Dml_Common.f_unspecified_number,
                   p_convert_addl_chrg_amt farinva.farinva_convert_addl_chrg_amt%TYPE DEFAULT Dml_Common.f_unspecified_number,
                   p_appr_amt_pct          farinva.farinva_appr_amt_pct%TYPE DEFAULT Dml_Common.f_unspecified_number,
                   p_disc_amt_pct          farinva.farinva_disc_amt_pct%TYPE DEFAULT Dml_Common.f_unspecified_number,
                   p_addl_amt_pct          farinva.farinva_addl_amt_pct%TYPE DEFAULT Dml_Common.f_unspecified_number,
                   p_tax_amt_pct           farinva.farinva_tax_amt_pct%TYPE DEFAULT Dml_Common.f_unspecified_number,
                   p_cap_amt               farinva.farinva_cap_amt%TYPE DEFAULT Dml_Common.f_unspecified_number,
                   p_data_origin           farinva.farinva_data_origin%TYPE DEFAULT Dml_Common.f_unspecified_string,
                   p_rowid                 Gb_Common.internal_record_id_type DEFAULT NULL)

Updates a record.

Parameters

	p_invh_code	The unique identifier of an Invoice document. 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_item	The reference number which associates an invoice accounting record to the related invoice commodity item. If 0, then invoice accounting record applies to all invoice commodity items (Document Level Accounting). If not 0, then invoice accounting record applies to the invoice commodity item of that number (Commodity Level Accounting). NUMBER(4) Required Key
	p_po_item	The item number of the Purchase Order that is referenced by this invoice item. NUMBER(4)
	p_seq_num	The system-generated unique number associated with the Item Number of the accounting record. NUMBER(4) Required Key
	p_user_id	The unique identification code of the user who last updated the Invoice document. VARCHAR2(30) Required
	p_eoy_accr_status_ind	Derived status of the accrual period for the entered fiscal year. If Y then accrual posting will be allowed. This value is populated by the payment process for use in payment posting. VARCHAR2(1)
	p_rucl_code	The rule class associated with the Approved amount. The value passed in is considered only if the BATCH_MODE context is set. VARCHAR2(4)
	p_disc_rucl_code	The rule class associated with the Discount amount. The value passed in is considered only if the BATCH_MODE context is set. VARCHAR2(4)
	p_tax_rucl_code	The rule class associated with the Tax amount. The value passed in is considered only if the BATCH_MODE context is set. VARCHAR2(4)
	p_addl_rucl_code	The rule class associated with the Additional amount. The value passed in is considered only if the BATCH_MODE context is set. VARCHAR2(4)
	p_coas_code	The Chart of Accounts code (as defined in table FTVCOAS) referenced by the invoice transactions. VARCHAR2(1)
	p_acci_code	The Index Code (as defined in table FTVACCI) that may be entered to default various accounting elements. VARCHAR2(6)
	p_fund_code	The Fund Code (as defined in table FTVFUND) referenced by the invoice transactions. VARCHAR2(6)
	p_orgn_code	The Organization Code (as defined in table FTVORGN) referenced by the invoice transactions. VARCHAR2(6)
	p_acct_code	The Account Code (as defined in table FTVACCT) referenced by the invoice transactions. May default from the Commodity Code. VARCHAR2(6)
	p_prog_code	The Program Code (as defined in table FTVPROG) referenced by the invoice transactions. VARCHAR2(6)
	p_actv_code	The Activity Code (as defined in table FTVACTV) referenced by the invoice transactions. VARCHAR2(6)
	p_locn_code	The Location Code (as defined in table FTVLOCN) referenced by the invoice transactions. VARCHAR2(6)
	p_bank_code	The Bank Code (as defined from table GXVBANK) to be used for processing the payment of the Invoice. This value may default from the Fund Code. VARCHAR2(2)
	p_invd_amt	This field is reserved for FURAPAY and PCARD processing. NUMBER(17,2)
	p_disc_amt	The discount amount to be distributed to this invoice accounting record. NUMBER(17,2)
	p_tax_amt	The tax amount to be distributed to this invoice accounting record. NUMBER(17,2)
	p_addl_chrg_amt	The additional amount to be distributed to this invoice accounting record. NUMBER(17,2)
	p_appr_amt	The approved amount to be distributed to this invoice accounting record. NUMBER(17,2)
	p_prev_paid_amt	The amount is populated with FARINVA_APPR_AMT during payment. NUMBER(17,2)
	p_nsf_override_ind	This indicator permits authorized users on the form FOMPROF to bypass a non-sufficient funds condition. VARCHAR2(1)
	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_proj_code	The Project Code (as defined in table FTVPROJ) affected by the invoice transactions. This code is used for Cost Accounting purposes. VARCHAR2(8)
	p_nsf_susp_ind	NON-SUFFICIENT FUNDS SUSPENSE INDICATOR: Indicates that an item is being held in suspense due to a non-sufficient funds condition. VARCHAR2(1) Required
	p_partial_liq_ind	Indicates if related PO item was final liquidated and closed. If T, then final liquidation was processed. VARCHAR2(1)
	p_appr_ind	Indicates if the document has been approved. If Y, the invoice accounting record has received final approval. VARCHAR2(1)
	p_open_paid_ind	Indicates that the item is Open or Paid. Valid values are O for open or P for paid. During payment the indicator will be updated to P. VARCHAR2(1)
	p_appr_amt_pct	The percentage of the approved amount for the commodity item/document to be distributed to this invoice accounting record. This amount is also derived if no percentage is entered. NUMBER(21,16)
	p_disc_amt_pct	The percentage of the discount amount for the commodity item/document to be distributed to this invoice accounting record. This amount is also derived if no percentage is entered. NUMBER(21,16)
	p_addl_amt_pct	The percentage of the additional amount for the commodity item/document to be distributed to this invoice accounting record. This amount is also derived if no percentage is entered. NUMBER(21,16)
	p_tax_amt_pct	The percentage of the tax amount for the commodity item/document to be distributed to this invoice accounting record. This amount is also derived if no percentage is entered. NUMBER(21,16)
	p_cap_amt	The calculated amount for use in the capitalization process for this item. NUMBER(17,2)
	p_data_origin	Source system that generated the data. VARCHAR2(30)
	p_rowid	Database ROWID of the record to be updated. VARCHAR2(18)

p_update_internal

Procedure p_update_internal( -- wei
                            p_invh_code           farinva.farinva_invh_code%TYPE DEFAULT NULL,
                            p_item                farinva.farinva_item%TYPE DEFAULT NULL,
                            p_seq_num             farinva.farinva_seq_num%TYPE DEFAULT NULL,
                            p_appr_ind            farinva.farinva_appr_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                            p_open_paid_ind       farinva.farinva_open_paid_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                            p_susp_ind            farinva.farinva_susp_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                            p_nsf_susp_ind        farinva.farinva_nsf_susp_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                            p_eoy_accr_status_ind farinva.farinva_eoy_accr_status_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                            p_prev_paid_amt       farinva.farinva_prev_paid_amt%TYPE DEFAULT dml_common.f_unspecified_number,
                            P_fsyr_code           farinva.farinva_fsyr_code%TYPE DEFAULT dml_common.f_unspecified_string,
                            P_period              farinva.farinva_period%TYPE DEFAULT dml_common.f_unspecified_string,
                            P_bank_code           farinva.farinva_bank_code%TYPE DEFAULT dml_common.f_unspecified_string,
                            p_check_num           fabinck.fabinck_check_num%TYPE DEFAULT dml_common.f_unspecified_string,
                            p_submission_date     fabinvh.fabinvh_trans_date%TYPE DEFAULT dml_common.f_unspecified_date,
                            p_check_date          fabinvh.fabinvh_trans_date%TYPE DEFAULT dml_common.f_unspecified_date,
                            p_activity_date       farinva.farinva_activity_date%TYPE DEFAULT dml_common.f_unspecified_date,
                            p_user_id             farinva.farinva_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_data_origin         farinva.farinva_data_origin%TYPE DEFAULT dml_common.f_unspecified_string)

Updates records using direct dml.

Parameters

	p_invh_code	The unique identifier of an Invoice document. VARCHAR2(8) Required Key
	p_item	The reference number which associates an invoice accounting record to the related invoice commodity item. If 0, then invoice accounting record applies to all invoice commodity items (Document Level Accounting). If not 0, then invoice accounting record applies to the invoice commodity item of that number (Commodity Level Accounting). NUMBER(4)
	p_seq_num	The system-generated unique number associated with the Item Number of the accounting record. NUMBER(4)
	p_appr_ind	Indicates if the document has been approved. If Y, the invoice accounting record has received final approval. VARCHAR2(1)
	p_open_paid_ind	Indicates that the item is Open or Paid. Valid values are O for open or P for paid. During payment the indicator will be updated to P. VARCHAR2(1)
	p_susp_ind	Indicates to the user that an item is being held in suspense due to missing or erroneous data content. VARCHAR2(1)
	p_nsf_susp_ind	Indicates that an item is being held in suspense due to a non-sufficient funds condition. VARCHAR2(1)
	p_eoy_accr_status_ind	Derived status of the accrual period for the entered fiscal year. If Y then accrual posting will be allowed. This value is populated by the payment process for use in payment posting. VARCHAR2(1)
	p_prev_paid_amt	The amount is populated with FARINVA_APPR_AMT during payment. NUMBER(17,2)
	p_fsyr_code	The fiscal year code (as defined in table FTVFSYR) that is derived from the transaction date on the invoice. The invoice transactions will post to the ledgers in this fiscal year. VARCHAR2(2)
	p_period	The fiscal period (as defined in table FTVFSPD) that is derived from the transaction date on the invoice. The invoice transactions will post to the ledgers in this fiscal period of the fiscal year. VARCHAR2(2)
	p_bank_code	The Bank Code (as defined from table GXVBANK) to be used for processing the payment of the Invoice. This value may default from the Fund Code. VARCHAR2(2)
	p_check_num	The check number of the check throught which invoice is being paid.
	p_submission_date	The submission date on the re-usable invoice. DATE
	p_check_date	The check date of the check that paid the invoice. DATE
	p_activity_date	The date when the information for this record on the table was entered or last updated. DATE
	p_user_id	The unique identification code of the user who last updated the Invoice document. VARCHAR2(30)
	p_data_origin	Source system that generated the data. VARCHAR2(30)

p_delete_internal

Procedure p_delete_internal(p_invh_code farinva.farinva_invh_code%TYPE,
                            p_item      farinva.farinva_item%TYPE DEFAULT NULL)

Delete records using direct dml.

Parameters

	p_invh_code	The unique identifier of an Invoice document. VARCHAR2(8) Required Key
	p_item	The reference number which associates an invoice accounting record to the related invoice commodity item.

p_do_inv_nsf

Procedure p_do_inv_nsf( -- wei
                       p_invh_code          farinva.farinva_invh_code%TYPE,
                       p_submission_number  fabinvh.fabinvh_submission_number%TYPE,
                       p_abal_ind_inout     IN OUT VARCHAR2,
                       p_abal_message_inout IN OUT VARCHAR2,
                       p_user_id            farinva.farinva_user_id%TYPE DEFAULT gb_common.f_sct_user,
                       p_data_origin        farinva.farinva_data_origin%TYPE DEFAULT dml_common.f_unspecified_string)

Updates farinva and check available balance.

Parameters

	p_invh_code_inout	The unique identifier of an Invoice document. VARCHAR2(8) Required Key
	p_submission_number	The internal submission number for the Invoice record. Used for tracking recurring and re-established Invoice documents. NUMBER(3)
	p_abal_ind_inout	This indicator is used to override the availablity of funds checking process, if the user has the authority. VARCHAR2(1)
	p_abal_message_inout	The message returned from function fgkabal.abal_p_check_available_balance. VARCHAR2
	p_user_id	The unique identification code of the user who last updated the Invoice document. VARCHAR2(30)
	p_data_origin	Source system that generated the data. VARCHAR2(30)