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_PAYMENT_P dependencies on JAI_FBT_PAYMENT

Line 1: PACKAGE BODY JAI_FBT_PAYMENT_P AS

1: PACKAGE BODY JAI_FBT_PAYMENT_P AS
2: --$Header: jainfbtpay.plb 120.0.12010000.1 2008/11/27 07:10:32 huhuliu noship $
3: --+=======================================================================+
4: --| Copyright (c) 1998 Oracle Corporation |
5: --| Redwood Shores, CA, USA |

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

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

Line 31: -- This procedure is to insert the data into jai_fbt_payment

27: -- Insert_Fbt_Payment Private
28: --
29: -- DESCRIPTION:
30: --
31: -- This procedure is to insert the data into jai_fbt_payment
32: --
33: -- PARAMETERS:
34: -- In: p_fbt_payment jai_fbt_repository record type
35: --

Line 44: ( p_fbt_payment IN jai_fbt_payment%ROWTYPE

40: --
41: -- 18-OCT-2007 Eric Ma created
42:
43: PROCEDURE Insert_Fbt_Payment
44: ( p_fbt_payment IN jai_fbt_payment%ROWTYPE
45: )
46: IS
47: lv_procedure_name VARCHAR2(40):='Insert_Fbt_Payment';
48: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 61: -- insert into jai_fbt_payment

57: , 'Enter procedure'
58: );
59: END IF; --l_proc_level>=l_dbg_level
60:
61: -- insert into jai_fbt_payment
62: INSERT INTO jai_fbt_payment
63: ( fbt_payment_id
64: , legal_entity_id
65: , fbt_year

Line 62: INSERT INTO jai_fbt_payment

58: );
59: END IF; --l_proc_level>=l_dbg_level
60:
61: -- insert into jai_fbt_payment
62: INSERT INTO jai_fbt_payment
63: ( fbt_payment_id
64: , legal_entity_id
65: , fbt_year
66: , status_date

Line 270: -- program for inserting the data into jai_fbt_payment table and

266: --
267: -- DESCRIPTION:
268: --
269: -- This is the main procedure which will be called by the concurrent
270: -- program for inserting the data into jai_fbt_payment table and
271: -- ap interface tables
272: --
273: -- PARAMETERS:
274: -- In: pn_legal_entity_id Identifier of legal entity

Line 299: , pn_legal_entity_id IN jai_fbt_payment.legal_entity_id%TYPE

295:
296: PROCEDURE Fbt_Payment
297: ( pv_errbuf OUT NOCOPY VARCHAR2
298: , pv_retcode OUT NOCOPY VARCHAR2
299: , pn_legal_entity_id IN jai_fbt_payment.legal_entity_id%TYPE
300: , pn_fbt_year IN jai_fbt_payment.fbt_year%TYPE
301: , pn_fbt_amount IN NUMBER
302: , pn_supplier_id IN jai_fbt_payment.inv_supplier_id%TYPE
303: , pn_supplier_site_id IN jai_fbt_payment.inv_supplier_site_id%TYPE

Line 300: , pn_fbt_year IN jai_fbt_payment.fbt_year%TYPE

296: PROCEDURE Fbt_Payment
297: ( pv_errbuf OUT NOCOPY VARCHAR2
298: , pv_retcode OUT NOCOPY VARCHAR2
299: , pn_legal_entity_id IN jai_fbt_payment.legal_entity_id%TYPE
300: , pn_fbt_year IN jai_fbt_payment.fbt_year%TYPE
301: , pn_fbt_amount IN NUMBER
302: , pn_supplier_id IN jai_fbt_payment.inv_supplier_id%TYPE
303: , pn_supplier_site_id IN jai_fbt_payment.inv_supplier_site_id%TYPE
304: , pn_ou_id IN jai_fbt_payment.inv_ou_id%TYPE

Line 302: , pn_supplier_id IN jai_fbt_payment.inv_supplier_id%TYPE

298: , pv_retcode OUT NOCOPY VARCHAR2
299: , pn_legal_entity_id IN jai_fbt_payment.legal_entity_id%TYPE
300: , pn_fbt_year IN jai_fbt_payment.fbt_year%TYPE
301: , pn_fbt_amount IN NUMBER
302: , pn_supplier_id IN jai_fbt_payment.inv_supplier_id%TYPE
303: , pn_supplier_site_id IN jai_fbt_payment.inv_supplier_site_id%TYPE
304: , pn_ou_id IN jai_fbt_payment.inv_ou_id%TYPE
305: , pn_fbt_tax_amount IN jai_fbt_payment.fbt_tax_amount%TYPE
306: , pn_fbt_surcharge_amount IN jai_fbt_payment.fbt_surcharge_amount%TYPE

Line 303: , pn_supplier_site_id IN jai_fbt_payment.inv_supplier_site_id%TYPE

299: , pn_legal_entity_id IN jai_fbt_payment.legal_entity_id%TYPE
300: , pn_fbt_year IN jai_fbt_payment.fbt_year%TYPE
301: , pn_fbt_amount IN NUMBER
302: , pn_supplier_id IN jai_fbt_payment.inv_supplier_id%TYPE
303: , pn_supplier_site_id IN jai_fbt_payment.inv_supplier_site_id%TYPE
304: , pn_ou_id IN jai_fbt_payment.inv_ou_id%TYPE
305: , pn_fbt_tax_amount IN jai_fbt_payment.fbt_tax_amount%TYPE
306: , pn_fbt_surcharge_amount IN jai_fbt_payment.fbt_surcharge_amount%TYPE
307: , pn_fbt_edu_cess_amount IN jai_fbt_payment.fbt_edu_cess_amount%TYPE

Line 304: , pn_ou_id IN jai_fbt_payment.inv_ou_id%TYPE

300: , pn_fbt_year IN jai_fbt_payment.fbt_year%TYPE
301: , pn_fbt_amount IN NUMBER
302: , pn_supplier_id IN jai_fbt_payment.inv_supplier_id%TYPE
303: , pn_supplier_site_id IN jai_fbt_payment.inv_supplier_site_id%TYPE
304: , pn_ou_id IN jai_fbt_payment.inv_ou_id%TYPE
305: , pn_fbt_tax_amount IN jai_fbt_payment.fbt_tax_amount%TYPE
306: , pn_fbt_surcharge_amount IN jai_fbt_payment.fbt_surcharge_amount%TYPE
307: , pn_fbt_edu_cess_amount IN jai_fbt_payment.fbt_edu_cess_amount%TYPE
308: , pn_fbt_sh_cess_amount IN jai_fbt_payment.fbt_sh_cess_amount%TYPE

Line 305: , pn_fbt_tax_amount IN jai_fbt_payment.fbt_tax_amount%TYPE

301: , pn_fbt_amount IN NUMBER
302: , pn_supplier_id IN jai_fbt_payment.inv_supplier_id%TYPE
303: , pn_supplier_site_id IN jai_fbt_payment.inv_supplier_site_id%TYPE
304: , pn_ou_id IN jai_fbt_payment.inv_ou_id%TYPE
305: , pn_fbt_tax_amount IN jai_fbt_payment.fbt_tax_amount%TYPE
306: , pn_fbt_surcharge_amount IN jai_fbt_payment.fbt_surcharge_amount%TYPE
307: , pn_fbt_edu_cess_amount IN jai_fbt_payment.fbt_edu_cess_amount%TYPE
308: , pn_fbt_sh_cess_amount IN jai_fbt_payment.fbt_sh_cess_amount%TYPE
309: , pv_status_date IN VARCHAR2

Line 306: , pn_fbt_surcharge_amount IN jai_fbt_payment.fbt_surcharge_amount%TYPE

302: , pn_supplier_id IN jai_fbt_payment.inv_supplier_id%TYPE
303: , pn_supplier_site_id IN jai_fbt_payment.inv_supplier_site_id%TYPE
304: , pn_ou_id IN jai_fbt_payment.inv_ou_id%TYPE
305: , pn_fbt_tax_amount IN jai_fbt_payment.fbt_tax_amount%TYPE
306: , pn_fbt_surcharge_amount IN jai_fbt_payment.fbt_surcharge_amount%TYPE
307: , pn_fbt_edu_cess_amount IN jai_fbt_payment.fbt_edu_cess_amount%TYPE
308: , pn_fbt_sh_cess_amount IN jai_fbt_payment.fbt_sh_cess_amount%TYPE
309: , pv_status_date IN VARCHAR2
310: )

Line 307: , pn_fbt_edu_cess_amount IN jai_fbt_payment.fbt_edu_cess_amount%TYPE

303: , pn_supplier_site_id IN jai_fbt_payment.inv_supplier_site_id%TYPE
304: , pn_ou_id IN jai_fbt_payment.inv_ou_id%TYPE
305: , pn_fbt_tax_amount IN jai_fbt_payment.fbt_tax_amount%TYPE
306: , pn_fbt_surcharge_amount IN jai_fbt_payment.fbt_surcharge_amount%TYPE
307: , pn_fbt_edu_cess_amount IN jai_fbt_payment.fbt_edu_cess_amount%TYPE
308: , pn_fbt_sh_cess_amount IN jai_fbt_payment.fbt_sh_cess_amount%TYPE
309: , pv_status_date IN VARCHAR2
310: )
311: IS

Line 308: , pn_fbt_sh_cess_amount IN jai_fbt_payment.fbt_sh_cess_amount%TYPE

304: , pn_ou_id IN jai_fbt_payment.inv_ou_id%TYPE
305: , pn_fbt_tax_amount IN jai_fbt_payment.fbt_tax_amount%TYPE
306: , pn_fbt_surcharge_amount IN jai_fbt_payment.fbt_surcharge_amount%TYPE
307: , pn_fbt_edu_cess_amount IN jai_fbt_payment.fbt_edu_cess_amount%TYPE
308: , pn_fbt_sh_cess_amount IN jai_fbt_payment.fbt_sh_cess_amount%TYPE
309: , pv_status_date IN VARCHAR2
310: )
311: IS
312: --ln_org_id NUMBER;

Line 314: fbt_payment_rec jai_fbt_payment%ROWTYPE;

310: )
311: IS
312: --ln_org_id NUMBER;
313: ln_invoice_amout NUMBER;
314: fbt_payment_rec jai_fbt_payment%ROWTYPE;
315: ln_invoice_id ap_invoices_interface.invoice_id%TYPE;
316: ln_invoice_num ap_invoices_interface.invoice_num%TYPE;
317: lv_currency_code ap_invoices_interface.invoice_currency_code%TYPE;
318: ln_accts_pay_ccid ap_invoices_interface.accts_pay_code_combination_id%TYPE;

Line 408: -- and JAI_FBT_PAYMENT

404: WHERE gsob.set_of_books_id = fnd_profile.VALUE('GL_SET_OF_BKS_ID')
405: AND gsob.currency_code = fc.currency_code;
406:
407: -- get invoice_id for ap_invoices_interface,ap_invoice_lines_interface
408: -- and JAI_FBT_PAYMENT
409: SELECT
410: ap_invoices_interface_s.nextval
411: INTO
412: ln_invoice_id

Line 416: SELECT jai_fbt_payment_s.NEXTVAL

412: ln_invoice_id
413: FROM dual;
414:
415: -- get the payment id
416: SELECT jai_fbt_payment_s.NEXTVAL
417: INTO ln_fbt_payment_id
418: FROM dual;
419:
420: -- get the org id, accts_pay_code_combination_id, payment_method_lookup_code

Line 429: --add lock on the jai_fbt_payment table

425: ln_accts_pay_ccid
426: , lv_payment_method_code;
427: CLOSE po_vendors_cur;
428:
429: --add lock on the jai_fbt_payment table
430: UPDATE
431: jai_fbt_payment
432: SET
433: invoice_date = invoice_date

Line 431: jai_fbt_payment

427: CLOSE po_vendors_cur;
428:
429: --add lock on the jai_fbt_payment table
430: UPDATE
431: jai_fbt_payment
432: SET
433: invoice_date = invoice_date
434: WHERE TRUNC(invoice_date) = TRUNC(invoice_date)
435: AND legal_entity_id = pn_legal_entity_id;

Line 443: jai_fbt_payment

439: COUNT(fbt_payment_id)+1
440: INTO
441: pn_invoice_number_seq
442: FROM
443: jai_fbt_payment
444: WHERE TRUNC(invoice_date) = TRUNC(ld_invoice_date)
445: AND legal_entity_id = pn_legal_entity_id;
446:
447: SELECT 'FBT/Invoice/'||pn_legal_entity_id||'/'|| TO_CHAR(ld_invoice_date,lv_date_mask)||'/'|| pn_invoice_number_seq

Line 451: -- insert the data into the table jai_fbt_payment

447: SELECT 'FBT/Invoice/'||pn_legal_entity_id||'/'|| TO_CHAR(ld_invoice_date,lv_date_mask)||'/'|| pn_invoice_number_seq
448: INTO ln_invoice_num
449: FROM dual;
450:
451: -- insert the data into the table jai_fbt_payment
452: fbt_payment_rec.fbt_payment_id := ln_fbt_payment_id;
453: fbt_payment_rec.legal_entity_id := pn_legal_entity_id;
454: fbt_payment_rec.fbt_year := pn_fbt_year;
455: fbt_payment_rec.status_date := ld_status_date;

Line 581: END JAI_FBT_PAYMENT_P;

577: , Sqlcode||Sqlerrm);
578: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
579: END Fbt_Payment;
580:
581: END JAI_FBT_PAYMENT_P;