1 PACKAGE JA_CN_CFS_DATA_CLT_PKG AS
2 --$Header: JACNCDCS.pls 120.0.12010000.2 2008/10/28 06:15:05 shyan ship $
3
4 --+=======================================================================+
5 --| Copyright (c) 2006 Oracle Corporation |
6 --| Redwood Shores, CA, USA |
7 --| All rights reserved. |
8 --+=======================================================================+
9 --| FILENAME |
10 --| JACNCDCS.pls |
11 --| |
12 --| DESCRIPTION |
13 --| This package is used in Collecting CFS Data from GL/Intercompany/ |
14 --| AR/AP in the CNAO Project. |
15 --| |
16 --| PROCEDURE LIST |
17 --| PROCEDURE Cfs_Data_Clt |
18 --| PROCEDURE collect_AR_data |
19 --| PROCEDURE collect_AP_data |
20 --| FUNCTION get_period_name |
21 --| |
22 --| HISTORY |
23 --| 03/01/2006 Andrew Liu Created |
24 --| 03/24/2006 Jogen Hu merge AR,AP parts |
25 --+======================================================================*/
26
27 --==========================================================================
28 -- PROCEDURE NAME:
29 -- Cfs_Data_Clt public
30 --
31 -- DESCRIPTION:
32 -- This procedure calls data collection programs according to
33 -- the specified source.
34 --
35 -- PARAMETERS:
36 -- In: P_SOB_ID NUMBER ID of Set Of Book
37 -- In: P_LE_ID NUMBER ID of Legal Entity
38 -- In: P_PERIOD_SET_NAME VARCHAR2 Name of the period set
39 -- in the set of book
40 -- In: P_GL_PERIOD_FROM VARCHAR2 Start period
41 -- In: P_GL_PERIOD_TO VARCHAR2 End period
42 -- In: P_SOURCE VARCHAR2 Source of the collection
43 -- In: P_DFT_ITEM VARCHAR2 default CFS item
44 --
45 -- DESIGN REFERENCES:
46 -- None
47 --
48 -- CHANGE HISTORY:
49 -- 03/01/2006 Andrew Liu Created
50 -- 04/01/2007 Yucheng Sun Updated
51 --===========================================================================
52 PROCEDURE Cfs_Data_Clt( P_COA_ID IN NUMBER
53 ,P_LEDGER_ID IN NUMBER
54 ,P_LE_ID IN NUMBER
55 ,P_PERIOD_SET_NAME IN VARCHAR2
56 ,P_GL_PERIOD_FROM IN VARCHAR2
57 ,P_GL_PERIOD_TO IN VARCHAR2
58 ,P_SOURCE IN VARCHAR2);
59
60 -- Fix bug#7334017 add begin
61 --==========================================================================
62 -- PROCEDURE NAME:
63 -- get_balancing_segment public
64 --
65 -- DESCRIPTION:
66 -- This procedure returns the balancing segment value of a CCID.
67 --
68 -- PARAMETERS:
69 -- In: P_CC_ID NUMBER
70 --
71 -- DESIGN REFERENCES:
72 -- None
73 --
74 -- CHANGE HISTORY:
75 -- 09/01/2008 Yao Zhang Created
76 --===========================================================================
77 FUNCTION get_balancing_segment
78 ( P_CC_ID IN NUMBER
79 )
80 RETURN VARCHAR2;
81 -- Fix bug#7334017 add end
82
83 --==========================================================================
84 -- FUNCTION NAME:
85 -- get_period_name Public
86 --
87 -- DESCRIPTION:
88 -- This FUNCTION is used to get period name from a period set and given date
89 -- the period name is month type
90 --
91 -- PARAMETERS:
92 -- In: p_period_set_name period set name
93 -- p_gl_date date
94 -- p_period_type period type
95 -- return: period name
96 --
97 -- DESIGN REFERENCES:
98 -- None
99 --
100 -- CHANGE HISTORY:
101 -- 03/08/2006 Jogen Hu Created
102 --===========================================================================
103 FUNCTION get_period_name(p_period_set_name IN VARCHAR2,
104 p_gl_date IN DATE,
105 p_period_type IN VARCHAR2) RETURN VARCHAR2;
106
107
108 END JA_CN_CFS_DATA_CLT_PKG;
109
[Home] [Help]