[Home] [Help]
PACKAGE: APPS.JA_CN_AP_PBD_EXPORT_PKG
Source
1 PACKAGE JA_CN_AP_PBD_EXPORT_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNPBDS.pls 120.1.12020000.3 2013/03/29 03:26:11 chongwan ship $
3 --+=======================================================================+
4 --| Copyright (c) 1998 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNPBDS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| To export receivable balance and details for each customer|
13 --| as per liability accounts, such as "Account Payable", |
14 --| "Payable in Advance", "Bill Payable", And "Other Payable", |
15 --| by period. |
16 --| |
17 --| PROCEDURE LIST |
18 --| PROCEDURE Add_Payables_Balance_Detail |
19 --| |
20 --| |
21 --| HISTORY |
22 --| 06-Apr-2010 Chaoqun Wu created |
23 --| 24-Aug-2010 Chaoqun Wu Updated for new solution described in |
24 --| bug# 10041443, to poluplate year |
25 --| beginning balance |
26 --| 29-Mar-2013 Jar.Wang Updated for bug 16203205 |
27 --+======================================================================*/
28 --==========================================================================
29 -- PROCEDURE NAME:
30 --
31 -- Get_Balance_Side Public
32 --
33 -- DESCRIPTION:
34 --
35 -- To get balance side
36 --
37 -- PARAMETERS:
38 -- pn_coa_id IN NUMBER chart of account id
39 -- pv_account_num IN VARCHAR2 account number
40 --
41 -- DESIGN REFERENCES:
42 -- APAR_Chaoqun.doc
43 --
44 -- CHANGE HISTORY:
45 -- 04-May-2010 Chaoqun Wu created
46 --==========================================================================
47 FUNCTION Get_Balance_Side
48 (pn_coa_id IN NUMBER
49 ,pv_account_number IN VARCHAR2)
50 RETURN VARCHAR2;
51 --==========================================================================
52 -- PROCEDURE NAME:
53 --
54 -- Add_Payables_Balance_Detail Public
55 --
56 -- DESCRIPTION:
57 --
58 -- To export receivable balance and details for each customer
59 -- as per liability accounts, such as "Account Payable",
60 -- "Payable in Advance", "Bill Payable", And "Other Payable",
61 -- by period.
62 --
63 -- PARAMETERS:
64 -- In: pn_legal_entity_id NUMBER identifier of legal entity
65 -- pn_ledger_id NUMBER identifier of ledger
66 -- pn_coa_id NUMBER identifier of chart of account
67 -- pv_accounting_year VARCHAR2 accounting year
68 -- pv_period_from VARCHAR2 period from
69 -- pv_period_to VARCHAR2 period to
70 --
71 -- DESIGN REFERENCES:
72 -- APAR_Chaoqun.doc
73 --
74 -- CHANGE HISTORY:
75 -- 06-Apr-2010 Chaoqun Wu created
76 --==========================================================================
77
78 PROCEDURE Add_Payables_Balance_Detail
79 (pn_legal_entity_id IN NUMBER
80 ,pn_ledger_id IN NUMBER
81 ,pn_coa_id IN NUMBER
82 ,pv_accounting_year IN VARCHAR2
83 ,pv_period_from IN VARCHAR2
84 ,pv_period_to IN VARCHAR2
85 );
86
87 END JA_CN_AP_PBD_EXPORT_PKG;
88