PACKAGE: APPS.FEM_INTG_HIER_RULE_ENG_PKG

Source

1 PACKAGE FEM_INTG_HIER_RULE_ENG_PKG AS
2 /* $Header: fem_intg_hir_eng.pls 120.1 2005/09/01 11:10:37 appldev noship $ */
3 
4 /***********************************************************************
5  *              PACKAGE VARIABLES                                      *
6  ***********************************************************************/
7 
8   pv_hier_rule_obj_id      NUMBER;
9   pv_hier_rule_obj_def_id  NUMBER;
10   pv_coa_id                NUMBER;
11   pv_dim_id                NUMBER;
12   pv_dim_vs_id             NUMBER;
13   pv_aol_vs_id             NUMBER;
14   pv_dim_memb_vl_obj       VARCHAR2(30);
15   pv_dim_memb_tl_tab       VARCHAR2(30);
16   pv_dim_memb_b_tab        VARCHAR2(30);
17   pv_dim_memb_col          VARCHAR2(30);
18   pv_dim_memb_disp_col     VARCHAR2(30);
19   pv_dim_memb_name_col     VARCHAR2(30);
20   pv_dim_memb_desc_col     VARCHAR2(30);
21   pv_dim_hier_tab          VARCHAR2(30);
22   pv_dim_attr_tab          VARCHAR2(30);
23 
24   pv_dim_rule_obj_def_id   NUMBER;
25   pv_dim_rule_obj_id       NUMBER;
26 
27   pv_segment_count         NUMBER;
28   pv_top_parent_disp_code  VARCHAR2(30);
29   pv_top_parent_id         NUMBER;
30   pv_new_obj_def_needed    BOOLEAN;
31   pv_gvsc_id               NUMBER;
32   -- AGB =============================================================
33 /***********************************************************************
34  *              PL/SQL TABLE                                           *
35  ***********************************************************************/
36   TYPE r_hier_traversal IS RECORD (
37          display_order           number,
38          top_parent_value        VARCHAR2 (150),
39          top_parent_id           number,
40          aol_vs_id               number,
41          concat_segment          number);
42 
43   TYPE tr_hier_traversal IS TABLE OF r_hier_traversal;
44 
45   pv_traversal_rarray   tr_hier_traversal := tr_hier_traversal();
46   pv_hier_obj_def_id           NUMBER;
47 
48   -- AGB END =============================================================
49 
50 
51 /*****************************************************************
52  *              PUBLIC PROCEDURES                                *
53  *****************************************************************/
54 
55 -- ======================================================================
56 -- Procedure
57 --     Main
58 -- Purpose
59 --     This routine is the Main of the FEM_INTG_HIER_RULE_ENG_PKG
60 --  History
61 --     10-28-04  Jee Kim  Created
62 -- Arguments
63 --     x_errbuf                   Standard Concurrent Program parameter
64 --     x_retcode                  Standard Concurrent Program parameter
65 --     p_hier_rule_obj_def_id     Hierarchy rule version ID
66 --     p_new_version_flag         Indicates if a new version of the hierarchy
67 --                                structure should be created
68 -- ======================================================================
69 
70   PROCEDURE Main (x_errbuf OUT NOCOPY  VARCHAR2,
71                 x_retcode OUT NOCOPY VARCHAR2,
72                 p_hier_rule_obj_def_id IN NUMBER);
73 
74 END FEM_INTG_HIER_RULE_ENG_PKG;