APPS.OKC_CDRL_DT_PKG dependencies on EGO_USER_ATTRS_DATA_PVT

Line 20: l_sql := ' EGO_USER_ATTRS_DATA_PVT.Get_Attr_Disp_Val_From_VSet ( ' ||

16: l_sql varchar2(1000);
17: begin
18:
19: if (p_data_type = 'C' or p_data_type = 'A' ) then
20: l_sql := ' EGO_USER_ATTRS_DATA_PVT.Get_Attr_Disp_Val_From_VSet ( ' ||
21: p_application_id || ',' || ' null, ' ||
22: p_appl_col_name|| ', null , ''' ||
23: p_end_user_col_name|| ''',''' ||
24: p_attr_group_type || ''',''' ||

Line 31: l_sql := ' EGO_USER_ATTRS_DATA_PVT.Get_Attr_Disp_Val_From_VSet ( ' ||

27: p_object_name || ''',''' ||
28: p_pk1_column_name || ''',' ||
29: p_delID || ') as ' || p_end_user_col_name || '_DESC' ;
30: elsif p_data_type = 'N' then
31: l_sql := ' EGO_USER_ATTRS_DATA_PVT.Get_Attr_Disp_Val_From_VSet ( ' ||
32: p_application_id || ',' || ' null, null, ' ||
33: p_appl_col_name|| ', ''' ||
34: p_end_user_col_name|| ''',''' ||
35: p_attr_group_type || ''',''' ||

Line 42: l_sql := ' EGO_USER_ATTRS_DATA_PVT.Get_Attr_Disp_Val_From_VSet ( ' ||

38: p_object_name || ''',''' ||
39: p_pk1_column_name || ''',' ||
40: p_delID || ') as ' || p_end_user_col_name || '_DESC' ;
41: elsif (p_data_type = 'X' or p_data_type = 'Y') then
42: l_sql := ' EGO_USER_ATTRS_DATA_PVT.Get_Attr_Disp_Val_From_VSet ( ' ||
43: p_application_id || ',' || p_appl_col_name ||
44: ' , null, null, ''' ||
45: p_end_user_col_name|| ''',''' ||
46: p_attr_group_type || ''',''' ||

Line 239: l_result := EGO_USER_ATTRS_DATA_PVT.Get_Attr_Disp_Val_From_VSet (

235: EXECUTE immediate l_sql INTO l_res_code USING p_delId, l_attr_group_id ;
236:
237:
238: if (l_data_type = 'C' or l_data_type = 'A') then
239: l_result := EGO_USER_ATTRS_DATA_PVT.Get_Attr_Disp_Val_From_VSet (
240: p_application_id => l_application_id,
241: p_attr_internal_date_value => null,
242: p_attr_internal_str_value => l_res_code,
243: p_attr_internal_num_value => null,

Line 253: l_result := EGO_USER_ATTRS_DATA_PVT.Get_Attr_Disp_Val_From_VSet (

249: p_pk1_column_name => l_pk1_column_name,
250: p_pk1_value => p_delId
251: );
252: elsif (l_data_type = 'N') then
253: l_result := EGO_USER_ATTRS_DATA_PVT.Get_Attr_Disp_Val_From_VSet (
254: p_application_id => l_application_id,
255: p_attr_internal_date_value => null,
256: p_attr_internal_str_value => null,
257: p_attr_internal_num_value => l_res_code,

Line 267: l_result := EGO_USER_ATTRS_DATA_PVT.Get_Attr_Disp_Val_From_VSet (

263: p_pk1_column_name => l_pk1_column_name,
264: p_pk1_value => p_delId
265: );
266: elsif (l_data_type = 'X' or l_data_type ='Y') then
267: l_result := EGO_USER_ATTRS_DATA_PVT.Get_Attr_Disp_Val_From_VSet (
268: p_application_id => l_application_id,
269: p_attr_internal_date_value => l_res_code,
270: p_attr_internal_str_value => null,
271: p_attr_internal_num_value => null,