[Home] [Help]
PACKAGE: APPS.JAI_FBT_PROCESS_P
Source
1 PACKAGE JAI_FBT_PROCESS_P AS
2 --$Header: jainfbtprc.pls 120.0.12010000.2 2008/11/27 04:32:44 huhuliu ship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| jai_fbt_process_p.pls |
10 --| |
11 --| DESCRIPTION |
12 --| To fetch eligible ap invoices for FBT assessment and calculate |
13 --| the tax and insert data into jai_fbt_repository table |
14 --| |
15 --| PROCEDURE LIST |
16 --| PROCEDURE Fbt_Inv_Process |
17 --| FUNCTION Get_Natural_Acc_Seg |
18 --| FUNCTION Check_Inv_Validation |
19 --| |
20 --| HISTORY |
21 --| 2007/10/11 Kevin Cheng Created |
22 --| |
23 --+======================================================================*/
24
25 -- Declare global variable for package name
26 GV_MODULE_PREFIX VARCHAR2(50) :='jai.plsql.JAI_FBT_PROCESS_P';
27 GV_DATE_MASK CONSTANT VARCHAR2(25) := 'DD-MON-YYYY';
28
29 --==========================================================================
30 -- FUNCTION NAME:
31 --
32 -- Get_Natural_Acc_Seg Public
33 --
34 -- DESCRIPTION:
35 --
36 -- This function is used to get the natural account segment value
37 --
38 -- PARAMETERS:
39 -- In: pv_col_name Identifier of natural account name
40 -- pn_ccid Identifier of code combination id
41 --
42 -- DESIGN REFERENCES:
43 -- FBT Technical Design Document 1.1.doc
44 --
45 -- CHANGE HISTORY:
46 --
47 -- 11-OCT-2007 Kevin Cheng created
48
49 FUNCTION Get_Natural_Acc_Seg
50 ( pv_col_name IN VARCHAR2
51 , pn_ccid IN NUMBER
52 )
53 RETURN VARCHAR2;
54
55 --==========================================================================
56 -- FUNCTION NAME:
57 --
58 -- Get_Balance_Acc_Seg Public
59 --
60 -- DESCRIPTION:
61 --
62 -- This function is used to get the balance account segment value
63 --
64 -- PARAMETERS:
65 -- In: pv_col_name Identifier of natural account name
66 -- pn_ccid Identifier of code combination id
67 --
68 -- DESIGN REFERENCES:
69 -- FBT Technical Design Document 1.1.doc
70 --
71 -- CHANGE HISTORY:
72 --
73 -- 11-AUG-2008 Xiao Lv created
74
75 FUNCTION Get_Balance_Acc_Seg
76 ( pv_col_name IN VARCHAR2
77 , pn_ccid IN NUMBER
78 )
79 RETURN VARCHAR2;
80
81
82 --==========================================================================
83 -- FUNCTION NAME:
84 --
85 -- Check_Inv_Validation Public
86 --
87 -- DESCRIPTION:
88 --
89 -- This function checks whether the invoice is validate or not
90 --
91 -- PARAMETERS:
92 -- In: pn_invoice_id Identifier of ap invoices
93 --
94 -- DESIGN REFERENCES:
95 -- FBT Technical Design Document 1.1.doc
96 --
97 -- CHANGE HISTORY:
98 --
99 -- 11-OCT-2007 Kevin Cheng created
100
101 FUNCTION Check_Inv_Validation
102 ( pn_invoice_id IN NUMBER
103 )
104 RETURN VARCHAR2;
105
106 --==========================================================================
107 -- PROCEDURE NAME:
108 --
109 -- Fbt_Inv_Process Public
110 --
111 -- DESCRIPTION:
112 --
113 -- This is the main procedure which will be called by the concurrent
114 -- program to check eligible invoices, calculate FBT taxes and insert
115 -- data into jai_fbt_repository table
116 --
117 -- PARAMETERS:
118 -- In: pn_legal_entity_id Identifier of legal entity
119 -- pv_start_date Identifier of period start date
120 -- pv_end_date Identifier of period end date
121 -- pv_fringe_benefit_type_code Identifier of FB type code
122 -- pv_generate_return Identifier of supplier id
123 --
124 -- Out: pv_errbuf Returns the error if concurrent program
125 -- does not execute completely
126 -- pv_retcode Returns success or failure
127 --
128 -- DESIGN REFERENCES:
129 -- FBT Technical Design Document 1.1.doc
130 --
131 -- CHANGE HISTORY:
132 --
133 -- 11-OCT-2007 Kevin Cheng created
134 -- 06-NOV-2008 Xiao Lv modified
135
136 PROCEDURE Fbt_Inv_Process
137 ( pv_errbuf OUT NOCOPY VARCHAR2
138 , pv_retcode OUT NOCOPY VARCHAR2
139 , pn_legal_entity_id IN NUMBER
140 , pn_fbt_year IN NUMBER
141 , pv_start_date IN VARCHAR2
142 , pv_end_date IN VARCHAR2
143 , pv_fringe_benefit_type_code IN VARCHAR2
144 );
145
146 END JAI_FBT_PROCESS_P;