[Home] [Help]
PACKAGE: APPS.XLA_CREATE_ACCT_RPT_PVT
Source
1 PACKAGE XLA_CREATE_ACCT_RPT_PVT AUTHID CURRENT_USER AS
2 -- $Header: xlaaprpt.pkh 120.5.12010000.3 2009/02/16 07:10:25 nksurana ship $
3 /*===========================================================================+
4 | Copyright (c) 2003 Oracle Corporation BelmFont, California, USA |
5 | ALL rights reserved. |
6 +============================================================================+
7 | FILENAME |
8 | |
9 | |
10 | PACKAGE NAME |
11 | xla_create_acct_rpt_pvt |
12 | |
13 | DESCRIPTION |
14 | Package specification.This provides XML extract for Create Accounting. |
15 | |
16 | HISTORY |
17 | 01/27/2006 V. Swapna Created |
18 | 02/16/2009 N. K. Surana Added new parameters to handle more than |
19 | 50 event classes per application for FSAH. |
20 +===========================================================================*/
21
22
23
24 --
25 -- To be used in query as bind variables
26 --
27 p_conc_request_id NUMBER;
28 p_application_id NUMBER;
29 p_ledger_id NUMBER;
30 p_process_category_code VARCHAR2(30);
31 p_end_date DATE;
32 p_create_accounting_flag VARCHAR2(1);
33 p_accounting_mode VARCHAR2(1);
34 p_errors_only_flag VARCHAR2(1);
35 p_report_style VARCHAR2(1);
36 p_transfer_to_gl_flag VARCHAR2(1);
37 p_post_in_gl_flag VARCHAR2(1);
38 p_gl_batch_name VARCHAR2(240);
39 p_min_precision NUMBER;
40 p_valuation_method_code VARCHAR2(30);
41 p_security_int_1 NUMBER;
42 p_security_int_2 NUMBER;
43 p_security_int_3 NUMBER;
44 p_security_char_1 VARCHAR2(30);
45 p_security_char_2 VARCHAR2(30);
46 p_security_char_3 VARCHAR2(30);
47 p_request_id NUMBER;
48 p_entity_id NUMBER;
49 p_source_application_id NUMBER;
50 p_dummy_param_1 VARCHAR2(240);
51 p_dummy_param_2 VARCHAR2(240);
52 p_dummy_param_3 VARCHAR2(240);
53 p_dummy VARCHAR2(240);
54 p_ledger_name VARCHAR2(240);
55 p_application_name VARCHAR2(240);
56 p_source_application_name VARCHAR2(240);
57 p_accounting_mode_name VARCHAR2(240);
58 p_process_category_name VARCHAR2(240);
59 p_accounting_report_level VARCHAR2(80);
60 p_create_accounting VARCHAR2(15);
61 p_errors_only VARCHAR2(15);
62 p_transfer_to_gl VARCHAR2(15);
63 p_post_in_gl VARCHAR2(15);
64 p_req_id NUMBER;
65 p_include_zero_amount_lines VARCHAR2(1);
66 p_include_zero_amt_lines VARCHAR2(15);
67 p_zero_amt_filter VARCHAR2(240) := ' ';
68 p_trx_identifiers VARCHAR2(32000) := ',NULL';
69 p_user_id NUMBER;
70 p_event_filter VARCHAR2(240) := ' ';
71 C_ACCT_PROG_RETURN_CODE NUMBER;
72 p_include_user_trx_id_flag VARCHAR2(1);
73 p_include_user_trx_identifiers VARCHAR2(15);
74 p_application_query VARCHAR2(2000);
75 p_group_id_str VARCHAR2(32000);
76
77 FUNCTION BeforeReport RETURN BOOLEAN ;
78 FUNCTION AfterReport RETURN BOOLEAN ;
79
80 --Added for bug 7580995
81 p_trx_identifiers_1 VARCHAR2(32000):= ' ';
82 p_trx_identifiers_2 VARCHAR2(32000):= ' ';
83 p_trx_identifiers_3 VARCHAR2(32000):= ' ';
84 p_trx_identifiers_4 VARCHAR2(32000):= ' ';
85 p_trx_identifiers_5 VARCHAR2(32000):= ' ';
86
87 END XLA_CREATE_ACCT_RPT_PVT;