1 package PSA_MFAR_VAL_PKG AUTHID CURRENT_USER as
2 /* $Header: PSAMFVLS.pls 120.5 2006/09/13 14:07:49 agovil ship $ */
3
4 PROCEDURE AR_MFAR_VALIDATE_TRX_HEADER (
5 X_TRANSACTION_TYPE_ID Number ,
6 X_TRANSACTION_CLASS varchar2 ,
7 X_TRX_COMMITMENT_NUMBER varchar2 ,
8 X_TRANSACTION_RULES_FLAG varchar2 ,
9 X_INVOICE_RULE_ID Number ,
10 X_RECEIPT_METHOD_ID Number,
11 X_SET_OF_BOOKS_ID Number ,
12 X_BASE_CURRENCY_CODE varchar2
13 );
14
15 /* The following procedure will check if a Credit Memo is of Multi Fund
16 transaction type or not
17 */
18
19 PROCEDURE AR_MFAR_CM_VAL_CHECK (
20 X_TRX_ID in number ,
21 X_SET_OF_BOOKS_ID in number,
22 X_BASE_CURRENCY_CODE in varchar2 );
23
24 /* The following procedure will be called from either Transactions , Receipts
25 or Adjustments Distributions Form . Depending upon the Source Type this
26 procedure will validate the Transaction Type
27 */
28 FUNCTION AR_MFAR_VALIDATE_CHECK(
29 X_SOURCE_ID in Number,
30 X_SOURCE_TYPE in varchar2,
31 X_SET_OF_BOOKS_ID in Number )
32 RETURN varchar2;
33
34 FUNCTION AR_MFAR_RECEIPT_CHECK(
35 X_RECEIPT_ID in Number,
36 X_RECEIPT_METHOD_ID in varchar2,
37 X_TRANSACTION_ID in number)
38 RETURN varchar2;
39 /*
40 FUNCTION AR_MFAR_RECEIPT_REVERSAL_CHECK(
41 X_RECEIPT_ID in Number
42 )
43 RETURN varchar2;
44 */
45
46 PROCEDURE AR_MFAR_QUICKCASH(X_RECEIPT_METHOD_ID in NUMBER);
47
48 FUNCTION AR_LOCKBOX_VALIDATION
49 RETURN VARCHAR2 ;
50
51 /* The following procedure will check if a transaction is of Multi Fund
52 transaction type or not
53 */
54 /*
55 PROCEDURE TRANSACTION_VALIDATION_CHECK (
56 X_TRANSACTION_ID in ra_customer_trx.customer_trx_id%type ,
57 X_ACCOUNTING_METHOD in varchar2,
58 X_RETURN_SATUS out NOCOPY varchar2);
59 */
60 /* The following procedure will check if a Receipt Header is of Multi Fund
61 transaction type or not
62 */
63 /*
64 PROCEDURE RECEIPT_HEADER_VALIDATION_CHECK (
65 X_TRANSACTION_ID in ra_customer_trx.customer_trx_id%type ,
66 X_ACCOUNTING_METHOD in varchar2,
67 X_RETURN_SATUS out NOCOPY varchar2);
68 */
69 /* The following procedure will check if the Receipt is applied to Multi Fund
70 transaction type or not
71 */
72 /*
73 PROCEDURE RECEIPT_VALIDATION_CHECK (
74 X_CASH_RECEIPT_ID in ,
75 X_TRANSACTION_TYPE_ID in ra_customer_trx.customer_trx_id%type ,
76 X_ACCOUNTING_METHOD in varchar2,
77 X_RETURN_SATUS out NOCOPY varchar2);
78 */
79 /* The following procedure will check if the adjustment is applied to a
80 Multi Fund Transaction type or not
81 */
82 /*
83 PROCEDURE ADJUSTMENT_VALIDATION_CHECK (
84 X_ADJUSTMENT_ID in varchar2,
85 X_TRANSACTION_ID in ra_customer_trx.customer_trx_id%type ,
86 X_ACCOUNTING_METHOD in varchar2,
87 X_RETURN_SATUS out NOCOPY varchar2);
88 */
89 PROCEDURE ar_mfar_autoinv_trx_header(l_request_id in NUMBER);
90
91
92
93 /*===============================================================
94 Function to validate a Miscellaneous Receipt.
95 A Miscellaneous Receipt is of Type Multi-fund if
96 --> The Receivable Activity is flagged as Multi-Fund type from Setup form
97
98 For a Multi-Fund type Misc Receipt, the Payment Method should
99 not require Confirmation / Remittance. If these validations are
100 not met, ERROR is raised during WHEN-VALIDATE-RECORD of Misc. receipts header.
101 ==================================================================*/
102
103 FUNCTION MISC_RCT_VAL
104 ( p_cash_receipt_id IN NUMBER,
105 p_receipt_method_id IN NUMBER,
106 p_receivables_trx_id IN NUMBER
107 ) return varchar2;
108
109
110
111
112 end PSA_MFAR_VAL_PKG;