APPS.BEN_BENXLAYT_XMLP_PKG dependencies on FND_GLOBAL

Line 42: l_return := l_function || ' all ' || fnd_global.local_chr(10);

38: fetch get_function into l_function;
39: close get_function;
40: end if;
41: if total_function = 'CNT' then
42: l_return := l_function || ' all ' || fnd_global.local_chr(10);
43: if condition_data_element is not null then
44: FOR where_clause IN get_where_clause(ext_data_element) LOOP
45: open get_data_element(where_clause.cond_ext_data_elmt_id);
46: fetch get_data_element into l_cond_data_elmt;

Line 51: || fnd_global.local_chr(10);

47: close get_data_element;
48: l_where_flag := TRUE ;
49: l_where_clause := l_where_clause || l_cond_data_elmt || ' ' || hr_general.decode_lookup('BEN_EXT_OPER',where_clause.oper_cd)
50: || ' ' || where_clause.val || ' ' || hr_general.decode_lookup('BEN_EXT_AND_OR',where_clause.and_or_cd)
51: || fnd_global.local_chr(10);
52: END LOOP;
53:
54: if l_where_flag then
55: l_return := l_return || ' where ' || l_where_clause;

Line 64: l_return := l_function || ' ' || l_sum_data_elmt || fnd_global.local_chr(10);

60:
61: open get_data_element(sum_data_element);
62: fetch get_data_element into l_sum_data_elmt;
63: close get_data_element;
64: l_return := l_function || ' ' || l_sum_data_elmt || fnd_global.local_chr(10);
65: if condition_data_element is not null then
66: FOR where_clause IN get_where_clause(ext_data_element) LOOP
67: open get_data_element(where_clause.cond_ext_data_elmt_id);
68: fetch get_data_element into l_cond_data_elmt;

Line 73: || fnd_global.local_chr(10);

69: close get_data_element;
70: l_where_flag := TRUE ;
71: l_where_clause := l_where_clause || l_cond_data_elmt || ' ' || hr_general.decode_lookup('BEN_EXT_OPER',where_clause.oper_cd)
72: || ' ' || where_clause.val || ' ' || hr_general.decode_lookup('BEN_EXT_AND_OR',where_clause.and_or_cd)
73: || fnd_global.local_chr(10);
74: END LOOP;
75:
76: if l_where_flag then
77: l_return := l_return || ' where ' || l_where_clause;