[Home] [Help]
PACKAGE: APPS.XLA_RPT_SARDLR_PKG
Source
1 PACKAGE XLA_RPT_SARDLR_PKG AUTHID CURRENT_USER AS
2 /* $Header: xlasardlr.pkh 120.0.12010000.4 2009/09/14 10:50:01 kapkumar noship $ */
3 /*======================================================================+
4 | Copyright (c) 2009-2010 Oracle Corporation |
5 | Redwood Shores, CA, USA |
6 | All rights reserved. |
7 +=======================================================================+
8 | PACKAGE NAME |
9 | xla_rpt_sardlr_pkg |
10 | |
11 | |
12 | DESCRIPTION |
13 | Package for Subledger Accounting Rules Detail Listing Report |
14 | to retrieve line-level information for ADR details |
15 | |
16 | HISTORY |
17 | AUG-09 Kapil Kumar Created |
18 | |
19 +======================================================================*/
20
21
22 --report input parameters declared as global variables:
23
24 P_APPLICATION_ID NUMBER;
25 P_SLAM_CODE VARCHAR2(250);
26 P_SLAM_TYPE_CODE VARCHAR2(250);
27 P_EVENT_CLASS_CODE VARCHAR2(250);
28 P_EVENT_TYPE_CODE VARCHAR2(250);
29 P_AMB_CONTEXT_CODE VARCHAR2(250);
30 P_EVENT_CLASS_NAME VARCHAR2(250);
31 P_EVENT_TYPE_NAME VARCHAR2(250);
32
33 P_APPLICATION_NAME VARCHAR2(250);
34 P_SLAM_NAME VARCHAR2(250);
35 P_SLAM_TYPE_NAME VARCHAR2(250);
36
37 FUNCTION beforeReport RETURN BOOLEAN;
38
39 FUNCTION populate_fields
40 (value_type_code IN VARCHAR2,
41 value_source_application_id IN NUMBER,
42 value_source_type_code IN VARCHAR2,
43 value_source_code IN VARCHAR2,
44 value_mapping_set_code IN VARCHAR2,
45 value_code_combination_id IN NUMBER,
46 amb_context_code IN VARCHAR2,
47 value_segment_rule_appl_id IN NUMBER,
48 value_segment_rule_type_code IN VARCHAR2,
49 value_segment_rule_code IN VARCHAR2,
50 flexfield_assign_mode_code IN VARCHAR2,
51 value_constant IN VARCHAR2,
52 flex_value_set_id IN NUMBER,
53 input_source_code IN VARCHAR2,
54 input_source_application_id IN NUMBER,
55 input_source_type_code IN VARCHAR2,
56 value_flexfield_segment_code IN VARCHAR2,
57 transaction_coa_id IN NUMBER,
58 accounting_coa_id IN NUMBER,
59 p_mode IN NUMBER
60 )
61 RETURN VARCHAR2;
62
63 END XLA_RPT_SARDLR_PKG;