Accounts Receiveable API {f42pkg.html}


Title  
Procedures / functions to perform Account Receivable system validations

Summary
The package consists of a number of functions used to validate, create or update staff loans. The package is use by the Accounts Receivable API (f45pkg.sql) to perform validations and update or insert staff loans where applicable.
 
Parameters
Function Parameters In / Out Type Remark
chkLoanCode
Check if loan code exists for the debtor category and account type.   		 x_dttr IN Number Debtor
x_loanc IN Number Loan Code
x_dcatcode IN Alpha AR Category  = L
x_acctyp IN Alpha Account Type
x_loandesc OUT Alpha Loan Description
getReducePrncp
Get the reducing principle for the debtors loan code. 		 x_dttr  IN Number Debtor
x_loanc IN Number Loan Code
x_reducePrncp OUT Number Reducing Loan Principal
updLoanPrncp
Decrease/Increase loan principle.  		 x_dttr IN Number Debtor Number
x_loanc IN Number Loan Code
x_dtcr IN Number C- decrease loan D - increase loan
x_updamt IN Number Amount to increase or decrease the loan principle
insLoan
Insert staff loan  		 x_dttr IN Number Debtor Number
x_loanc IN Number Loan Code
x_loanamt IN Number Loan Principal

valDebtor

Validate debtor

 x_dttr
IN
 Number
 Debtor Number
x_fradeb
 IN / OUT
ROWTYPE
 Error message
getPrimAddType
Debtor primary address type
 x_unum
 IN Number Person Number
x_numtype
 IN Alpha Person Type
x_addrftc
 IN Alpha Address Reference Type Code
x_tac
 IN Alpha Address/Contact/ Telephone
x_syscrt
 IN Alpha System Create
x_csn
 IN Number Contact Sequence Number
x_addrtype
 OUT Alpha Address Type
getNextDocNumber
Get next document type		 x_dtcr
 IN
 Alpha The sign of the docuement (D)ebit or (C)redit



chkRefdate
Validate reference date
 x_dttr
 IN
 Number Debtor Number
x_type
 IN
 Alpha Document Type
x_refd
 IN
 Date
 Date to validate
chkDupDocument
Check for duplicate documents
 x_dttr
 IN
 Number Debtor Number
x_type
 IN
 Alpha Document Type
x_inv
 IN
 Alpha Document Number


History of Changes

Date System Version By Whom Job Description
07-Feb-2013
 v03.0.0.0 Marchand Hildebrand
 T188555
 Create manual