[Home] [Help]
PACKAGE: APPS.JAI_FBT_PAYMENT_P
Source
1 PACKAGE JAI_FBT_PAYMENT_P AUTHID CURRENT_USER AS
2 --$Header: jainfbtpay.pls 120.0.12010000.1 2008/11/27 07:29:48 huhuliu noship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| jainfbtpay.pls |
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 Fbt_Payment |
17 --| |
18 --| HISTORY |
19 --| 2008/10/18 Eric Ma Created |
20 --| |
21 --+======================================================================*/
22
23 -- Declare global variable for package name
24 GV_MODULE_PREFIX VARCHAR2(50) :='jai.plsql.JAINFBTPAY';
25
26 -- type for ap_invoices_interface
27 TYPE inv_interface_rec_type IS RECORD
28 ( invoice_id ap_invoices_interface.invoice_id%TYPE
29 , invoice_num ap_invoices_interface.invoice_num%TYPE
30 , invoice_date ap_invoices_interface.invoice_date%TYPE
31 , vendor_id ap_invoices_interface.vendor_id%TYPE
32 , vendor_site_id ap_invoices_interface.vendor_site_id%TYPE
33 , invoice_amount ap_invoices_interface.invoice_amount%TYPE
34 , invoice_currency_code ap_invoices_interface.invoice_currency_code%TYPE
35 , accts_pay_ccid ap_invoices_interface.accts_pay_code_combination_id%TYPE
36 , source ap_invoices_interface.source%TYPE
37 , org_id ap_invoices_interface.org_id%TYPE
38 , legal_entity_id ap_invoices_interface.legal_entity_id%TYPE
39 , payment_method_lookup_code ap_invoices_interface.payment_method_lookup_code%TYPE
40 , created_by ap_invoices_interface.created_by%TYPE
41 , creation_date ap_invoices_interface.creation_date%TYPE
42 , last_updated_by ap_invoices_interface.last_updated_by%TYPE
43 , last_update_date ap_invoices_interface.last_update_date%TYPE
44 , last_update_login ap_invoices_interface.last_update_login%TYPE
45 );
46
47 -- type for ap_invoice_lines_interface
48 TYPE inv_lines_interface_rec_type IS RECORD
49 ( invoice_id ap_invoice_lines_interface.invoice_id%TYPE
50 , invoice_line_id ap_invoice_lines_interface.invoice_line_id%TYPE
51 , line_number ap_invoice_lines_interface.line_number%TYPE
52 , line_type_lookup_code ap_invoice_lines_interface.line_type_lookup_code%TYPE
53 , amount ap_invoice_lines_interface.amount%TYPE
54 , accounting_date ap_invoice_lines_interface.accounting_date%TYPE
55 , description ap_invoice_lines_interface.description%TYPE
56 , dist_code_combination_id ap_invoice_lines_interface.dist_code_combination_id%TYPE
57 , org_id ap_invoice_lines_interface.org_id%TYPE
58 , created_by ap_invoice_lines_interface.created_by%TYPE
59 , creation_date ap_invoice_lines_interface.creation_date%TYPE
60 , last_updated_by ap_invoice_lines_interface.last_updated_by%TYPE
61 , last_update_date ap_invoice_lines_interface.last_update_date%TYPE
62 , last_update_login ap_invoice_lines_interface.last_update_login%TYPE
63 );
64
65 --==========================================================================
66 -- PROCEDURE NAME:
67 --
68 -- Fbt_Payment Public
69 --
70 -- DESCRIPTION:
71 --
72 -- This is the main procedure which will be called by the concurrent
73 -- program for inserting the data into jai_fbt_payment table and
74 -- ap interface tables
75 --
76 -- PARAMETERS:
77 -- In: pn_legal_entity_id Identifier of legal entity
78 -- pn_fbt_year Fbt year
79 -- pn_fbt_amount Total fbt tax amount
80 -- pn_supplier_id Identifier of supplier
81 -- pn_supplier_site_id Identifier of supplier site
82 -- pn_ou_id Identifier of Operating unit
83 -- pn_fbt_tax_amount The amount of fbt tax
84 -- pn_fbt_surcharge_amount The amount of surcharge tax
85 -- pn_fbt_edu_cess_amount The amount of edu cess tax
86 -- pn_FBT_sh_cess_AMOUNT The amount of sh cess tax
87 --
88 -- Out: pv_errbuf Returns the error if concurrent program
89 -- does not execute completely
90 -- pv_retcode Returns success or failure
91 --
92 -- DESIGN REFERENCES:
93 -- FBT Technical Design Document 1.1.doc
94 --
95 -- CHANGE HISTORY:
96 --
97 -- 21-OCT-2008 Eric Ma created
98
99 PROCEDURE Fbt_Payment
100 ( pv_errbuf OUT NOCOPY VARCHAR2
101 , pv_retcode OUT NOCOPY VARCHAR2
102 , pn_legal_entity_id IN jai_fbt_payment.legal_entity_id%TYPE
103 , pn_fbt_year IN jai_fbt_payment.fbt_year%TYPE
104 , pn_fbt_amount IN NUMBER
105 , pn_supplier_id IN jai_fbt_payment.inv_supplier_id%TYPE
106 , pn_supplier_site_id IN jai_fbt_payment.inv_supplier_site_id%TYPE
107 , pn_ou_id IN jai_fbt_payment.inv_ou_id%TYPE
108 , pn_fbt_tax_amount IN jai_fbt_payment.fbt_tax_amount%TYPE
109 , pn_fbt_surcharge_amount IN jai_fbt_payment.fbt_surcharge_amount%TYPE
110 , pn_fbt_edu_cess_amount IN jai_fbt_payment.fbt_edu_cess_amount%TYPE
111 , pn_fbt_sh_cess_amount IN jai_fbt_payment.fbt_sh_cess_amount%TYPE
112 , pv_status_date IN VARCHAR2
113 );
114
115 END JAI_FBT_PAYMENT_P;