1 PACKAGE AR_ARXINREV_XMLP_PKG AS
2 /* $Header: ARXINREVS.pls 120.0 2007/12/27 13:53:26 abraghun noship $ */
3 P_CONC_REQUEST_ID number;
4 P_CHART_OF_ACCOUNTS_ID number;
5 P_SQL_TRACE varchar2(32767);
6 P_TEST_LAYOUT varchar2(30);
7 P_DEBUG_MODE varchar2(32767);
8 P_CURRENCY varchar2(15);
9 P_PRECISION number;
10 P_MIN_ACCOUNTABLE_UNIT number;
11 P_NAME varchar2(30);
12 P_SET_OF_BOOKS_ID number;
13 P_FLEXDATA varchar2(2100);
14 P_REVALUATION_PERIOD varchar2(50);
15 P_END_DATE date;
16 /*ADDED AS FIX*/LP_END_DATE DATE; LP_UP_TO_DUE_DATE DATE;
17 P_UP_TO_DUE_DATE date;
18 P_DUE_DATE_DISP date;
19 --lp_bal_segment_low varchar2(200);
20 lp_bal_segment_low varchar2(200):=' ';
21 --lp_bal_segment_high varchar2(200);
22 lp_bal_segment_high varchar2(200):=' ';
23 P_BAL_SEGMENT_LOW varchar2(100);
24 P_BAL_SEGMENT_HIGH varchar2(100);
25 P_DEBUG_SWITCH varchar2(1);
26 --LP_POSTED varchar2(100);
27 LP_POSTED varchar2(100):=' ';
28 --LP_CLEARED varchar2(100);
29 LP_CLEARED varchar2(100):=' ';
30 P_STATED_REPORTING_DATE date;
31 P_RATE_DATE1 varchar2(10);
32 P_REVALUATION_DATE date;
33 --lp_dates varchar2(100);
34 lp_dates varchar2(200):=' ';
35 P_POSTED varchar2(1);
36 P_CLEARED varchar2(1);
37 P_RATE_TYPE varchar2(30);
38 --lp_posted_receipts varchar2(100);
39 lp_posted_receipts varchar2(100):=' ';
40 --LP_POSTED_RECEIPT varchar2(40);
41 LP_POSTED_RECEIPT varchar2(40):=' ';
42 --LP_CLEARED_NEW varchar2(1000);
43 LP_CLEARED_NEW varchar2(1000):=' ';
44 P_DAILY_RATE_TYPE varchar2(30);
45 P_RATE_DATE date;
46 P_RATE_TYPE_LOOKUP varchar2(30);
47 CP_TOT_TMP number := 0 ;
48 CP_TMP number;
49 RP_DATA_FOUND varchar2(300);
50 RP_SUB_TITLE varchar2(80);
51 REVALUATION_DATE number;
52 CP_TEMP number;
53 CP_1 varchar2(40);
54 C_DAILY_RATE_LOOKUP_ERROR varchar2(20) := 'N' ;
55 CP_ACC_MESSAGE varchar2(2000);
56 function BeforeReport return boolean ;
57 function AfterReport return boolean ;
58 function aol_round( n in number, precision in number, mac in number) return number ;
59 function c_eop_rateformula(C_CURR in varchar2, C_TYPE in varchar2, C_EXCHANGE_RATE in number) return number ;
60 function c_open_funcformula(C_OPEN_ORIG in number, C_EXCHANGE_RATE in number) return number ;
61 function c_open_revformula(C_EOP_RATE in number, C_EXCHANGE_RATE in number, C_OPEN_ORIG in number, C_OPEN_FUNC in number) return number ;
62 function c_diffformula(C_OPEN_REV in number, C_OPEN_FUNC in number) return number ;
63 function c_receiptsformula(C_PAY_ID in number) return number ;
64 function c_open_origformula(C_PAY_AMOUNT in number, C_RECEIPTS in number, C_ADJUST in number, C_CM in number, C_CM1 in number) return number ;
65 function calc_open_funcformula(C_OPEN_FUNC in number) return number ;
66 function calc_open_revformula(C_OPEN_REV in number) return number ;
67 function calc_eop_amountformula(C_EOP_AMOUNT in number) return number ;
68 function c_adjustformula(C_PAY_ID in number) return number ;
69 function c_eop_amountformula(C_EOP_RATE in number, C_OPEN_ORIG in number) return number ;
70 function c_eop_diffformula(C_SUM_EOP_AMOUNT in number, C_SUM_OPEN_FUNC in number) return number ;
71 function c_rev_diffformula(C_SUM_OPEN_REV in number, C_SUM_OPEN_FUNC in number) return number ;
72 function c_sum_eop_diffformula(C_SUM_EOP_AMOUNT in number, C_SUM_OPEN_FUNC in number) return number ;
73 function c_sum_rev_diffformula(C_SUM_OPEN_REV in number, C_SUM_OPEN_FUNC in number) return number ;
74 function c_flagformula(C_EOP_RATE in number, C_OPEN_ORIG in number) return number ;
75 function c_cmformula(C_PAY_ID in number) return number ;
76 function c_tot_eop_diffformula(C_TOT_EOP_AMOUNT in number, C_TOT_OPEN_FUNC in number) return number ;
77 function c_tot_rev_diffformula(C_TOT_OPEN_REV in number, C_TOT_OPEN_FUNC in number) return number ;
78 function cf_eop_reval_amountformula(Cf_EOP_EXCH_RATE in number, C_TYPE in varchar2, c_exchange_rate in number, C_REVALUATE_YES_NO in varchar2, C_OPEN_ORIG in number, c_previous_cust_trx_id in number) return number ;
79 function cf_total_adjustmentsformula(C_PAY_ID in number, C_OPEN_ORIG in number) return number ;
80 function AfterPForm return boolean ;
81 function cf_curr_to_func_exch_rateformu(C_EXCHANGE_RATE in number) return number ;
82 function cf_eop_exch_rateformula(c_revaluate_yes_no in varchar2, c_exchange_rate in number, c_curr in varchar2) return number ;
83 FUNCTION total (a number, b number) RETURN number ;
84 function CF_todayFormula return char ;
85 function CF_Revaluation_dateFormula return char ;
86 function CF_due_date_dispFormula return Char ;
87 function c_2(cs_2 in number) return boolean ;
88 --procedure set_last_cust ;
89 procedure set_last_cust(c_balancing IN VARCHAR2 , cs_2 IN NUMBER);
90 function c_cm1formula(C_PAY_ID in number) return number ;
91 function CF_RATE_TYPE_LOOKUPFormula return Char ;
92 function CF_USER_DAILY_RATE_TYPEFormula return Char ;
93 function CF_TRANS_TO_GLFormula return Char ;
94 function CF_CLEARED_ONLYFormula return Char ;
95 function P_NAMEValidTrigger return boolean ;
96 Function CP_TOT_TMP_p return number;
97 Function CP_TMP_p return number;
98 Function RP_DATA_FOUND_p return varchar2;
99 Function RP_SUB_TITLE_p return varchar2;
100 Function REVALUATION_DATE_p return number;
101 Function CP_TEMP_p return number;
102 Function CP_1_p return varchar2;
103 Function C_DAILY_RATE_LOOKUP_ERROR_p return varchar2;
104 Function CP_ACC_MESSAGE_p return varchar2;
105 END AR_ARXINREV_XMLP_PKG;
106
107