DBA Data[Home] [Help]

PACKAGE: APPS.OZF_GL_TRANSFER_PVT

Source


1 PACKAGE OZF_GL_TRANSFER_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvgtrs.pls 120.1 2010/09/14 11:46:05 bkunjan ship $ */
3 
4 ---------------------------------------------------------------------
5 -- FUNCTION
6 --    OZF_MC_CHECK
7 --
8 -- PURPOSE
9 -- Verifies if the given set of book has any reporting sets of books associated.
10 --
11 ---------------------------------------------------------------------
12 
13 --FUNCTION ozf_mc_check ( p_psob_id NUMBER ) RETURN VARCHAR2;
14 
15 
16 ---------------------------------------------------------------------
17 -- PROCEDURE
18 --    OZF_GL_TRANSFER
19 --
20 -- PURPOSE
21 -- Trnasfer accrual liability and claims accounting records to GL
22 --
23 -- HISTORY
24 -- 09-Mar-2010  KPATRO   UPDATED  ER#9441192 ChRM-SLA Uptake
25 --                                GL Transfer Program is no longer used
26 --                                and we can post the Accrual and promotional
27 --                                claim accounting through SLA Create Accounting
28 --                                program.
29 ---------------------------------------------------------------------
30 
31 /*PROCEDURE  OZF_GL_TRANSFER (
32                             p_errbuf                      OUT NOCOPY  VARCHAR2
33                            ,p_retcode                     OUT NOCOPY  NUMBER
34 
35                            ,p_selection_type                   NUMBER
36                            ,p_set_of_books_id                  NUMBER
37                            ,p_include_reporting_sob            VARCHAR2
38                            ,p_batch_name                       VARCHAR2
39                            ,p_start_date                       VARCHAR2
40                            ,p_end_date                         VARCHAR2
41                            ,p_accounting_method                VARCHAR2
42                            ,p_document_class                   VARCHAR2 DEFAULT NULL
43                            ,p_journal_category                 VARCHAR2
44                            ,p_validate_account                 VARCHAR2
45                            ,p_gl_transfer_mode                 VARCHAR2
46                            ,p_submit_journal_import            VARCHAR2
47                            ,p_summary_journal_entry            VARCHAR2
48                            ,p_process_days                     NUMBER
49                            ,p_debug_flag                       VARCHAR2
50                            ,p_trace_flag                       VARCHAR2
51                            );
52 
53 */
54 ---------------------------------------------------------------------
55 -- PROCEDURE
56 --    CreateAccounting
57 --
58 -- PURPOSE
59 -- It will trigger the SLA Create Accounting Program
60 --
61 -- NOTES
62 --
63 -- HISTORY
64 -- 14-Sep-2010       BKUNJAN  Created   ER#9441192 ChRM-SLA Uptake
65 ---------------------------------------------------------------------
66 
67 PROCEDURE CreateAccounting(
68                             errbuf                      OUT NOCOPY VARCHAR2,
69 			    retcode                     OUT NOCOPY NUMBER,
70 
71 			    p_org_id                       IN NUMBER,
72 			    p_source_application_id        IN NUMBER,
73 			    p_application_id               IN NUMBER,
74 			    p_dummy                        IN VARCHAR2,
75 			    p_ledger_id                    IN NUMBER,
76 			    P_PROCESS_CATEGORY_CODE        IN VARCHAR2,
77 			    P_END_DATE                     IN VARCHAR2,
78 			    P_CREATE_ACCOUNTING_FLAG       IN VARCHAR2,
79 			    P_DUMMY_PARAM_1                IN VARCHAR2,
80 			    P_ACCOUNTING_MODE              IN VARCHAR2,
81 			    P_DUMMY_PARAM_2                IN VARCHAR2,
82 			    P_ERRORS_ONLY_FLAG             IN VARCHAR2,
83 			    P_REPORT_STYLE                 IN VARCHAR2,
84 			    P_TRANSFER_TO_GL_FLAG          IN VARCHAR2,
85 			    P_DUMMY_PARAM_3                IN VARCHAR2,
86 			    P_POST_IN_GL_FLAG              IN VARCHAR2,
87 			    P_GL_BATCH_NAME                IN VARCHAR2,
88 			    P_MIN_PRECISION                IN NUMBER,
89 			    P_INCLUDE_ZERO_AMOUNT_LINES    IN VARCHAR2,
90 			    P_REQUEST_ID                   IN NUMBER,
91 			    P_ENTITY_ID                    IN NUMBER,
92 			    P_SOURCE_APPLICATION_NAME      IN VARCHAR2,
93 			    P_APPLICATION_NAME             IN VARCHAR2,
94 			    P_LEDGER_NAME                  IN VARCHAR2,
95 			    P_PROCESS_CATEGORY_NAME        IN VARCHAR2,
96 			    P_CREATE_ACCOUNTING            IN VARCHAR2,
97 			    P_ACCOUNTING_MODE_NAME         IN VARCHAR2,
98 			    P_ERRORS_ONLY                  IN VARCHAR2,
99 			    P_ACCOUNTING_REPORT_LEVEL      IN VARCHAR2,
100 			    P_TRANSFER_TO_GL               IN VARCHAR2,
101 			    P_POST_IN_GL                   IN VARCHAR2,
102 			    P_INCLUDE_ZERO_AMT_LINES       IN VARCHAR2,
103 			    P_VALUATION_METHOD_CODE        IN VARCHAR2,
104 			    P_SECURITY_INT_1               IN NUMBER,
105 			    P_SECURITY_INT_2               IN NUMBER,
106 			    P_SECURITY_INT_3               IN NUMBER,
107 			    P_SECURITY_CHAR_1              IN VARCHAR2,
108 			    P_SECURITY_CHAR_2              IN VARCHAR2,
109 			    P_SECURITY_CHAR_3              IN VARCHAR2,
110 			    P_CONC_REQUEST_ID              IN NUMBER,
111 			    P_INCLUDE_USER_TRX_ID_FLAG     IN VARCHAR2,
112 			    P_INCLUDE_USER_TRX_IDENTIFIERS IN VARCHAR2,
113 			    P_DebugFlag                    IN VARCHAR2,
114 			    P_USER_ID                      IN NUMBER
115 			  );
116 
117 END OZF_GL_TRANSFER_PVT;