[Home] [Help]
PACKAGE: APPS.JA_CN_GL_INTER_VALID_PKG
Source
1 PACKAGE JA_CN_GL_INTER_VALID_PKG AUTHID CURRENT_USER AS
2 --$Header: JACNGIVS.pls 120.2.12010000.2 2008/10/28 07:01:28 shyan ship $
3 --+=======================================================================+
4 --| Copyright (c) 2006 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| JACNGIVS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| This package is used for GL Journals and Intercompany Transactions|
13 --| Validation in the CNAO Project. |
14 --| |
15 --| PROCEDURE LIST |
16 --| PROCEDURE GL_Validation |
17 --| PROCEDURE Intercompany_Validation |
18 --| |
19 --| HISTORY |
20 --| 02/24/2006 Andrew Liu Created |
21 --| 04/30/2007 Yucheng Sun Updated
22 --| 04/09/2008 Chaoqun Wu Updated for CNAO Enhancement |
23 --+======================================================================*/
24
25 --==========================================================================
26 -- PROCEDURE NAME:
27 -- GL_Validation Public
28 --
29 -- DESCRIPTION:
30 -- This procedure checks GL Journals and output the invalid ones.
31 --
32 -- PARAMETERS:
33 -- Out: errbuf NOCOPY VARCHAR2
34 -- Out: retcode NOCOPY VARCHAR2
35 -- In: P_COA_ID NUMBER Chart of Accounts id
36 -- In: P_LE_ID NUMBER ID of Legal Entity
37 -- In: P_LEDGER_ID NUMBER ID of the ledger
38 -- In: P_START_PERIOD VARCHAR2 Start period
39 -- In: P_END_PERIOD VARCHAR2 End period
40 -- In: P_SOURCE VARCHAR2 Specified journal source
41 -- In: P_JOURNAL_CTG VARCHAR2 Specified journal category
42 -- In: P_STATUS VARCHAR2 The gl status transfered from AGIS
43 --
44 -- DESIGN REFERENCES:
45 -- None
46 --
47 -- CHANGE HISTORY:
48 -- 02/24/2006 Andrew Liu Created
49 -- 04/13/2007 Yucheng Sun Updated
50 -- delete parameter: P_COM_SEGMENT
51 -- 03/09/2008 Chaoqun Wu Updated
52 -- CNAO Enhancement: add company segment
53 --===========================================================================
54 PROCEDURE GL_Validation( errbuf OUT NOCOPY VARCHAR2
55 ,retcode OUT NOCOPY VARCHAR2
56 ,P_COA_ID IN NUMBER
57 ,P_LE_ID IN NUMBER
58 ,P_LEDGER_ID IN NUMBER
59 ,P_START_PERIOD IN VARCHAR2
60 ,P_END_PERIOD IN VARCHAR2
61 ,P_SOURCE IN VARCHAR2
62 ,P_JOURNAL_CTG IN VARCHAR2
63 ,P_STATUS IN VARCHAR2
64 ,P_COM_SEG IN VARCHAR2 --Added for CNAO Enhancement
65 );
66
67 --==========================================================================
68 -- PROCEDURE NAME:
69 -- Intercompany_Validation Public
70 --
71 -- DESCRIPTION:
72 -- This procedure checks Intercompany transactions and output
73 -- the invalid ones.
74 --
75 -- PARAMETERS:
76 -- Out: errbuf NOCOPY VARCHAR2
77 -- Out: retcode NOCOPY VARCHAR2
78 -- In: P_COA_ID NUMBER chart of accounts ID
79 -- In: P_LE_ID NUMBER ID of Legal Entity
80 -- In: P_LEDGER_ID NUMBER ID of the ledger
81 -- In: P_START_PERIOD VARCHAR2 Start period
82 -- In: P_END_PERIOD VARCHAR2 End period
83 -- In: P_STATUS VARCHAR2 The gl status transfered from AGIS
84 --
85 -- DESIGN REFERENCES:
86 -- None
87 --
88 -- CHANGE HISTORY:
89 -- 02/24/2006 Andrew Liu Created
90 -- 04/21/2007 Yucheng Sun Updated
91 -- delete parameter: P_COM_SEGMENT
92 -- 02/09/2008 Chaoqun Wu Updated
93 -- CNAO Enhancement: add company segment
94 --===========================================================================
95 PROCEDURE Intercompany_Validation( errbuf OUT NOCOPY VARCHAR2
96 ,retcode OUT NOCOPY VARCHAR2
97 ,P_COA_ID IN NUMBER
98 ,P_LE_ID IN NUMBER
99 ,P_LEDGER_ID IN NUMBER
100 ,P_START_PERIOD IN VARCHAR2
101 ,P_END_PERIOD IN VARCHAR2
102 ,P_STATUS IN VARCHAR2
103 ,P_COM_SEG IN VARCHAR2 --Added for CNAO Enhancement
104 );
105
106
107 /*procedure Get_Account_Combo_and_Desc(
108 P_SOB_ID IN number, P_CCID IN number,
109 P_ACCOUNT OUT VARCHAR2,P_ACCOUNT_DESC OUT VARCHAR2
110 );*/
111 END JA_CN_GL_INTER_VALID_PKG;
112