Package BANINST1.fb_invoice

Package BANINST1.fb_invoice_item

Common Business interface for the INVOICE ITEM API (fb_invoice_item).

Program units

f_api_version	Returns the API version number.
f_exists	Checks to see if a record exists.
f_exists_data	Checks to see if a record exists and returns the record.
f_isequal	Compares two records for equality.
f_max_item	Returns the maximum item number for an invoice.
f_max_vend_inv_item	Returns the maximum vendor invoice item number for an invoice/vendor invoice code.
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_query_one_string	Returns record as a string separated by a delimiter.
f_convert_rectype_to_rowtype	Converts an invoice_item_rec to farinvc rowtype.
p_create_item	Creates a record.
p_create	Creates a record.
p_delete	Deletes a record.
p_lock	Locks a record.
p_maintain_farvinv	Maintains the VIC cross reference record in FARVINV table.
p_update_item	Updates a record.
p_update	Updates a record.
p_get_total_amts	Returns various total amounts of all items for a document level invoice or returns various amounts of an item for commodity level invoice.
p_update_internal	Updates multiple item records to be used only by the Banner system.
p_delete_internal	Delete farinvc records using direct dml.

Types

invoice_item_rec	Business Entity record type
invoice_item_ref	Entity cursor variable type
invoice_item_tab	Entity table type

Constants

M_ENTITY_NAME	Business Entity Name
M_BASE_TABLE_NAME	Base table name

Cursors

farinvc_pk_c
farinvc_rowid_c

farinvc_pk_c

CURSOR farinvc_pk_c(
  p_invh_code                 farinvc.farinvc_invh_code%TYPE,
  p_item                      farinvc.farinvc_item%TYPE)
RETURN farinvc%ROWTYPE IS
  SELECT *
    FROM farinvc
   WHERE farinvc_invh_code = p_invh_code
     AND farinvc_item = p_item;

farinvc_rowid_c

CURSOR farinvc_rowid_c(
  p_rowid    gb_common.internal_record_id_type)
RETURN farinvc%ROWTYPE IS
  SELECT *
    FROM farinvc
    WHERE ROWID = p_rowid;

M_ENTITY_NAME

M_ENTITY_NAME    CONSTANT VARCHAR2(12) := 'INVOICE_ITEM';

Business Entity Name

M_BASE_TABLE_NAME

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

Base table name

invoice_item_rec

TYPE invoice_item_rec IS RECORD (
  r_invh_code               farinvc.farinvc_invh_code%TYPE,
  r_pohd_code               farinvc.farinvc_pohd_code%TYPE,
  r_item                    farinvc.farinvc_item%TYPE,
  r_po_item                 farinvc.farinvc_po_item%TYPE,
  r_open_paid_ind           farinvc.farinvc_open_paid_ind%TYPE,
  r_user_id                 farinvc.farinvc_user_id%TYPE,
  r_comm_code               farinvc.farinvc_comm_code%TYPE,
  r_comm_desc               farinvc.farinvc_comm_desc%TYPE,
  r_uoms_code               farinvc.farinvc_uoms_code%TYPE,
  r_adjt_code               farinvc.farinvc_adjt_code%TYPE,
  r_adjt_date               farinvc.farinvc_adjt_date%TYPE,
  r_part_pmt_ind            farinvc.farinvc_part_pmt_ind%TYPE,
  r_prev_paid_qty           farinvc.farinvc_prev_paid_qty%TYPE,
  r_recvd_qty               farinvc.farinvc_recvd_qty%TYPE,
  r_invd_unit_price         farinvc.farinvc_invd_unit_price%TYPE,
  r_invd_qty                farinvc.farinvc_invd_qty%TYPE,
  r_accept_qty              farinvc.farinvc_accept_qty%TYPE,
  r_accept_unit_price       farinvc.farinvc_accept_unit_price%TYPE,
  r_disc_amt                farinvc.farinvc_disc_amt%TYPE,
  r_tax_amt                 farinvc.farinvc_tax_amt%TYPE,
  r_appr_qty                farinvc.farinvc_appr_qty%TYPE,
  r_appr_unit_price         farinvc.farinvc_appr_unit_price%TYPE,
  r_tol_override_ind        farinvc.farinvc_tol_override_ind%TYPE,
  r_hold_ind                farinvc.farinvc_hold_ind%TYPE,
  r_susp_ind                farinvc.farinvc_susp_ind%TYPE,
  r_ttag_num                farinvc.farinvc_ttag_num%TYPE,
  r_addl_chrg_amt           farinvc.farinvc_addl_chrg_amt%TYPE,
  r_convert_unit_price      farinvc.farinvc_convert_unit_price%TYPE,
  r_convert_disc_amt        farinvc.farinvc_convert_disc_amt%TYPE,
  r_convert_tax_amt         farinvc.farinvc_convert_tax_amt%TYPE,
  r_convert_addl_chrg_amt   farinvc.farinvc_convert_addl_chrg_amt%TYPE,
  r_tgrp_code               farinvc.farinvc_tgrp_code%TYPE,
  r_tag_cap_code            farinvc.farinvc_tag_cap_code%TYPE,
  r_vend_inv_code           farinvc.farinvc_vend_inv_code%TYPE,
  r_vend_inv_date           farinvc.farinvc_vend_inv_date%TYPE,
  r_vend_inv_item           farinvc.farinvc_vend_inv_item%TYPE,
  r_prev_amt                farinvc.farinvc_prev_amt%TYPE,
  r_desc_chge_ind           farinvc.farinvc_desc_chge_ind%TYPE,
  r_last_rcvr_ind           farinvc.farinvc_last_rcvr_ind%TYPE,
  r_override_tax_amt        farinvc.farinvc_override_tax_amt%TYPE,
  r_data_origin             farinvc.farinvc_data_origin%TYPE,
  r_create_user             farinvc.farinvc_create_user%TYPE,
  r_create_date             farinvc.farinvc_create_date%TYPE,
  r_internal_record_id      gb_common.internal_record_id_type);

Business Entity record type

invoice_item_ref

TYPE invoice_item_ref IS REF CURSOR RETURN invoice_item_rec;

Entity cursor variable type

invoice_item_tab

TYPE invoice_item_tab IS TABLE OF invoice_item_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 farinvc.farinvc_invh_code%TYPE,
                  p_item      farinvc.farinvc_item%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 unique sequence number directly associated with an invoice commodity record. NUMBER(4)
	p_rowid	Database ROWID of the record to be selected. VARCHAR2(18)

Returns

Y if found, otherwise N.

f_exists_data

Function f_exists_data(p_invh_code farinvc.farinvc_invh_code%TYPE,
                       p_item      farinvc.farinvc_item%TYPE,
                       p_rowid     gb_common.internal_record_id_type DEFAULT NULL,
                       p_rec_out   OUT farinvc%ROWTYPE) RETURN VARCHAR2

Checks to see if a record exists and returns the record.

Parameters

	p_invh_code	The unique identifier of an Invoice document. VARCHAR2(8) Required Key
	p_item	The unique sequence number directly associated with an invoice commodity record. NUMBER(4)
	p_rowid	Database ROWID of the record to be selected. VARCHAR2(18)
	p_rec_out	Returns invoice item table row.

Returns

Y if found, otherwise N.

f_isequal

Function f_isequal(rec_one invoice_item_rec, rec_two invoice_item_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_item_rec Required
	rec_two	The second record to compare. Type invoice_item_rec Required

Returns

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

f_max_item

Function f_max_item(p_invh_code fabinvh.fabinvh_code%TYPE)
  RETURN farinvc.farinvc_item%TYPE

Returns the maximum item number for an invoice.

Parameters

p_invh_code

The unique identifier of an Invoice document. VARCHAR2(8) Required Key

Returns

The maximum item number.

f_max_vend_inv_item

Function f_max_vend_inv_item(p_invh_code     fabinvh.fabinvh_code%TYPE,
                             p_vend_inv_code farinvc.farinvc_vend_inv_code%TYPE)
  RETURN farinvc.farinvc_vend_inv_item%TYPE

Returns the maximum vendor invoice item number for an invoice/vendor invoice code.

Parameters

	p_invh_code	The unique identifier of an Invoice document. VARCHAR2(8) Required Key
	p_vend_inv_code	The Invoice number as supplied by the vendor for this invoice item. VARCHAR2(15)

Returns

The maximum vendor invoice item number.

f_query_all

Function f_query_all(p_invh_code farinvc.farinvc_invh_code%TYPE)
  RETURN invoice_item_ref

Selects all records for the entity.

Parameters

p_invh_code

The unique identifier of an Invoice document. VARCHAR2(8) Required Key

Returns

A cursor variable that will fetch the set of records.

f_query_one

Function f_query_one(p_invh_code farinvc.farinvc_invh_code%TYPE,
                     p_item      farinvc.farinvc_item%TYPE)
  RETURN invoice_item_ref

Selects one record using key.

Parameters

	p_invh_code	The unique identifier of an Invoice document. VARCHAR2(8) Required Key
	p_item	The unique sequence number directly associated with an invoice commodity 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_item_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 farinvc.farinvc_invh_code%TYPE,
                          p_item      farinvc.farinvc_item%TYPE,
                          p_rowid     gb_common.internal_record_id_type DEFAULT NULL)
  RETURN invoice_item_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 unique sequence number directly associated with an invoice commodity 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_query_one_string

Function f_query_one_string(p_invh_code       farinvc.farinvc_invh_code%TYPE DEFAULT NULL,
                            p_rowid           gb_common.internal_record_id_type DEFAULT NULL,
                            p_separation_char varchar2 DEFAULT ',')
  RETURN VARCHAR2

Returns record as a string separated by a delimiter.
Used in testing the API.

Parameters

	p_invh_code	The unique identifier of an Invoice document. VARCHAR2(8) Required Key
	p_rowid	Database ROWID of the record to be selected. VARCHAR2(18)
	p_separation_char	The data separator used to separate the columns. VARCHAR2(1)

f_convert_rectype_to_rowtype

Function f_convert_rectype_to_rowtype(p_item_rec IN invoice_item_rec)
  RETURN FARINVC%ROWTYPE

Converts an invoice_item_rec to farinvc rowtype.

Parameters

p_item_rec

The Invoice Item record to be converted. Type invoice_item_rec Required

p_create_item

Procedure p_create_item(invoice_item_data IN OUT invoice_item_rec)

Creates a record.

Parameters

p_invoice_item_data

The Invoice Item row to be created. Type invoice_item_rec Required

p_create

Procedure p_create(p_invh_code         farinvc.farinvc_invh_code%TYPE,
                   p_pohd_code         farinvc.farinvc_pohd_code%TYPE DEFAULT NULL,
                   p_item              farinvc.farinvc_item%TYPE DEFAULT NULL,
                   p_po_item           farinvc.farinvc_po_item%TYPE DEFAULT NULL,
                   p_user_id           farinvc.farinvc_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_comm_code         farinvc.farinvc_comm_code%TYPE DEFAULT NULL,
                   p_comm_desc         farinvc.farinvc_comm_desc%TYPE DEFAULT NULL,
                   p_uoms_code         farinvc.farinvc_uoms_code%TYPE DEFAULT NULL,
                   p_adjt_code         farinvc.farinvc_adjt_code%TYPE DEFAULT NULL,
                   p_adjt_date         farinvc.farinvc_adjt_date%TYPE DEFAULT NULL,
                   p_part_pmt_ind      farinvc.farinvc_part_pmt_ind%TYPE DEFAULT NULL,
                   p_invd_unit_price   farinvc.farinvc_invd_unit_price%TYPE DEFAULT NULL,
                   p_invd_qty          farinvc.farinvc_invd_qty%TYPE DEFAULT NULL,
                   p_accept_qty        farinvc.farinvc_accept_qty%TYPE DEFAULT NULL,
                   p_accept_unit_price farinvc.farinvc_accept_unit_price%TYPE DEFAULT NULL,
                   p_disc_amt          farinvc.farinvc_disc_amt%TYPE DEFAULT NULL,
                   p_tax_amt           farinvc.farinvc_tax_amt%TYPE DEFAULT NULL, --1-2W2OJ5
                   p_appr_qty          farinvc.farinvc_appr_qty%TYPE DEFAULT NULL,
                   p_appr_unit_price   farinvc.farinvc_appr_unit_price%TYPE DEFAULT NULL,
                   p_tol_override_ind  farinvc.farinvc_tol_override_ind%TYPE DEFAULT NULL,
                   p_hold_ind          farinvc.farinvc_hold_ind%TYPE DEFAULT NULL,
                   p_ttag_num          farinvc.farinvc_ttag_num%TYPE DEFAULT NULL,
                   p_addl_chrg_amt     farinvc.farinvc_addl_chrg_amt%TYPE DEFAULT NULL,
                   p_tgrp_code         farinvc.farinvc_tgrp_code%TYPE DEFAULT NULL,
                   p_vend_inv_code     farinvc.farinvc_vend_inv_code%TYPE DEFAULT NULL,
                   p_vend_inv_date     farinvc.farinvc_vend_inv_date%TYPE DEFAULT NULL,
                   p_vend_inv_item     farinvc.farinvc_vend_inv_item%TYPE DEFAULT NULL,
                   p_data_origin       farinvc.farinvc_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 unique sequence number directly associated with an invoice commodity record. NUMBER(4) Required Key
	p_po_item	The item number of the Purchase Order that is referenced by this invoice item. Only populated for Regular or General Encumbrance Invoice types. NUMBER(4)
	p_user_id	The unique identification code of the user who last updated the Invoice document. VARCHAR2(30) Required
	p_comm_code	The user-defined commodity code associated with this invoice item. VARCHAR2(10)
	p_comm_desc	The user-defined commodity description for this invoice item. VARCHAR2(50)
	p_uoms_code	The unit-of-measure code (as defined in table FTVUOMS) applicable to the invoice item. VARCHAR2(4)
	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_part_pmt_ind	Indicates if related PO item will be final liquidated and closed. If F, then item will be closed. VARCHAR2(1)
	p_invd_unit_price	The unit price of this invoice item referenced from the invoice sent by the vendor. Only populated for Regular or General Encumbrance Invoice types. NUMBER(19,4)
	p_invd_qty	The quantity of this invoice item referenced from the invoice sent by the vendor. Only populated for Regular or General Encumbrance Invoice types. NUMBER(8,2)
	p_accept_qty	This calculated number is the received quantity minus the rejected quantity. This number is displayed if the Regular Purchase Order commodity was received in the receiving process via FPARCVD form. If no receiving has been entered then the user may manually populate the field. For invoice documents against Standing Order Purchase Order the default value is 1. NUMBER(8,2)
	p_accept_unit_price	This value will default from the Purchase Order unit price for Regular Purchase Orders. For Standing Purchase Orders the value will default to 0 but may be overridden by the user. NUMBER(19,4)
	p_disc_amt	The amount representing the discount. This value may default from the discount code. If a discount code is not entered or defaulted from the vendor, the discount amount may be manually entered. NUMBER(17,2)
	p_tax_amt	The amount representing the tax. NUMBER(17,2)
	p_appr_qty	The quantity that is approved for payment on this invoice item. NUMBER(8,2)
	p_appr_unit_price	The unit price that is approved for payment on this invoice item. NUMBER(19,4)
	p_tol_override_ind	Indicates that the total approved amount of the invoice item can exceed the tolerance percent or amount set for the user on the form FOMPROF. If Y, then tolerance checking is overridden. User must have permission to invoke override on the form FOMPROF. VARCHAR2(1)
	p_hold_ind	Indicates that the Invoice item has been placed on hold to prevent payment to a vendor. Indicator is set via FAAINVE or FAAPAYC forms. If Y, the document will be withheld from the payment process. VARCHAR2(1) Default N
	p_ttag_num	This column is not currently used by the Banner Finance application. VARCHAR2(9)
	p_addl_chrg_amt	The amount of additional charges for this invoice item. NUMBER(17,2)
	p_tgrp_code	The tax group code (as defined in table FTVTGRP) referenced in the invoice item and used in the calculation of taxes. VARCHAR2(4)
	p_vend_inv_code	The Invoice number as supplied by the vendor for this invoice item. VARCHAR2(15)
	p_vend_inv_date	The date of the invoice sent by the vendor. DATE
	p_vend_inv_item	The item number of the invoice item within a specific vendor invoice. NUMBER(4)
	p_data_origin	Source system that last created or updated the data. VARCHAR2(30)
	p_rowid_out	Database ROWID of the record to be created. VARCHAR2(18) Required

p_delete

Procedure p_delete(p_invh_code farinvc.farinvc_invh_code%TYPE,
                   p_item      farinvc.farinvc_item%TYPE,
                   p_user_id   farinvc.farinvc_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 unique sequence number directly associated with an invoice commodity record. NUMBER(4) Required Key
	p_user_id	The unique identification code of the user who has the authority to delete the Invoice document. VARCHAR2(30) Required
	p_rowid	Database ROWID of the record to be deleted. VARCHAR2(18)

p_lock

Procedure p_lock(p_invh_code   farinvc.farinvc_invh_code%TYPE,
                 p_item        farinvc.farinvc_item%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 unique sequence number directly associated with an invoice commodity record. NUMBER(4) Required Key
	p_rowid_inout	Database ROWID of the record to be locked. VARCHAR2(18) Required

p_maintain_farvinv

Procedure p_maintain_farvinv(p_invh_code fabinvh.fabinvh_code%TYPE,
                             p_user_id   fabinvh.fabinvh_user_id%TYPE DEFAULT gb_common.f_sct_user)

Maintains the VIC cross reference record in FARVINV table.

Parameters

	p_invh_code	The unique identifier of an Invoice document. VARCHAR2(8) Required Key
	p_user_id	The unique identification code of the user who has the authority to delete the Invoice document. VARCHAR2(30) Required

p_update_item

Procedure p_update_item(invoice_item_data IN OUT invoice_item_rec)

Updates a record.

Parameters

p_invoice_item_data

The Invoice Item row to be updated. Type invoice_item_rec Required

p_update

Procedure p_update(p_invh_code             farinvc.farinvc_invh_code%TYPE,
                   p_item                  farinvc.farinvc_item%TYPE,
                   p_open_paid_ind         farinvc.farinvc_open_paid_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_user_id               farinvc.farinvc_user_id%TYPE DEFAULT gb_common.f_sct_user,
                   p_comm_code             farinvc.farinvc_comm_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_comm_desc             farinvc.farinvc_comm_desc%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_uoms_code             farinvc.farinvc_uoms_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_adjt_code             farinvc.farinvc_adjt_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_adjt_date             farinvc.farinvc_adjt_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_part_pmt_ind          farinvc.farinvc_part_pmt_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_prev_paid_qty         farinvc.farinvc_prev_paid_qty%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_invd_unit_price       farinvc.farinvc_invd_unit_price%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_invd_qty              farinvc.farinvc_invd_qty%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_accept_qty            farinvc.farinvc_accept_qty%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_accept_unit_price     farinvc.farinvc_accept_unit_price%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_disc_amt              farinvc.farinvc_disc_amt%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_tax_amt               farinvc.farinvc_tax_amt%TYPE DEFAULT dml_common.f_unspecified_number, --1-2W2OJ5
                   p_appr_qty              farinvc.farinvc_appr_qty%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_appr_unit_price       farinvc.farinvc_appr_unit_price%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_tol_override_ind      farinvc.farinvc_tol_override_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_hold_ind              farinvc.farinvc_hold_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_susp_ind              farinvc.farinvc_susp_ind%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_ttag_num              farinvc.farinvc_ttag_num%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_addl_chrg_amt         farinvc.farinvc_addl_chrg_amt%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_convert_unit_price    farinvc.farinvc_convert_unit_price%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_convert_disc_amt      farinvc.farinvc_convert_disc_amt%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_convert_tax_amt       farinvc.farinvc_convert_tax_amt%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_convert_addl_chrg_amt farinvc.farinvc_convert_addl_chrg_amt%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_tgrp_code             farinvc.farinvc_tgrp_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_tag_cap_code          farinvc.farinvc_tag_cap_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_vend_inv_code         farinvc.farinvc_vend_inv_code%TYPE DEFAULT dml_common.f_unspecified_string,
                   p_vend_inv_date         farinvc.farinvc_vend_inv_date%TYPE DEFAULT dml_common.f_unspecified_date,
                   p_vend_inv_item         farinvc.farinvc_vend_inv_item%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_override_tax_amt      farinvc.farinvc_override_tax_amt%TYPE DEFAULT dml_common.f_unspecified_number,
                   p_data_origin           farinvc.farinvc_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_item	The unique sequence number directly associated with an invoice commodity record. NUMBER(4) Required Key
	p_open_paid_ind	Indicates whether a PO item number is open (O) or paid (P). VARCHAR2(1)
	p_user_id	The unique identification code of the user who last updated the Invoice document. VARCHAR2(30) Required
	p_comm_code	The user-defined commodity code associated with this invoice item. VARCHAR2(10)
	p_comm_desc	The user-defined commodity description for this invoice item. VARCHAR2(50)
	p_uoms_code	The unit-of-measure code (as defined in table FTVUOMS) applicable to the invoice item. VARCHAR2(4)
	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_part_pmt_ind	Indicates if related PO item will be final liquidated and closed. If F, then item will be closed. VARCHAR2(1)
	p_prev_paid_qty	Cumulative total of previously invoiced quantities for related PO item. NUMBER(8,2)
	p_recvd_qty	Cumulative total of previously received quantities for related PO item. This field is used only by the EDI process. NUMBER(8,2)
	p_invd_unit_price	The unit price of this invoice item referenced from the invoice sent by the vendor. NUMBER(19,4)
	p_invd_qty	The quantity of this invoice item referenced from the invoice sent by the vendor. NUMBER(8,2)
	p_accept_qty	This calculated number is the received quantity minus the rejected quantity. This number is displayed if the Regular Purchase Order commodity was received in the receiving process via FPARCVD form. If no receiving has been entered then the user may manually populate the field.? For invoice documents against Standing Order Purchase Order the default value is 1. NUMBER(8,2)
	p_accept_unit_price	This value will default from the Purchase Order unit price for Regular Purchase Orders. For Standing Purchase Orders the value will default to 0 but may be overridden by the user. NUMBER(19,4)
	p_disc_amt	The amount representing the discount. This value may default from the discount code. If a discount code is not entered or defaulted from the vendor, the discount amount may be manually entered. NUMBER(17,2)
	p_tax_amt	The amount representing the tax. NUMBER(17,2)
	p_appr_qty	The quantity that is approved for payment on this invoice item. NUMBER(8,2)
	p_appr_unit_price	The unit price that is approved for payment on this invoice item. NUMBER(19,4)
	p_tol_override_ind	Indicates that the total approved amount of the invoice item can exceed the tolerance percent or amount set for the user on the form FOMPROF. If Y, then tolerance checking is overridden. User must have permission to invoke override on the form FOMPROF. VARCHAR2(1)
	p_hold_ind	Indicates that the Invoice item has been placed on hold to prevent payment to a vendor. Indicator is set via FAAINVE or FAAPAYC forms. If Y, the document will be withheld from the payment process. VARCHAR2(1)
	p_susp_ind	Indicates to the user that a document is being held in suspense due to missing or erroneous data content. VARCHAR2(1)
	p_ttag_num	This column is not currently used by the Banner Finance application. VARCHAR2(9)
	p_addl_chrg_amt	The amount of additional charges for this invoice item. NUMBER(17,2)
	p_convert_unit_price	The unit price of the item is calculated against the exchange rate of the currency code to derive this amount in base currency. NUMBER(19,4)
	p_convert_disc_amt	The discount amount of the item is calculated against the exchange rate of the currency code to derive this amount in base currency. NUMBER(17,2)
	p_convert_tax_amt	The tax amount of the item is calculated against the exchange rate of the currency code to derive this amount in base currency. NUMBER(17,2)
	p_convert_addl_amt	The additional amount of the item is calculated against the exchange rate of the currency code to derive this amount in base currency. NUMBER(17,2)
	p_tgrp_code	The tax group code (as defined in table FTVTGRP) referenced in the invoice item and used in the calculation of taxes. VARCHAR2(4)
	p_tag_cap_code	System derived code which indicates if invoice item should be tagged and/or capitalized. Valid values are T if the item is to be tagged, C if the item is to be capitalized, and N if the item should not be tagged or capitalized. VARCHAR2(1)
	p_vend_inv_code	The Invoice number as supplied by the vendor for this invoice item. VARCHAR2(15)
	p_vend_inv_date	The date of the invoice sent by the vendor. DATE
	p_vend_inv_item	The item number of the invoice item within a specific vendor invoice. NUMBER(4)
	p_override_tax_amt	The amount by which tax is overriden for each commodity. NUMBER(17,2)
	p_data_origin	Source system that last created or updated the data. VARCHAR2(30)
	p_rowid	Database ROWID of the record to be updated. VARCHAR2(18)

p_get_total_amts

Procedure p_get_total_amts(p_invh_code              fabinvh.fabinvh_code%TYPE,
                           p_single_acct_ind        fabinvh.fabinvh_single_acctg_ind%TYPE,
                           p_item                   farinvc.farinvc_item%TYPE DEFAULT NULL,
                           p_total_appr_amt         OUT farinvc.farinvc_disc_amt%TYPE,
                           p_total_convert_appr_amt OUT farinvc.farinvc_convert_disc_amt%TYPE,
                           p_total_disc_amt         OUT farinvc.farinvc_disc_amt%TYPE,
                           p_total_convert_disc_amt OUT farinvc.farinvc_convert_disc_amt%TYPE,
                           p_total_addl_amt         OUT farinvc.farinvc_addl_chrg_amt%TYPE,
                           p_total_convert_addl_amt OUT farinvc.farinvc_convert_addl_chrg_amt%TYPE,
                           p_total_tax_amt          OUT farinvc.farinvc_tax_amt%TYPE,
                           p_total_convert_tax_amt  OUT farinvc.farinvc_convert_tax_amt%TYPE)

Returns various total amounts of all items for a document level invoice or returns various amounts of an item for commodity level invoice.

Parameters

	p_invh_code	The unique identifier of an Invoice document. VARCHAR2(8) Required Key
	p_single_acct_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_item	The unique sequence number directly associated with an invoice commodity record. NUMBER(4) Required for Commodity level.
	p_total_appr_amt	Returns the total approved amount of the document or item depending on accounting level. NUMBER(17,2)
	p_total_convert_appr_amt	Returns the total converted amount of the document or item depending on accounting level. NUMBER(17,2)
	p_total_disc_amt	Returns the total discount amount of the document or item depending on accounting level. NUMBER(17,2)
	p_total_convert_disc_amt	Returns the total converted discount amount of the document or item depending on accounting level. NUMBER(17,2)
	p_total_addl_amt	Returns the total additional charges amount of the document or item depending on accounting level. NUMBER(17,2)
	p_total_convert_addl_amt	Returns the total converted additional charges amount of the document or item depending on accounting level. NUMBER(17,2)
	p_total_tax_amt	Returns the total tax amount of the document or item depending on accounting level. NUMBER(17,2)
	p_total_convert_tax_amt	Returns the total converted tax amount of the document or item depending on accounting level. NUMBER(17,2)

p_update_internal

Procedure p_update_internal(p_invh_code         farinvc.farinvc_invh_code%TYPE DEFAULT NULL,
                            p_item              farinvc.farinvc_item%TYPE DEFAULT NULL,
                            p_pohd_code         farinvc.farinvc_pohd_code%TYPE DEFAULT NULL,
                            p_po_item           farinvc.farinvc_po_item%TYPE DEFAULT NULL,
                            p_open_paid_ind     farinvc.farinvc_open_paid_ind%TYPE DEFAULT NULL,
                            p_prev_paid_qty     farinvc.farinvc_prev_paid_qty%TYPE DEFAULT NULL,
                            p_accept_qty        farinvc.farinvc_accept_qty%TYPE DEFAULT NULL,
                            p_accept_unit_price farinvc.farinvc_accept_unit_price%TYPE DEFAULT NULL,
                            p_check_num         fabchks.fabchks_check_num%TYPE DEFAULT NULL,
                            p_bank_code         fabchks.fabchks_bank_code%TYPE DEFAULT NULL,
                            p_user_id           farinvc.farinvc_user_id%TYPE DEFAULT gb_common.f_sct_user,
                            p_data_origin       farinvc.farinvc_data_origin%TYPE DEFAULT NULL)

Updates multiple item records to be used only by the Banner system.

Parameters

	p_invh_code	The unique identifier of an Invoice document. VARCHAR2(8) Required Key
	p_item	The unique sequence number directly associated with an invoice commodity record. NUMBER(4)
	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_po_item	The item number of the Purchase Order that is referenced by this invoice item. Only populated for Regular or General Encumbrance Invoice types. NUMBER(4)
	p_open_paid_ind	Indicates whether a PO item number is open (O) or paid (P). VARCHAR2(1)
	p_prev_paid_qty	Cumulative total of previously invoiced quantities for related PO item. NUMBER(8,2)
	p_accept_qty	This calculated number is the received quantity minus the rejected quantity. This number is displayed if the Regular Purchase Order commodity was received in the receiving process via FPARCVD form. If no receiving has been entered then the user may manually populate the field.? For invoice documents against Standing Order Purchase Order the default value is 1. NUMBER(8,2)
	p_accept_unit_price	This value will default from the Purchase Order unit price for Regular Purchase Orders. For Standing Purchase Orders the value will default to 0 but may be overridden by the user. NUMBER(19,4)
	p_check_num	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 unique identification code of the user who last updated the Invoice document. VARCHAR2(30) Required
	p_data_origin	Source system that last created or updated the data. VARCHAR2(30)

p_delete_internal

Procedure p_delete_internal(p_invh_code  farinvc.farinvc_invh_code%TYPE,
                            p_delete_all VARCHAR2 DEFAULT 'N')

Delete farinvc records using direct dml.

Parameters

	p_invh_code	The unique identifier of an Invoice document. VARCHAR2(8) Required Key
	p_delete_all	If Y all rows of a particular invoice will be deleted. VARCHAR2(1)