[Home] [Help]
PACKAGE: APPS.XLA_PERIOD_CLOSE_EXP_PKG
Source
1 PACKAGE XLA_PERIOD_CLOSE_EXP_PKG AS
2 -- $Header: xlarppcl.pkh 120.9.12010000.1 2008/07/29 10:06:52 appldev ship $
3 /*===========================================================================+
4 | Copyright (c) 2003 Oracle Corporation BelmFont, California, USA |
5 | ALL rights reserved. |
6 +============================================================================+
7 | FILENAME |
8 | xlarppcl.pkh |
9 | |
10 | PACKAGE NAME |
11 | xla_period_close_exp_pkg |
12 | |
13 | DESCRIPTION |
14 | This package generates an XML extract for the Period Close Validation |
15 | program unit. A dynamic query is created based on the parameters that are |
16 | input and data template is used to generate XML. The extract is |
17 | called either when the user submits a concurrent request or when a General |
18 | Ledger Period is closed. |
19 | |
20 | HISTORY |
21 | 26/07/2005 VS Koushik Created |
22 | 15/02/2006 VamsiKrishna Kasina Changed the package to use |
23 | Data Template. |
24 +===========================================================================*/
25 --
26 -- To be used in query as bind variable
27 --
28
29 p_application_id NUMBER;
30 p_je_source VARCHAR2(80);
31 p_ledger_id NUMBER;
32 p_ledger VARCHAR2(30);
33 p_period_from VARCHAR2(30);
34 p_period_to VARCHAR2(30);
35 p_dummy_param_1 NUMBER;
36 p_event_class VARCHAR2(30);
37 p_event_class_code VARCHAR2(30);
38 p_dummy_param_2 NUMBER;
39 p_je_category VARCHAR2(30);
40 p_je_category_name VARCHAR2(30);
41 p_mode VARCHAR2(1);
42
43 p_je_source_name VARCHAR2(25);
44 p_object_type_code VARCHAR2(1);
45 C_RETURN_CODE NUMBER;
46 --p_trx_identifiers VARCHAR2(32000):= ' '; commented by preeti/6204675
47 --added by preeti/6204675
48 p_trx_identifiers_1 VARCHAR2(32000):= ' ';
49 p_trx_identifiers_2 VARCHAR2(32000):= ' ';
50 p_trx_identifiers_3 VARCHAR2(32000):= ' ';
51 p_trx_identifiers_4 VARCHAR2(32000):= ' ';
52 p_trx_identifiers_5 VARCHAR2(32000):= ' ';
53 -- end preeti/6204675
54
55 p_ledger_ids VARCHAR2(2000):= ' ';
56 p_event_filter VARCHAR2(2000):= ' ';
57
58 p_header_filter VARCHAR2(2000):= ' ';
59 p_je_source_filter VARCHAR2(2000):= ' ';
60
61 C_EVENTS_COLS_QUERY VARCHAR2(10000):= ' ';
62
63 C_EVENTS_FROM_QUERY VARCHAR2(10000):= ' ';
64
65 C_HEADERS_COLS_QUERY VARCHAR2(10000):= ' ';
66 C_HEADERS_FROM_QUERY VARCHAR2(10000):= ' ';
67
68
69 FUNCTION beforeReport RETURN BOOLEAN;
70
71 FUNCTION check_period_close(p_application_id IN NUMBER
72 ,p_period_name IN VARCHAR2
73 ,p_ledger_id IN NUMBER) RETURN NUMBER;
74
75 END xla_period_close_exp_pkg;