eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_FBT_SETTLEMENT_P dependencies on JAI_FBT_SETTLEMENT

Line 1: PACKAGE BODY JAI_FBT_SETTLEMENT_P AS

1: PACKAGE BODY JAI_FBT_SETTLEMENT_P AS
2: --$Header: jainfbtset.plb 120.2 2008/06/04 02:28:20 jianliu noship $
3: --+=======================================================================+
4: --| Copyright (c) 1998 Oracle Corporation |
5: --| Redwood Shores, CA, USA |

Line 9: --| jai_fbt_settlement_p.pls |

5: --| Redwood Shores, CA, USA |
6: --| All rights reserved. |
7: --+=======================================================================+
8: --| FILENAME |
9: --| jai_fbt_settlement_p.pls |
10: --| |
11: --| DESCRIPTION |
12: --| To be called by the concurrent program for inserting the |
13: --| data into jai_fbt_settlement table and ap interface tables |

Line 13: --| data into jai_fbt_settlement table and ap interface tables |

9: --| jai_fbt_settlement_p.pls |
10: --| |
11: --| DESCRIPTION |
12: --| To be called by the concurrent program for inserting the |
13: --| data into jai_fbt_settlement table and ap interface tables |
14: --| |
15: --| PROCEDURE LIST |
16: --| PROCEDURE Insert_Fbt_Settlement |
17: --| PROCEDURE Insert_Interface_Table |

Line 32: -- This procedure is to insert the data into jai_fbt_settlement

28: -- Insert_Fbt_Settlement Private
29: --
30: -- DESCRIPTION:
31: --
32: -- This procedure is to insert the data into jai_fbt_settlement
33: --
34: -- PARAMETERS:
35: -- In: p_fbt_settlement jai_fbt_repository record type
36: --

Line 45: ( p_fbt_settlement IN jai_fbt_settlement%ROWTYPE

41: --
42: -- 18-OCT-2007 Jason Liu created
43:
44: PROCEDURE Insert_Fbt_Settlement
45: ( p_fbt_settlement IN jai_fbt_settlement%ROWTYPE
46: )
47: IS
48: lv_procedure_name VARCHAR2(40):='Insert_Fbt_Settlement';
49: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 62: -- insert into jai_fbt_settlement

58: , 'Enter procedure'
59: );
60: END IF; --l_proc_level>=l_dbg_level
61:
62: -- insert into jai_fbt_settlement
63: INSERT INTO jai_fbt_settlement
64: ( legal_entity_id
65: , period_start_date
66: , period_end_date

Line 63: INSERT INTO jai_fbt_settlement

59: );
60: END IF; --l_proc_level>=l_dbg_level
61:
62: -- insert into jai_fbt_settlement
63: INSERT INTO jai_fbt_settlement
64: ( legal_entity_id
65: , period_start_date
66: , period_end_date
67: , consolidated_amount

Line 264: -- program for inserting the data into jai_fbt_settlement table and

260: --
261: -- DESCRIPTION:
262: --
263: -- This is the main procedure which will be called by the concurrent
264: -- program for inserting the data into jai_fbt_settlement table and
265: -- ap interface tables
266: --
267: -- PARAMETERS:
268: -- In: pn_legal_entity_id Identifier of legal entity

Line 293: , pn_legal_entity_id IN jai_fbt_settlement.legal_entity_id%TYPE

289:
290: PROCEDURE Fbt_Settlement
291: ( pv_errbuf OUT NOCOPY VARCHAR2
292: , pv_retcode OUT NOCOPY VARCHAR2
293: , pn_legal_entity_id IN jai_fbt_settlement.legal_entity_id%TYPE
294: , pv_start_date IN VARCHAR2
295: , pv_end_date IN VARCHAR2
296: , pn_projected_amount IN jai_fbt_settlement.Projected_Amount%TYPE
297: , pn_supplier_id IN jai_fbt_settlement.inv_supplier_id%TYPE

Line 296: , pn_projected_amount IN jai_fbt_settlement.Projected_Amount%TYPE

292: , pv_retcode OUT NOCOPY VARCHAR2
293: , pn_legal_entity_id IN jai_fbt_settlement.legal_entity_id%TYPE
294: , pv_start_date IN VARCHAR2
295: , pv_end_date IN VARCHAR2
296: , pn_projected_amount IN jai_fbt_settlement.Projected_Amount%TYPE
297: , pn_supplier_id IN jai_fbt_settlement.inv_supplier_id%TYPE
298: , pn_supplier_site_id IN jai_fbt_settlement.inv_supplier_site_id%TYPE
299: )
300: IS

Line 297: , pn_supplier_id IN jai_fbt_settlement.inv_supplier_id%TYPE

293: , pn_legal_entity_id IN jai_fbt_settlement.legal_entity_id%TYPE
294: , pv_start_date IN VARCHAR2
295: , pv_end_date IN VARCHAR2
296: , pn_projected_amount IN jai_fbt_settlement.Projected_Amount%TYPE
297: , pn_supplier_id IN jai_fbt_settlement.inv_supplier_id%TYPE
298: , pn_supplier_site_id IN jai_fbt_settlement.inv_supplier_site_id%TYPE
299: )
300: IS
301: lv_start_date VARCHAR2(30);

Line 298: , pn_supplier_site_id IN jai_fbt_settlement.inv_supplier_site_id%TYPE

294: , pv_start_date IN VARCHAR2
295: , pv_end_date IN VARCHAR2
296: , pn_projected_amount IN jai_fbt_settlement.Projected_Amount%TYPE
297: , pn_supplier_id IN jai_fbt_settlement.inv_supplier_id%TYPE
298: , pn_supplier_site_id IN jai_fbt_settlement.inv_supplier_site_id%TYPE
299: )
300: IS
301: lv_start_date VARCHAR2(30);
302: lv_end_date VARCHAR2(30);

Line 312: fbt_settlement_rec jai_fbt_settlement%ROWTYPE;

308: lv_settled_flag VARCHAR2(1);
309: ln_settlement_id NUMBER;
310: ln_consolidated_amount NUMBER;
311: ln_invoice_amout NUMBER;
312: fbt_settlement_rec jai_fbt_settlement%ROWTYPE;
313: ln_invoice_id ap_invoices_interface.invoice_id%TYPE;
314: ln_invoice_num ap_invoices_interface.invoice_num%TYPE;
315: lv_currency_code ap_invoices_interface.invoice_currency_code%TYPE;
316: ln_accts_pay_ccid ap_invoices_interface.accts_pay_code_combination_id%TYPE;

Line 341: FROM jai_fbt_settlement

337: CURSOR check_settled IS
338: SELECT 1
339: FROM dual
340: WHERE EXISTS( SELECT 1
341: FROM jai_fbt_settlement
342: WHERE legal_entity_id = pn_legal_entity_id
343: AND period_start_date = ld_start_date
344: AND period_end_date = ld_end_date);
345:

Line 429: SELECT jai_fbt_settlement_s.NEXTVAL

425: , lv_payment_method_code;
426: CLOSE po_vendors_cur;
427:
428: -- get the settlement id
429: SELECT jai_fbt_settlement_s.NEXTVAL
430: INTO ln_settlement_id
431: FROM dual;
432:
433: -- insert the data into the table jai_fbt_settlement

Line 433: -- insert the data into the table jai_fbt_settlement

429: SELECT jai_fbt_settlement_s.NEXTVAL
430: INTO ln_settlement_id
431: FROM dual;
432:
433: -- insert the data into the table jai_fbt_settlement
434: fbt_settlement_rec.legal_entity_id := pn_legal_entity_id;
435: fbt_settlement_rec.period_start_date := ld_start_date;
436: fbt_settlement_rec.period_end_date := ld_end_date;
437: fbt_settlement_rec.consolidated_amount := NVL(ln_consolidated_amount, 0);

Line 558: END JAI_FBT_SETTLEMENT_P;

554: , Sqlcode||Sqlerrm);
555: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
556: END Fbt_Settlement;
557:
558: END JAI_FBT_SETTLEMENT_P;