index

Package BANINST1.fb_vendor_rules

Support subprograms for vendor API (FB_VENDOR_RULES).

Program units
p_register_entity   Register the attribute/value pairs to the message cache This signature uses the PK only, for the delete operations
p_register_entity   Register the attribute/value pairs to the message cache This signature registers the all parameters
p_validate   Validates all the data in the record

p_register_entity 

Procedure p_register_entity(p_operation_type NUMBER,
                            p_pidm           ftvvend.ftvvend_pidm%TYPE)

Register the attribute/value pairs to the message cache This signature uses the PK only, for the delete operations

Parameters
p_operation_type   The type of DML operation: create,update,delete.
p_pidm   Personal identification number for the vendor record.  This number exists on SATURN.SPRIDEN.

p_register_entity 

Procedure p_register_entity(p_operation_type        NUMBER,
                            p_pidm                  ftvvend.ftvvend_pidm%TYPE,
                            p_eff_date              ftvvend.ftvvend_eff_date%TYPE,
                            p_term_date             ftvvend.ftvvend_term_date%TYPE,
                            p_user_id               ftvvend.ftvvend_user_id%TYPE,
                            p_ityp_seq_code         ftvvend.ftvvend_ityp_seq_code%TYPE,
                            p_disc_code             ftvvend.ftvvend_disc_code%TYPE,
                            p_1099_rpt_id           ftvvend.ftvvend_1099_rpt_id%TYPE,
                            p_trat_code             ftvvend.ftvvend_trat_code%TYPE,
                            p_in_st_ind             ftvvend.ftvvend_in_st_ind%TYPE,
                            p_grouping_ind          ftvvend.ftvvend_grouping_ind%TYPE,
                            p_carrier_ind           ftvvend.ftvvend_carrier_ind%TYPE,
                            p_contact               ftvvend.ftvvend_contact%TYPE,
                            p_ctry_code_phone       ftvvend.ftvvend_ctry_code_phone%TYPE,
                            p_phone_area            ftvvend.ftvvend_phone_area%TYPE,
                            p_phone_number          ftvvend.ftvvend_phone_number%TYPE,
                            p_phone_ext             ftvvend.ftvvend_phone_ext%TYPE,
                            p_atyp_code             ftvvend.ftvvend_atyp_code%TYPE,
                            p_addr_seqno            ftvvend.ftvvend_addr_seqno%TYPE,
                            p_fed_whold_pct         ftvvend.ftvvend_fed_whold_pct%TYPE,
                            p_st_whold_pct          ftvvend.ftvvend_st_whold_pct%TYPE,
                            p_combined_fed_st_filer ftvvend.ftvvend_combined_fed_st_filer%TYPE,
                            p_collect_tax           ftvvend.ftvvend_collect_tax%TYPE,
                            p_vend_check_pidm       ftvvend.ftvvend_vend_check_pidm%TYPE,
                            p_vend_check_atyp_code  ftvvend.ftvvend_vend_check_atyp_code%TYPE,
                            p_vend_check_addr_seqno ftvvend.ftvvend_vend_check_addr_seqno%TYPE,
                            p_curr_code             ftvvend.ftvvend_curr_code%TYPE,
                            p_entity_ind            ftvvend.ftvvend_entity_ind%TYPE,
                            p_pidm_owner            ftvvend.ftvvend_pidm_owner%TYPE,
                            p_eproc_ind             ftvvend.ftvvend_eproc_ind%TYPE,
                            p_data_origin           ftvvend.ftvvend_data_origin%TYPE,
                            p_po_hold_rsn_code      ftvvend.ftvvend_po_hold_rsn_code%TYPE DEFAULT NULL,
                            p_pmt_hold_rsn_code     ftvvend.ftvvend_pmt_hold_rsn_code%TYPE DEFAULT NULL,
                            p_1099_atyp_code        ftvvend.ftvvend_1099_atyp_code%TYPE DEFAULT NULL,
                            p_1099_addr_seqno       ftvvend.ftvvend_1099_addr_seqno%TYPE DEFAULT NULL,
                            P_tax_form_status       ftvvend.ftvvend_tax_form_status%TYPE DEFAULT NULL, /*Added for RPE1-1BTRG0R*/
                            p_tax_form_date         ftvvend.ftvvend_tax_form_date%TYPE DEFAULT NULL)

Register the attribute/value pairs to the message cache This signature registers the all parameters

Parameters
p_pidm   Personal identification number for the vendor record.  This number exists on SATURN.SPRIDEN.
p_eff_date   EFFECTIVE DATE: The effective date for this particular record.
p_term_date   TERMINATION DATE: The date when this particular record is no longer in effect.
p_user_id   USER IDENTIFICATION: The unique identification code of the user.
p_ityp_seq_code   Income type sequence number.
p_disc_code   DISCOUNT CODE: The value of the discount code established on form FTVDISC.
p_1099_rpt_id   1099 REPORT IDENTIFCATION: The vendor's taxpayer identification number (TIN).
p_trat_code   TAX RATE CODE: A user-defined value that corresponds to a specific tax rate.
p_in_st_ind   In state indicator with valid value as I or O.
p_grouping_ind   Group indicator.
p_carrier_ind   CARRIER INDICATOR: This indicator is used to designate vendors who are also carriers.
p_contact   AGENCY CONTACT: The name or title of the primary contact at the agency.
p_ctry_code_phone   TELEPHONE COUNTRY CODE: Code designating the region or country.
p_phone_area   ADDRESS PHONE AREA CODE: The telephone area code for this particular record.
p_phone_number   Phone number for the vendor.
p_phone_ext   ADDRESS PHONE EXTENSION: The telephone extension number for this particular record.
p_atyp_code   ADDRESS TYPE CODE.
p_addr_seqno   ADDRESS TYPE SEQUENCE NUMBER.
p_fed_whold_pct   FEDERAL WITHHOLDING PERCENTAGE.
p_st_whold_pct   STATE WITHHOLDING PERCENTAGE.
p_combined_fed_st_filer   COMBINED FEDERAL AND STATE FILER.
p_collect_tax   Collect tax indicator with valid value as N for no taxes, S for selected taxes or A for all taxes.
p_vend_check_pidm   CHECK VENDOR PERSONAL IDENTIFICATION NUMBER.
p_vend_check_atyp_code   CHECK VENDOR CHECK ADDRESS TYPE CODE.
p_vend_check_addr_seqno   CHECK VENDOR CHECK ADDRESS SEQUENCE NUMBER.
p_curr_code   CURRENCY CODE: Used as a default currency code for vendor.
p_entity_ind   ENTITY_IND: Set by form FTMVEND to distinguish between corporation and person vendors.
p_pidm_owner   DOING BUSINESS AS PIDM OWNER.
p_eproc_ind   EPROCUREMENT INDICATOR.
p_po_hold_rsn_code   ORDER HOLD REASON CODE.
p_pmt_hold_rsn_code   PAYMENT HOLD REASON CODE.
p_1099_atyp_code   1099 ADDRESS TYPE:  The user-defined code that describes the type of address, i.e.  Purchase Order, Remit To, Mailing, etc.  Must exist on SATURN.STVATYP.
p_1099_addr_seqno   ADDRESS SEQUENCE NUMBER: The user-defined sequence number associated with the address.
p_tax_form_status   TAX FORM STATUS:  The user-defined code that describes current status for collection of tax forms from a vendor.  Must exist on FTMSDAT.
p_tax_form_date   TAX FORM DATE:  The user-defined date that can maintain a date corresponding to the Tax Form Status field.

p_validate 

Procedure p_validate(p_pidm                  ftvvend.ftvvend_pidm%TYPE,
                     p_eff_date              ftvvend.ftvvend_eff_date%TYPE,
                     p_term_date             ftvvend.ftvvend_term_date%TYPE DEFAULT NULL,
                     p_user_id               ftvvend.ftvvend_user_id%TYPE,
                     p_ityp_seq_code         ftvvend.ftvvend_ityp_seq_code%TYPE DEFAULT NULL,
                     p_disc_code             ftvvend.ftvvend_disc_code%TYPE DEFAULT NULL,
                     p_1099_rpt_id           ftvvend.ftvvend_1099_rpt_id%TYPE DEFAULT NULL,
                     p_trat_code             ftvvend.ftvvend_trat_code%TYPE DEFAULT NULL,
                     p_in_st_ind             ftvvend.ftvvend_in_st_ind%TYPE DEFAULT NULL,
                     p_grouping_ind          ftvvend.ftvvend_grouping_ind%TYPE DEFAULT NULL,
                     p_carrier_ind           ftvvend.ftvvend_carrier_ind%TYPE DEFAULT NULL,
                     p_contact               ftvvend.ftvvend_contact%TYPE DEFAULT NULL,
                     p_ctry_code_phone       ftvvend.ftvvend_ctry_code_phone%TYPE DEFAULT NULL,
                     p_phone_area            ftvvend.ftvvend_phone_area%TYPE DEFAULT NULL,
                     p_phone_number          ftvvend.ftvvend_phone_number%TYPE DEFAULT NULL,
                     p_phone_ext             ftvvend.ftvvend_phone_ext%TYPE DEFAULT NULL,
                     p_atyp_code             ftvvend.ftvvend_atyp_code%TYPE DEFAULT NULL,
                     p_addr_seqno            ftvvend.ftvvend_addr_seqno%TYPE DEFAULT NULL,
                     p_fed_whold_pct         ftvvend.ftvvend_fed_whold_pct%TYPE DEFAULT NULL,
                     p_st_whold_pct          ftvvend.ftvvend_st_whold_pct%TYPE DEFAULT NULL,
                     p_combined_fed_st_filer ftvvend.ftvvend_combined_fed_st_filer%TYPE DEFAULT NULL,
                     p_collect_tax           ftvvend.ftvvend_collect_tax%TYPE,
                     p_vend_check_pidm       ftvvend.ftvvend_vend_check_pidm%TYPE DEFAULT NULL,
                     p_vend_check_atyp_code  ftvvend.ftvvend_vend_check_atyp_code%TYPE DEFAULT NULL,
                     p_vend_check_addr_seqno ftvvend.ftvvend_vend_check_addr_seqno%TYPE DEFAULT NULL,
                     p_curr_code             ftvvend.ftvvend_curr_code%TYPE DEFAULT NULL,
                     p_entity_ind            ftvvend.ftvvend_entity_ind%TYPE DEFAULT NULL,
                     p_pidm_owner            ftvvend.ftvvend_pidm_owner%TYPE DEFAULT NULL,
                     p_eproc_ind             ftvvend.ftvvend_eproc_ind%TYPE,
                     p_data_origin           ftvvend.ftvvend_data_origin%TYPE,
                     p_po_hold_rsn_code      ftvvend.ftvvend_po_hold_rsn_code%TYPE DEFAULT NULL,
                     p_pmt_hold_rsn_code     ftvvend.ftvvend_pmt_hold_rsn_code%TYPE DEFAULT NULL,
                     p_1099_atyp_code        ftvvend.ftvvend_1099_atyp_code%TYPE DEFAULT NULL,
                     p_1099_addr_seqno       ftvvend.ftvvend_1099_addr_seqno%TYPE DEFAULT NULL,
                     p_tax_form_status       ftvvend.ftvvend_tax_form_status%TYPE DEFAULT NULL, /*Added for RPE1-1BTRG0R*/
                     p_tax_form_date         ftvvend.ftvvend_tax_form_date%TYPE DEFAULT NULL)

Validates all the data in the record

Parameters
p_pidm   Personal identification number for the vendor record.  This number exists on SATURN.SPRIDEN.
p_eff_date   EFFECTIVE DATE: The effective date for this particular record.
p_term_date   TERMINATION DATE: The date when this particular record is no longer in effect.
p_user_id   USER IDENTIFICATION: The unique identification code of the user.
p_ityp_seq_code   INTERNAL SEQUENCE CODES.
p_disc_code   DISCOUNT CODE: The value of the discount code established on form FTVDISC.
p_1099_rpt_id   1099 REPORT IDENTIFCATION: The vendor's taxpayer identification number (TIN).
p_trat_code   TAX RATE CODE: A user-defined value that corresponds to a specific tax rate.
p_in_st_ind   IN-STATE INDICATOR: Valid value is 'I' for in-state or 'O' for out of state.
p_grouping_ind   GROUPING INDICATOR.
p_carrier_ind   CARRIER INDICATOR: This indicator is used to designate vendors who are also carriers.
p_contact   AGENCY CONTACT: The name or title of the primary contact at the agency.
p_ctry_code_phone   TELEPHONE COUNTRY CODE: Code designating the region or country.
p_phone_area   ADDRESS PHONE AREA CODE: The telephone area code for this particular record.
p_phone_number   Phone number for the vendor.
p_phone_ext   ADDRESS PHONE EXTENSION: The telephone extension number for this particular record.
p_atyp_code   ADDRESS TYPE CODE.
p_addr_seqno   ADDRESS SEQUENCE NUMBER: The user-defined sequence number associated with the address.
p_fed_whold_pct   FEDERAL WITHHOLDING PERCENTAGE.
p_st_whold_pct   STATE WITHHOLDING PERCENTAGE.
p_combined_fed_st_filer   COMBINED FEDERAL AND STATE FILER.
p_collect_tax   Values are: 'N' for no taxes, 'S' for selected taxes and 'A' for all taxes.
p_vend_check_pidm   CHECK VENDOR PIDM: Personal identification number of check vendor.
p_vend_check_atyp_code   CHECK VENDOR CHECK ADDRESS TYPE CODE.
p_vend_check_addr_seqno   CHECK VENDOR CHECK ADDRESS SEQUENCE NUMBER.
p_curr_code   CURRENCY CODE: Used as a default currency code for vendor.
p_entity_ind   ENTITY_IND: Set by form FTMVEND to distinguish between corporation and person vendors.
p_pidm_owner   DOING BUSINESS AS PIDM OWNER.
p_eproc_ind   EPROCUREMENT INDICATOR.
p_po_hold_rsn_code   ORDER HOLD REASON CODE.
p_pmt_hold_rsn_code   PAYMENT HOLD REASON CODE.
p_1099_atyp_code   1099 ADDRESS TYPE:  The user-defined code that describes the type of address, i.e.  Purchase Order, Remit To, Mailing, etc.  Must exist on SATURN.STVATYP.
p_1099_addr_seqno   ADDRESS SEQUENCE NUMBER: The user-defined sequence number associated with the address.
p_tax_form_status   TAX FORM STATUS:  The user-defined code that describes current status for collection of tax forms from a vendor.  Must exist on FTMSDAT.
p_tax_form_date   TAX FORM DATE:  The user-defined date that can maintain a date corresponding to the Tax Form Status field.