DBA Data[Home] [Help]

PACKAGE: APPS.XLA_TB_DEFN_DETAIL_PVT

Source


1 PACKAGE XLA_TB_DEFN_DETAIL_PVT AUTHID CURRENT_USER AS
2 /* $Header: xlathtbdtl.pkh 120.0 2005/10/07 12:12:45 svjoshi noship $   */
3 /*===========================================================================+
4 |             Copyright (c) 2001-2002 Oracle Corporation                     |
5 |                       Redwood Shores, CA, USA                              |
6 |                         All rights reserved.                               |
7 +============================================================================+
8 | PACKAGE NAME                                                               |
9 |     xla_tb_definition_PVT                                                  |
10 |                                                                            |
11 | DESCRIPTION                                                                |
12 |     This is a XLA package, which contains all the logic required           |
13 |     to maintain trial balance report definitions                           |
14 |                                                                            |
15 |                                                                            |
16 | HISTORY                                                                    |
17 |     17-AUG-2005 M.Asada    Created                                         |
18 +===========================================================================*/
19 
20 --
21 --
22 --+==========================================================================+
23 --|                                                                          |
24 --| PUBLIC PROCEDURE                                                         |
25 --|                                                                          |
26 --|   Create a trial balance report definition if not exist.                 |
27 --|   If exists, update attributes of the definition.                        |
28 --|                                                                          |
29 --+==========================================================================+
30 --
31 --
32 PROCEDURE Load_Row
33         (p_definition_code           IN VARCHAR2
34         ,p_object_version_number     IN NUMBER
35         ,p_code_combination_id       IN NUMBER
36         ,p_flexfield_segment_code    IN VARCHAR2
37         ,p_segment_value_from        IN VARCHAR2
38         ,p_segment_value_to          IN VARCHAR2
39         ,p_last_update_date          IN VARCHAR2
40         ,p_owner                     IN VARCHAR2
41         ,p_custom_mode               IN VARCHAR2);
42 
43 --
44 --
45 --+==========================================================================+
46 --|                                                                          |
47 --| PUBLIC PROCEDURE                                                         |
48 --|                                                                          |
49 --|   Create trial balance report definition details                         |
50 --|                                                                          |
51 --|                                                                          |
52 --+==========================================================================+
53 --
54 --
55 PROCEDURE Insert_Row
56         (p_rowid                     IN OUT NOCOPY VARCHAR2
57         ,p_definition_code           IN VARCHAR2
58         ,p_object_version_number     IN NUMBER
59         ,p_code_combination_id       IN NUMBER
60         ,p_flexfield_segment_code    IN VARCHAR2
61         ,p_segment_value_from        IN VARCHAR2
62         ,p_segment_value_to          IN VARCHAR2
63         ,p_creation_date             IN DATE
64         ,p_created_by                IN NUMBER
65         ,p_last_update_date          IN DATE
66         ,p_last_updated_by           IN NUMBER
67         ,p_last_update_login         IN NUMBER);
68 
69 --
70 --
71 --+==========================================================================+
72 --|                                                                          |
73 --| PUBLIC PROCEDURE                                                         |
74 --|                                                                          |
75 --|   Update trial balance report definition details                         |
76 --|                                                                          |
77 --|                                                                          |
78 --+==========================================================================+
79 --
80 --
81 -- No Update API for this table. Delete and recreate rows.
82 --
83 
84 
85 --
86 --
87 --+==========================================================================+
88 --|                                                                          |
89 --| PUBLIC PROCEDURE                                                         |
90 --|                                                                          |
91 --|   Delete trial balance report definition details                         |
92 --|   (Defined by Flexfield)                                                 |
93 --|                                                                          |
94 --+==========================================================================+
95 --
96 --
97 PROCEDURE Delete_Row
98          (p_definition_code           IN VARCHAR2
99          ,p_code_combination_id       IN NUMBER);
100 
101 --
102 --
103 --+==========================================================================+
104 --|                                                                          |
105 --| PUBLIC PROCEDURE                                                         |
106 --|                                                                          |
107 --|   Delete trial balance report definition details                         |
108 --|   (Defined by Segment)                                                 |
109 --|                                                                          |
110 --+==========================================================================+
111 --
112 --
113 PROCEDURE Delete_Row
114          (p_definition_code           IN VARCHAR2
115          ,p_flexfield_segment_code    IN VARCHAR2
116          ,p_segment_value_from        IN VARCHAR2);
117 
118 END XLA_TB_DEFN_DETAIL_PVT; -- end of package spec