APPS.JAI_FBT_PROCESS_P dependencies on JAI_FBT_REPOSITORY

Line 13: --| and calculate the tax and insert data into jai_fbt_repository |

9: --| jai_fbt_process_p.plb |
10: --| |
11: --| DESCRIPTION |
12: --| To fetch eligible ap invoices and gl journals for FBT assessment |
13: --| and calculate the tax and insert data into jai_fbt_repository |
14: --| table |
15: --| |
16: --| PROCEDURE LIST |
17: --| PROCEDURE Fbt_Inv_Process |

Line 35: --| UPDATE jai_fbt_repository |

31: --| 2008/07/29 Eric Ma Code change for 11.5 backport |
32: --| 2008/08/11 Xiao Lv Code change for 11i new changes |
33: --| 2008/08/25 Xiao Lv Fixing bug#7347306, bug#7347401 |
34: --| Commented this piece of code in Fbt_Inv_process |
35: --| UPDATE jai_fbt_repository |
36: --| SET settlement_id = NULL |
37: --| WHERE legal_entity_id = pn_legal_entity_id |
38: --| AND period_start_date >= ld_start_date |
39: --| AND period_end_date <= ld_end_date |

Line 194: -- populated in jai_fbt_repository table

190: --
191: -- DESCRIPTION:
192: --
193: -- This procedure calculates the various tax amounts which need to be
194: -- populated in jai_fbt_repository table
195: --
196: -- PARAMETERS:
197: -- In: pn_legal_entity_id Identifier of legal entity
198: -- pv_fringe_benefit_type_code Identifier of FB type code

Line 232: , x_fbt_repository_type OUT NOCOPY JAI_FBT_REPOSITORY%ROWTYPE

228: , pd_exchange_date IN DATE
229: , pn_source IN VARCHAR2
230: , pn_je_header_id IN NUMBER
231: , pn_fbt_year IN NUMBER
232: , x_fbt_repository_type OUT NOCOPY JAI_FBT_REPOSITORY%ROWTYPE
233: )
234: IS
235: dummy varchar2(10);
236: Begin

Line 247: -- This procedure insert one record into table jai_fbt_repository

243: -- Insert_Fbt_Repository Private
244: --
245: -- DESCRIPTION:
246: --
247: -- This procedure insert one record into table jai_fbt_repository
248: --
249: -- PARAMETERS:
250: -- In: p_fbt_repository Identifier of record containing
251: -- fbt repository information

Line 263: ( p_fbt_repository IN JAI_FBT_REPOSITORY%ROWTYPE

259: -- 11-AUG-2008 Xiao Lv modified for 11i new changes
260: -- 14-NOV-2008 Xiao Lv modified for R12 new changes
261:
262: PROCEDURE Insert_Fbt_Repository
263: ( p_fbt_repository IN JAI_FBT_REPOSITORY%ROWTYPE
264: )
265: IS
266: dummy varchar2(10);
267: Begin

Line 280: -- data into jai_fbt_repository table

276: -- DESCRIPTION:
277: --
278: -- This is the main procedure which will be called by the concurrent
279: -- program to check eligible invoices, calculate FBT taxes and insert
280: -- data into jai_fbt_repository table
281: --
282: -- PARAMETERS:
283: -- In: pn_legal_entity_id Identifier of legal entity
284: -- pv_start_date Identifier of period start date