[Home] [Help]
PACKAGE: APPS.JAI_FBT_SETTLEMENT_P
Source
1 PACKAGE JAI_FBT_SETTLEMENT_P AUTHID CURRENT_USER AS
2 --$Header: jainfbtset.pls 120.0 2007/12/24 13:07:53 eaggarwa noship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
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 |
14 --| |
15 --| PROCEDURE LIST |
16 --| PROCEDURE Fbt_Settlement |
17 --| |
18 --| HISTORY |
19 --| 2007/10/18 Jason Liu Created |
20 --| |
21 --+======================================================================*/
22
23 -- Declare global variable for package name
24 GV_MODULE_PREFIX VARCHAR2(50) :='jai.plsql.JAI_FBT_SETTLEMENT_P';
25 GV_DATE_MASK CONSTANT VARCHAR2(25):= 'DD-MON-YYYY';
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_Settlement 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_settlement table and
74 -- ap interface tables
75 --
76 -- PARAMETERS:
77 -- In: pn_legal_entity_id Identifier of legal entity
78 -- pv_start_date Identifier of period start date
79 -- pv_end_date Identifier of period end date
80 -- pn_projected_amount Identifier of projected FBT amount
81 -- pn_supplier_id Identifier of supplier id
82 -- pn_supplier_site_id Identifier of supplier site id
83 --
84 -- Out: pv_errbuf Returns the error if concurrent program
85 -- does not execute completely
86 -- pv_retcode Returns success or failure
87 --
88 -- DESIGN REFERENCES:
89 -- FBT Technical Design Document 1.1.doc
90 --
91 -- CHANGE HISTORY:
92 --
93 -- 18-OCT-2007 Jason Liu created
94
95 PROCEDURE Fbt_Settlement
96 ( pv_errbuf OUT NOCOPY VARCHAR2
97 , pv_retcode OUT NOCOPY VARCHAR2
98 , pn_legal_entity_id IN jai_fbt_settlement.legal_entity_id%TYPE
99 , pv_start_date IN VARCHAR2
100 , pv_end_date IN VARCHAR2
101 , pn_projected_amount IN jai_fbt_settlement.Projected_Amount%TYPE
102 , pn_supplier_id IN jai_fbt_settlement.inv_supplier_id%TYPE
103 , pn_supplier_site_id IN jai_fbt_settlement.inv_supplier_site_id%TYPE
104 );
105
106 END JAI_FBT_SETTLEMENT_P;