1 PACKAGE JE_ZZ_AUDIT_AP_PKG AUTHID CURRENT_USER
2 -- $Header: jezzauditaps.pls 120.2 2006/06/16 11:04:43 spasupun ship $
3 AS
4 P_VAT_REPORTING_ENTITY_ID NUMBER;
5 P_CHART_OF_ACC_ID NUMBER;
6 P_LEGAL_ENTITY_ID NUMBER;
7 P_LEDGER_ID NUMBER;
8 G_LE_ID NUMBER;
9 P_COMPANY VARCHAR2(35);
10 P_REP_DATE DATE;
11 P_CALLING_REPORT VARCHAR2(40);
12 P_REPORT_BY VARCHAR2(1);
13 P_PERIOD VARCHAR2(20);
14 G_ledger_name VARCHAR2(30);
15 G_LEDGER_CURR VARCHAR2(15);
16 G_STRUCT_NUM VARCHAR2(15) := '0';
17 G_CURR_NAME VARCHAR2(40);
18 G_INDUSTRY_CODE VARCHAR2(20);
19 G_company_title VARCHAR2(20);
20 G_precision NUMBER;
21 G_disc_isinvlesstax_flag VARCHAR2(1) := 'N';
22 G_tax_discount_amt NUMBER;
23 G_DATA_FOUND VARCHAR2(40);
24
25
26 FUNCTION BeforeReport RETURN BOOLEAN;
27
28 FUNCTION g_companygroupfilter(company IN VARCHAR2) RETURN BOOLEAN;
29
30 PROCEDURE get_lookup_meaning
31 (
32 p_lookup_type IN VARCHAR2
33 ,p_lookup_code IN VARCHAR2
34 ,x_lookup_meaning IN OUT NOCOPY VARCHAR2
35 );
36
37 PROCEDURE get_boiler_plates;
38
39 FUNCTION c_payment_amtformula
40 (
41 p_tax_type IN VARCHAR2
42 ,p_inv_type IN VARCHAR2
43 ,p_invoice_id IN NUMBER
44 ,p_pay_amt IN NUMBER
45 ,p_start_date IN DATE
46 ,p_end_date IN DATE
47 ) RETURN NUMBER;
48
49 FUNCTION cf_rec_tax_calcformula(p_rec_per IN NUMBER) RETURN CHAR;
50
51 FUNCTION cf_tax_amtformula
52 (
53 p_invoice_id IN NUMBER
54 ,p_tax_type IN VARCHAR2
55 ,p_inv_type IN VARCHAR2
56 ,p_real_inv_amt IN NUMBER
57 ,p_txbl_discount_amt IN NUMBER
58 ,p_tax_amt IN NUMBER
59 ,p_payment_amt IN NUMBER
60 ,p_check_void_date IN DATE
61 ,p_start_date IN DATE
62 ,p_end_date IN DATE
63 ) RETURN NUMBER;
64
65 FUNCTION cf_txbl_discount_amtformula
66 (
67 p_tax_type IN VARCHAR2
68 ,p_inv_type IN VARCHAR2
69 ,p_invoice_id IN NUMBER
70 ,p_tax_rate IN NUMBER
71 ,p_start_date IN DATE
72 ,p_end_date IN DATE
73 ) RETURN NUMBER;
74
75 FUNCTION cf_item_tax_amtformula
76 (
77 p_cancelled_date IN DATE
78 ,p_acc_date IN DATE
79 ,p_tax_amt IN NUMBER
80 ,p_item_line_cnt IN NUMBER
81 ,p_start_date IN DATE
82 ,p_end_date IN DATE
83 ) RETURN NUMBER;
84
85 FUNCTION cf_real_inv_amtformula
86 (
87 p_invoice_id IN NUMBER
88 ,p_invoice_amount IN NUMBER
89 ) RETURN NUMBER;
90
91 FUNCTION G_DATA_FOUND_formula RETURN VARCHAR2;
92 FUNCTION G_CURR_NAME_formula RETURN VARCHAR2;
93 FUNCTION G_company_title_formula RETURN VARCHAR2;
94 FUNCTION G_PRECISION_formula RETURN NUMBER;
95
96 FUNCTION C_PRT_AMT_TXBLFormula
97 (
98 p_tax_type IN VARCHAR2
99 ,p_const_num IN VARCHAR2
100 ,p_inv_type IN VARCHAR2
101 ,p_tax_rate IN NUMBER
102 ,p_invoice_id IN NUMBER
103 ,p_tax_id IN NUMBER
104 ,p_offset_tax_rate_code IN VARCHAR2
105 ,p_start_date IN DATE
106 ,p_end_date IN DATE
107 ,p_real_inv_amt IN NUMBER
108 ,p_cancelled_date IN DATE
109 ,p_check_void_date IN DATE
110 ,p_payment_amt IN NUMBER
111 ,p_txbl_disc_amt IN NUMBER
112 ,p_tax_disc_amt IN NUMBER
113 ) RETURN VARCHAR2;
114
115 FUNCTION C_PRT_INV_AMTFormula
116 (
117 p_cancelled_date IN DATE
118 ,P_START_DATE IN DATE
119 ,P_END_DATE IN DATE
120 ,p_real_inv_amt IN NUMBER
121 ) RETURN VARCHAR2;
122
123 FUNCTION set_display_for_core RETURN BOOLEAN;
124 FUNCTION set_display_for_gov RETURN BOOLEAN;
125
126 FUNCTION get_balancing_segment
127 (
128 p_ccid IN NUMBER
129 ,x_company_desc IN OUT NOCOPY VARCHAR2
130 )
131 RETURN VARCHAR2;
132
133 FUNCTION get_balancing_segment
134 (
135 p_ccid IN NUMBER
136 )
137 RETURN VARCHAR2;
138
139 FUNCTION G_LEDGER_CURR_FORMULA RETURN VARCHAR2;
140 FUNCTION G_INDUSTRY_CODE_FORMULA RETURN VARCHAR2;
141
142 FUNCTION get_accounting_segment(p_ccid NUMBER) RETURN VARCHAR2;
143 END JE_ZZ_AUDIT_AP_PKG;