[Home] [Help]
PACKAGE: APPS.EC_MAPPING_UTILS
Source
1 PACKAGE ec_mapping_utils AUTHID CURRENT_USER AS
2 -- $Header: ECMAPUTS.pls 120.3 2005/09/29 10:50:12 arsriniv ship $
3
4 FUNCTION ec_get_map_id(
5 xMapCode IN ece_mappings.map_code%TYPE,
6 xUpgradeFlag IN VARCHAR2 DEFAULT 'N') RETURN NUMBER;
7
8 FUNCTION ec_get_map_code(
9 xMap_ID IN NUMBER,
10 xUpgradeFlag IN VARCHAR2 DEFAULT 'N') RETURN ece_mappings.map_code%TYPE;
11
12 FUNCTION ec_get_upgrade_map_id(
13 xMap_ID IN NUMBER) RETURN NUMBER;
14
15 FUNCTION ec_get_main_map_id(
16 xMap_ID NUMBER) RETURN NUMBER;
17
18 FUNCTION ec_get_trans_upgrade_status(
19 xTransactionType IN ece_interface_tables.transaction_type%TYPE,
20 iMapId IN ece_interface_tables.map_id%TYPE) RETURN VARCHAR2;
21
22 FUNCTION ec_get_trans_upgrade_status(
23 xTransactionType IN ece_interface_tables.transaction_type%TYPE) RETURN VARCHAR2;
24
25 PROCEDURE ec_upgrade_column_rules(
26 xInterface_Column_ID_Main IN NUMBER,
27 xInterface_Column_ID_Upg IN NUMBER);
28
29 PROCEDURE ec_upgrade_layout(
30 xMap_ID_Upg IN NUMBER,
31 xUpgrade_Column_Rules_Flag IN VARCHAR2,
32 xUpgrade_Code_Cat_Flag IN VARCHAR2);
33
34 PROCEDURE ec_upgrade_process_rules(
35 xMap_ID IN NUMBER); --Upgrade Table Map_ID
36
37 PROCEDURE ec_copy_column_rules(
38 xMap_ID IN NUMBER);
39
40 PROCEDURE ec_copy_dynamic_actions(
41 xMap_ID IN NUMBER);
42
43 PROCEDURE ec_copy_external_levels(
44 xMap_ID IN NUMBER);
45
46 PROCEDURE ec_copy_interface_columns(
47 xMap_ID IN NUMBER);
48
49 PROCEDURE ec_copy_interface_tables(
50 xMap_ID IN NUMBER);
51
52 PROCEDURE ec_copy_level_matrices(
53 xMap_ID IN NUMBER);
54
55 PROCEDURE ec_copy_mappings(
56 xMap_ID IN NUMBER);
57
58 PROCEDURE ec_copy_process_rules(
59 xMap_ID IN NUMBER);
60
61 PROCEDURE ec_copy_map_data_by_mapcode(
62 xMapCode IN ece_mappings.map_code%TYPE);
63
64 PROCEDURE ec_copy_map_data_by_mapid(
65 xMap_ID IN NUMBER);
66
67 PROCEDURE ec_copy_map_data_by_trans(
68 xTransactionType IN ece_interface_tables.transaction_type%TYPE,
69 xMapType IN ece_mappings.map_type%TYPE);
70
71 PROCEDURE ec_delete_column_rules(
72 xMap_ID IN NUMBER,
73 xUpgradeFlag IN VARCHAR2 DEFAULT 'N');
74
75 PROCEDURE ec_delete_dynamic_action(
76 xMap_ID IN NUMBER,
77 xUpgradeFlag IN VARCHAR2 DEFAULT 'N');
78
79 PROCEDURE ec_delete_external_levels(
80 xMap_ID IN NUMBER,
81 xUpgradeFlag IN VARCHAR2 DEFAULT 'N');
82
83 PROCEDURE ec_delete_interface_columns(
84 xMap_ID IN NUMBER,
85 xUpgradeFlag IN VARCHAR2 DEFAULT 'N');
86
87 PROCEDURE ec_delete_interface_tables(
88 xMap_ID IN NUMBER,
89 xUpgradeFlag IN VARCHAR2 DEFAULT 'N');
90
91 PROCEDURE ec_delete_level_matrices(
92 xMap_ID IN NUMBER,
93 xUpgradeFlag IN VARCHAR2 DEFAULT 'N');
94
95 PROCEDURE ec_delete_mappings(
96 xMap_ID IN NUMBER,
97 xUpgradeFlag IN VARCHAR2 DEFAULT 'N');
98
99 PROCEDURE ec_delete_process_rules(
100 xMap_ID IN NUMBER,
101 xUpgradeFlag IN VARCHAR2 DEFAULT 'N');
102
103 PROCEDURE ec_delete_map_data_by_mapcode(
104 xMapCode IN ece_mappings.map_code%TYPE,
105 xUpgradeFlag IN VARCHAR2 DEFAULT 'N');
106
107 PROCEDURE ec_delete_map_data_by_mapid(
108 xMap_ID IN NUMBER,
109 xUpgradeFlag IN VARCHAR2 DEFAULT 'N');
110
111 PROCEDURE ec_delete_map_data_by_trans(
112 xTransactionType IN ece_interface_tables.transaction_type%TYPE,
113 xMapType IN ece_mappings.map_type%TYPE,
114 xUpgradeFlag IN VARCHAR2 DEFAULT 'N');
115
116 PROCEDURE ec_migrate_map_to_production(
117 xMapCode IN ece_mappings.map_code%TYPE,
118 xTransExists IN BOOLEAN);
119
120 PROCEDURE ec_reconcile_seed(
121 errbuf OUT NOCOPY VARCHAR2,
122 retcode OUT NOCOPY VARCHAR2,
123 transaction_type IN VARCHAR2,
124 preserve_layout IN VARCHAR2,
125 preserve_proc_rules IN VARCHAR2,
126 preserve_col_rules IN VARCHAR2,
127 preserve_cc_cat IN VARCHAR2,
128 v_debug_mode IN NUMBER DEFAULT 3);
129
130 PROCEDURE ec_remap_tp_details(
131 xMap_ID IN NUMBER); --Upgrade Table Map_ID
132
133 END;
134