[Home] [Help]
PACKAGE BODY: APPS.JTF_DCF_AKWRAPPER
Source
1 PACKAGE BODY jtf_dcf_akwrapper AS
2 /* $Header: jtfbakwb.pls 115.4 2002/05/01 18:04:58 apandian ship $ */
3
4 ------------------------------------------------------------------------
5 --Created by : Hyun-Sik
6 --Date created: 20-NOV-2001
7 --
8 --Purpose:
9 -- This is a wrapper for ak apis
10 --
11 --Known limitations/enhancements and/or remarks:
12 --
13 --Change History: (who, when, what: NO CREATION RECORDS HERE!)
14 --Who When What
15 ------------------------------------------------------------------------
16
17 PROCEDURE DCF_CREATE_REGION_ITEM (
18 p_region_application_id IN ak_region_items.region_application_id%TYPE,
19 p_region_code IN ak_region_items.region_code%TYPE,
20 p_attribute_code IN ak_region_items.attribute_code%TYPE,
21 p_display_sequence IN ak_region_items.display_sequence%TYPE,
22 p_node_display_flag IN
23 ak_region_items.node_display_flag%TYPE DEFAULT 'Y',
24 p_flex_segment_list IN ak_region_items.flex_segment_list%TYPE
25 ) IS
26
27 CURSOR Check_Portaldata_Exist_C IS
28 SELECT 'Y'
29 FROM Ak_Region_Items
30 WHERE region_code = p_region_code
31 AND region_application_id = p_region_application_id
32 AND attribute_code = p_attribute_code
33 AND attribute_application_id = 690;
34
35 l_rowid VARCHAR2(200);
36 l_attribute_application_id ak_region_items.attribute_application_id%TYPE
37 := 690;
38 l_node_query_flag ak_region_items.node_query_flag%TYPE := 'N';
39 l_attribute_label_length ak_region_items.attribute_label_length%TYPE :=
40 0;
41 l_bold ak_region_items.bold%TYPE := 'N';
42 l_italic ak_region_items.italic%TYPE := 'N';
43 l_vertical_alignment ak_region_items.vertical_alignment%TYPE :=
44 'TOP';
45 l_horizontal_alignment ak_region_items.horizontal_alignment%TYPE :=
46 'LEFT';
47 l_item_style ak_region_items.item_style%TYPE := 'TEXT';
48 l_object_attribute_flag ak_region_items.object_attribute_flag%TYPE :=
49 'N';
50 l_update_flag ak_region_items.update_flag%TYPE := 'N';
51 l_required_flag ak_region_items.required_flag%TYPE := 'N';
52 l_display_value_length ak_region_items.display_value_length%TYPE :=
53 0;
54 l_submit ak_region_items.submit%TYPE := 'N';
55 l_encrypt ak_region_items.encrypt%TYPE := 'N';
56 l_admin_customizable ak_region_items.admin_customizable%TYPE :=
57 'Y';
58 l_creation_date ak_region_items.creation_date%TYPE := SYSDATE;
59 l_created_by ak_region_items.created_by%TYPE :=
60 FND_GLOBAL.USER_ID;
61 l_last_update_date ak_region_items.last_update_date%TYPE :=
62 SYSDATE;
63 l_last_updated_by ak_region_items.last_updated_by%TYPE :=
64 FND_GLOBAL.USER_ID;
65 l_last_update_login ak_region_items.last_update_login%TYPE :=
66 FND_GLOBAL.CONC_LOGIN_ID;
67 l_attribute_category ak_region_items.attribute_category%TYPE :=
68 'PORTLET_ELEMENT';
69 l_attribute1 ak_region_items.attribute1%TYPE := 'CONSTANT';
70 l_attribute6 ak_region_items.attribute6%TYPE := 'N';
71
72 l_record_exist VARCHAR2(1) := 'N';
73
74 BEGIN
75
76 OPEN Check_Portaldata_Exist_C;
77 FETCH Check_Portaldata_Exist_C INTO l_record_exist;
78 CLOSE Check_Portaldata_Exist_C;
79
80 IF (l_record_exist = 'N') THEN
81 AK_REGION_ITEMS_PKG.INSERT_ROW(
82 x_rowid => l_rowid,
83 x_region_application_id => p_region_application_id,
84 x_region_code => p_region_code,
85 x_attribute_application_id => l_attribute_application_id,
86 x_attribute_code => p_attribute_code,
87 x_display_sequence => p_display_sequence,
88 x_node_display_flag => p_node_display_flag,
89 x_node_query_flag => l_node_query_flag,
90 x_attribute_label_length => l_attribute_label_length,
91 x_bold => l_bold, -- 10
92 x_italic => l_italic,
93 x_vertical_alignment => l_vertical_alignment,
94 x_horizontal_alignment => l_horizontal_alignment,
95 x_item_style => l_item_style,
96 x_object_attribute_flag => l_object_attribute_flag,
97 x_attribute_label_long => NULL,
98 x_description => NULL,
99 x_security_code => NULL,
100 x_update_flag => l_update_flag,
101 x_required_flag => l_required_flag, -- 20
102 x_display_value_length => l_display_value_length,
103 x_lov_region_application_id => NULL,
104 x_lov_region_code => NULL,
105 x_lov_foreign_key_name => NULL,
106 x_lov_attribute_application_id => NULL,
107 x_lov_attribute_code => NULL,
108 x_lov_default_flag => NULL,
109 x_region_defaulting_api_pkg => NULL,
110 x_region_defaulting_api_proc => NULL,
111 x_region_validation_api_pkg => NULL, -- 30
112 x_region_validation_api_proc => NULL,
113 x_order_sequence => NULL,
114 x_order_direction => NULL,
115 x_default_value_varchar2 => NULL,
116 x_default_value_number => NULL,
117 x_default_value_date => NULL,
118 x_item_name => NULL,
119 x_display_height => NULL,
120 x_submit => l_submit,
121 x_encrypt => l_encrypt, -- 40
122 x_view_usage_name => NULL,
123 x_view_attribute_name => NULL,
124 x_css_class_name => NULL,
125 x_css_label_class_name => NULL,
126 x_url => NULL,
127 x_poplist_viewobject => NULL,
128 x_poplist_display_attribute => NULL,
129 x_poplist_value_attribute => NULL,
130 x_image_file_name => NULL,
131 x_nested_region_code => NULL, -- 50
132 x_nested_region_appl_id => NULL,
133 x_menu_name => NULL,
134 x_flexfield_name => NULL,
135 x_flexfield_application_id => NULL,
136 x_tabular_function_code => NULL,
137 x_tip_type => NULL,
138 x_tip_message_name => NULL,
139 x_tip_message_application_id => NULL,
140 x_flex_segment_list => p_flex_segment_list,
141 x_entity_id => NULL, -- 60
142 x_anchor => NULL,
143 x_poplist_view_usage_name => NULL,
144 x_user_customizable => NULL,
145 x_admin_customizable => l_admin_customizable,
146 x_invoke_function_name => NULL,
147 x_attribute_label_short => NULL,
148 x_expansion => NULL,
149 x_als_max_length => NULL,
150 x_sortby_view_attribute_name => NULL,
151 x_icx_custom_call => NULL, -- 70
152 x_initial_sort_sequence => NULL,
153 x_creation_date => l_creation_date,
154 x_created_by => l_created_by,
155 x_last_update_date => l_last_update_date,
156 x_last_updated_by => l_last_updated_by,
157 x_last_update_login => l_last_update_login,
158 x_attribute_category => l_attribute_category,
159 x_attribute1 => l_attribute1,
160 x_attribute2 => NULL,
161 x_attribute3 => NULL,
162 x_attribute4 => NULL,
163 x_attribute5 => NULL,
164 x_attribute6 => l_attribute6,
165 x_attribute7 => NULL,
166 x_attribute8 => NULL,
167 x_attribute9 => NULL,
168 x_attribute10 => NULL,
169 x_attribute11 => NULL,
170 x_attribute12 => NULL,
171 x_attribute13 => NULL,
172 x_attribute14 => NULL,
173 x_attribute15 => NULL);
174 END IF;
175
176 END DCF_CREATE_REGION_ITEM;
177 --
178 --
179 END jtf_dcf_akwrapper;