PACKAGE: APPS.FEM_DIM_HIER_LOADER_PKG

Source

1 PACKAGE Fem_Dim_Hier_Loader_Pkg AS
2 /* $Header: FEMDIMHIERLDR.pls 120.0 2006/05/23 07:31:57 kkulkarn noship $ */
3 
4   --------------------------------------------------------------------------------
5                            -- Declare all global variables --
6   --------------------------------------------------------------------------------
7 
8      g_log_level_1                CONSTANT  NUMBER      := fnd_log.level_statement;
9      g_log_level_2                CONSTANT  NUMBER      := fnd_log.level_procedure;
10      g_log_level_3                CONSTANT  NUMBER      := fnd_log.level_event;
11      g_log_level_4                CONSTANT  NUMBER      := fnd_log.level_exception;
12      g_log_level_5                CONSTANT  NUMBER      := fnd_log.level_error;
13      g_log_level_6                CONSTANT  NUMBER      := fnd_log.level_unexpected;
14 
15      g_block     	                CONSTANT VARCHAR2(30) := 'FEM_DIM_HIER_LOADER_PKG';
16 
17      c_false                      CONSTANT  VARCHAR2(1)  := fnd_api.g_false;
18      c_true                       CONSTANT  VARCHAR2(1)  := fnd_api.g_true;
19      c_success                    CONSTANT  VARCHAR2(1)  := fnd_api.g_ret_sts_success;
20      c_error                      CONSTANT  VARCHAR2(1)  := fnd_api.g_ret_sts_error;
21      c_unexp                      CONSTANT  VARCHAR2(1)  := fnd_api.g_ret_sts_unexp_error;
22      c_api_version                CONSTANT  NUMBER       := 1.0;
23 
24      c_interval                   CONSTANT  NUMBER       := 3.0;
25      c_max_wait_time              CONSTANT  NUMBER       := 1200.0;
26 
27      c_dim_loader                 CONSTANT  VARCHAR2(10) := 'DIMENSIONS';
28      c_hier_loader                CONSTANT  VARCHAR2(15) := 'HIERARCHIES';
29 
30   --------------------------------------------------------------------------------
31                            -- Declare all pl/sql collections --
32   --------------------------------------------------------------------------------
33 
34      TYPE number_table IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
35      TYPE char_table IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;
36 
37   --------------------------------------------------------------------------------
38                          -- Declare all Public procedures/functions --
39   --------------------------------------------------------------------------------
40 
41 
42      PROCEDURE process_request(errbuf OUT NOCOPY VARCHAR2,
43                                retcode OUT NOCOPY VARCHAR2,
44                                p_obj_def_id IN NUMBER);
45 
46 
47 END Fem_Dim_Hier_Loader_Pkg;