PACKAGE: APPS.FEM_INTG_DIM_RULE_ENG_PKG

Source

1 PACKAGE fem_intg_dim_rule_eng_pkg AS
2 /* $Header: fem_intg_dim_eng.pls 120.1 2006/01/17 00:44:19 gnayyar noship $ */
3   pv_dim_rule_obj_id                   NUMBER(9);
4   pv_dim_rule_obj_def_id               NUMBER(9);
5   pv_dim_id                            NUMBER(9);
6   pv_dim_varchar_label                 VARCHAR2(30);
7   pv_member_b_table_name               VARCHAR2(30);
8   pv_member_tl_table_name              VARCHAR2(30);
9   pv_member_vl_object_name             VARCHAR2(30);
10   pv_member_col                        VARCHAR2(30);
11   pv_cctr_org_member_col               VARCHAR2(30);
12   pv_member_display_code_col           VARCHAR2(30);
13   pv_member_name_col                   VARCHAR2(30);
14   pv_member_desc_col                   VARCHAR2(30);
15   pv_attr_table_name                   VARCHAR2(30);
16   pv_coa_id                            NUMBER(10);
17   pv_coa_name                          VARCHAR2(30);
18   pv_com_vs_id                         NUMBER;
19   pv_cc_vs_id                          NUMBER;
20   pv_gvsc_id                           NUMBER(9);
21   pv_fem_vs_id                         NUMBER;
22   pv_ledger_attr_varchar_label         VARCHAR2(30);
23   pv_com_dim_id                        NUMBER(9);
24   pv_cc_dim_id                         NUMBER(9);
25   pv_cctr_org_dim_id                   NUMBER(9);
26   pv_fin_element_dim_id                NUMBER(9);
27   pv_dim_mapping_option_code           VARCHAR2(10);
28   pv_default_member_id                 NUMBER;
29   pv_default_member_vs_id              NUMBER;
30   pv_fin_element_vs_id                 NUMBER;
31   pv_segment_count                     NUMBER;
32   pv_source_system_code_id             NUMBER;
33   pv_max_ccid_processed                NUMBER;
34   pv_max_ccid_to_be_mapped             NUMBER;
35   pv_max_ccid_in_map_table             NUMBER;
36   pv_max_flex_value_id_processed       NUMBER;
37   pv_req_id                            NUMBER;
38   pv_user_id                           NUMBER;
39   pv_login_id                          NUMBER;
40   pv_pgm_id                            NUMBER;
41   pv_pgm_app_id                        NUMBER;
42   pv_folder_id                         NUMBER(9);
43   pv_ext_acct_type_attr_id             NUMBER;
44   pv_ext_acct_attr_version_id          NUMBER;
45   pv_summary_flag                      VARCHAR2(1);
46   pv_balancing_segment_num             NUMBER;
47   pv_cost_center_segment_num           NUMBER;
48   pv_natural_account_segment_num       NUMBER;
49 
50   TYPE map_seg_info IS RECORD(
51     application_column_name     VARCHAR2(30),
52     vs_id                       NUMBER(10),
53     table_validated_flag        VARCHAR2(1),
54     table_name                  VARCHAR2(30),
55     id_col_name                VARCHAR2(240),
56     val_col_name                VARCHAR2(240),
57     compiled_attr_col_name      VARCHAR2(240),
58     meaning_col_name            VARCHAR2(240),
59     where_clause                VARCHAR2(4000),
60     dependent_value_set_flag    VARCHAR2(1),
61     dependent_vs_id             NUMBER,
62     dependent_segment_column    VARCHAR2(30)
63   );
64 
65   TYPE mapped_segments is VARRAY(5) OF map_seg_info;
66 
67   pv_mapped_segs mapped_segments := mapped_segments();
68 
69 
70   PROCEDURE Init;
71 
72   PROCEDURE main(
73     x_errbuf OUT NOCOPY  VARCHAR2,
74     x_retcode OUT NOCOPY VARCHAR2,
75     p_dim_rule_obj_def_id IN NUMBER,
76     p_execution_mode IN VARCHAR2
77   );
78 
79   PROCEDURE UNDO_DIM_RULE(
80     x_errbuf OUT NOCOPY VARCHAR2,
81     x_retcode OUT NOCOPY VARCHAR2,
82     p_dim_rule_obj_id IN NUMBER
83   );
84 
85 END;