[Home] [Help]
PACKAGE: APPS.OKC_UDA_TEMPLATES_UTIL
Source
1 PACKAGE okc_uda_templates_util AUTHID CURRENT_USER AS
2 /* $Header: OKCVUDATUTLS.pls 120.0.12020000.3 2013/05/20 10:52:15 kkolukul noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL CONSTANTS
5 ---------------------------------------------------------------------------
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'okc_uda_templates_util';
7 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKC';
8 G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||G_PKG_NAME||'.';
9
10 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
11 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
12 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
13
14 PROCEDURE UPLOAD_ACTIONS
15 (
16 p_attr_grp_type VARCHAR2,
17 p_action_name VARCHAR2,
18 p_classification_code VARCHAR2,
19 p_attr_grp_internal_name VARCHAR2,
20 p_object_name VARCHAR2,
21 p_sequence NUMBER,
22 p_function_name VARCHAR2,
23 p_description VARCHAR2,
24 p_owner VARCHAR2
25 );
26
27 PROCEDURE UPLOAD_ACTIONS_NLS
28 (
29 p_attr_grp_type VARCHAR2,
30 p_action_name VARCHAR2,
31 p_classification_code VARCHAR2,
32 p_attr_grp_internal_name VARCHAR2,
33 p_object_name VARCHAR2,
34 p_sequence NUMBER,
35 p_function_name VARCHAR2,
36 p_description VARCHAR2,
37 p_owner VARCHAR2
38 );
39
40
41 PROCEDURE UPLOAD_ACTION_DL
42 (
43 p_attr_grp_type VARCHAR2,
44 p_action_name VARCHAR2,
45 p_classification_code VARCHAR2,
46 p_attr_grp_internal_name VARCHAR2,
47 p_data_level VARCHAR2,
48 p_visibility_flag VARCHAR2,
49 p_owner VARCHAR2
50 );
51
52 PROCEDURE UPLOAD_ACTION_DISPLAYS
53 (
54 p_attr_grp_type VARCHAR2,
55 p_action_name VARCHAR2,
56 p_function_name VARCHAR2,
57 p_object_name VARCHAR2,
58 p_attr_grp_internal_name VARCHAR2,
59 p_classification_code VARCHAR2,
60 p_exec_method VARCHAR2,
61 p_exec_trigger VARCHAR2,
62 p_display_style VARCHAR2,
63 p_app_short_name VARCHAR2,
64 p_prompt_message_name VARCHAR2,
65 p_visibility_flag VARCHAR2,
66 p_owner VARCHAR2
67 );
68
69 PROCEDURE UPLOAD_FUNCTION_MAPPINGS
70 (
71 p_attr_grp_type VARCHAR2,
72 p_action_name VARCHAR2,
73 p_function_name VARCHAR2,
74 p_object_name VARCHAR2,
75 p_attr_grp_internal_name VARCHAR2,
76 p_classification_code VARCHAR2,
77 p_map_par_int_name VARCHAR2,
78 p_map_app_short_name VARCHAR2,
79 p_map_obj_type VARCHAR2,
80 p_map_to_grp_type VARCHAR2,
81 p_map_ext_attrs VARCHAR2,
82 p_map_context VARCHAR2,
83 p_map_attr VARCHAR2,
84 p_owner VARCHAR2
85 );
86
87 PROCEDURE copy_associations(p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2,
89 p_commit IN VARCHAR2,
90 p_new_template_code IN VARCHAR2,
91 p_src_template_code IN NUMBER,
92 p_object_id IN NUMBER,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2);
96
97 PROCEDURE copy_uda_actions(p_api_version IN NUMBER,
98 p_init_msg_list IN VARCHAR2,
99 p_commit IN VARCHAR2,
100 p_attr_group_id IN VARCHAR2,
101 p_new_template_code IN VARCHAR2,
102 p_src_template_code IN NUMBER,
103 p_object_id IN NUMBER,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2);
107
108 PROCEDURE copy_pages (p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2,
110 p_commit IN VARCHAR2,
111 p_new_template_code IN VARCHAR2,
112 p_src_template_code IN NUMBER,
113 p_object_id IN NUMBER,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2);
117
118 PROCEDURE copy_template_details(p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2,
120 p_commit IN VARCHAR2,
121 p_src_uda_temp_id IN NUMBER,
122 p_new_uda_temp_id IN NUMBER,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2
126 ) ;
127
128
129 FUNCTION is_template_freezed(p_uda_template_id IN NUMBER )
130 RETURN VARCHAR2;
131
132 PROCEDURE delete_temp_details(p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2,
134 p_commit IN VARCHAR2,
135 p_uda_temp_id IN NUMBER,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2
139 ) ;
140
141 END OKC_UDA_TEMPLATES_UTIL;