1 PACKAGE ARP_BALANCE_CHECK AS
2 /* $Header: ARBALCHS.pls 120.1 2006/06/27 04:00:48 rkader noship $ */
3
4 out_of_balance EXCEPTION;
5 amount_mismatch EXCEPTION;
6
7 /* =======================================================================
8 | PROCEDURE Check_Transaction_Balance
9 |
10 | DESCRIPTION
11 | This procedure takes sum of debits and credits for transactions
12 | and tallies that debits equal credits, if not then it sets a
13 | message on the message stack indicating that items are out of
14 | balance.
15 |
16 | PARAMETERS
17 | p_customer_trx_id IN Cash receipt id
18 | p_called_from_api IN Y-api call out
19 * ======================================================================*/
20 PROCEDURE CHECK_TRANSACTION_BALANCE(p_customer_trx_id IN VARCHAR2,
21 p_called_from_api IN VARCHAR2 default 'N');
22
23 /* =======================================================================
24 | PROCEDURE Check_Recp_Balance
25 |
26 | DESCRIPTION
27 | This procedure takes sum of debits and credits for receipts and
28 | adjustments including discounts and tallies that debits equal
29 | credits, if not then it sets a message on the message stack
30 | indicating that items are out of balance.
31 |
32 | PARAMETERS
33 | p_cr_id IN Cash receipt id
34 | p_request_id IN Request id
35 | p_called_from_api IN Y-api call out
36 * ======================================================================*/
37 PROCEDURE CHECK_RECP_BALANCE(
38 p_cr_id IN NUMBER,
39 p_request_id IN NUMBER,
40 p_called_from_api IN VARCHAR2 default 'N');
41
42 /* =======================================================================
43 | PROCEDURE Check_Adj_Balance
44 |
45 | DESCRIPTION
46 | This procedure takes sum of debits and credits for adjustments
47 | tallies that debits equal credits, if not then it sets a message
48 | on the message stack indicating that items are out of balance.
49 |
50 | PARAMETERS
51 | p_adj_id IN Adjustment id
52 | p_request_id IN Request id
53 | p_called_from_api IN Y-api call out
54 * ======================================================================*/
55 PROCEDURE CHECK_ADJ_BALANCE(
56 p_adj_id IN NUMBER,
57 p_request_id IN NUMBER,
58 p_called_from_api IN VARCHAR2 default 'N');
59
60 /* =======================================================================
61 | PROCEDURE Check_Appln_Balance
62 |
63 | DESCRIPTION
64 | This procedure takes sum of debits and credits for CM Applications
65 | tallies that debits equal credits, if not then it sets a message
66 | on the message stack indicating that items are out of balance.
67 |
68 | PARAMETERS
69 | p_receivable_application_id IN Receivable Application ID
70 | p_request_id IN Request id
71 | p_called_from_api IN Y-api call out
72 * ======================================================================*/
73 PROCEDURE CHECK_APPLN_BALANCE(
74 p_receivable_application_id IN NUMBER,
75 p_request_id IN NUMBER,
76 p_called_from_api IN VARCHAR2 default 'N');
77
78 /* =======================================================================
79 | PROCEDURE Check_Appln_Balance
80 |
81 | DESCRIPTION
82 | This procedure takes sum of debits and credits for Receipt Applications
83 | tallies that debits equal credits, if not then it sets a message
84 | on the message stack indicating that items are out of balance.
85 |
86 | PARAMETERS
87 | p_receivable_application_id1 IN Receivable Application ID
88 | p_receivable_application_id2 IN Receivable Application ID of the pair
89 | p_request_id IN Request id
90 | p_called_from_api IN Y-api call out
91 * ======================================================================*/
92 PROCEDURE CHECK_APPLN_BALANCE(
93 p_receivable_application_id1 IN NUMBER,
94 p_receivable_application_id2 IN NUMBER,
95 p_request_id IN NUMBER,
96 p_called_from_api IN VARCHAR2 default 'N');
97 END ARP_BALANCE_CHECK;
98