1 PACKAGE PA_INVOICE_TIEBACK AUTHID CURRENT_USER as
2 /* $Header: PAXVINTS.pls 115.4 2002/11/23 12:26:34 prajaram ship $ */
3
4 TYPE num_arr is table of NUMBER index by BINARY_INTEGER;
5 TYPE var_arr_01 is table of VARCHAR2(1) index by BINARY_INTEGER;
6 TYPE var_arr_25 is table of VARCHAR2(25) index by BINARY_INTEGER;
7 --
8 -- This procedure will find if any conversion rate from project currency to
9 -- invoice currency changes or not. If changes, then insert invoice
10 -- distribution warnings .This function will be called from Invoice tieback
11 -- process from receivables.
12 --
13 -- Parameter :
14 -- P_Project_Id - Project Id
15 -- P_Draft_Inv_Num - Draft Invoice Number
16 -- P_project_num - Project Number
17 -- P_cust_trx_id - Customer Transaction Id
18 -- P_user_id - User id
19 -- P_request_id - Request Id
20 -- P_out_error - Warning Code
21 --
22
23 PROCEDURE Validate_inv_acct_amt
24 ( P_project_id IN num_arr,
25 P_draft_inv_num IN num_arr,
26 P_project_num IN var_arr_25,
27 P_cust_trx_id IN num_arr,
28 P_user_id IN NUMBER,
29 P_request_id IN NUMBER,
30 P_num_of_rec IN NUMBER,
31 P_out_error OUT NOCOPY var_arr_01 );
32
33
34 END PA_INVOICE_TIEBACK;