DBA Data[Home] [Help]

APPS.PSP_ENC_CRT_XML dependencies on FND_PROFILE

Line 71: fnd_profile.get('ICX_DATE_FORMAT_MASK', g_icx_date_mask);

67:
68: function CF_run_dateFormula return varchar2 is
69: l_run_date varchar2(20);
70: begin
71: fnd_profile.get('ICX_DATE_FORMAT_MASK', g_icx_date_mask);
72: l_run_date := to_char(sysdate, g_icx_date_mask);
73: return (l_run_date);
74: end;
75:

Line 115: fnd_profile.get('ICX_DATE_FORMAT_MASK', g_icx_date_mask);

111: elsif l_sched_rec.lookup_code = 'ET' then
112: G_asg_element := ''''|| l_sched_rec.meaning || '''';
113: end if;
114: end loop;
115: fnd_profile.get('ICX_DATE_FORMAT_MASK', g_icx_date_mask);
116: g_icx_date_mask := ''''|| g_icx_date_mask ||'''';
117: return true;
118: end;
119:

Line 130: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_date_mask);

126: and action_type = 'R'
127: and action_status = 'C';
128: l_date_earned varchar2(20);
129: begin
130: fnd_profile.get('ICX_DATE_FORMAT_MASK', l_date_mask);
131: open get_date_earned;
132: fetch get_date_earned into l_date_earned;
133: close get_date_earned;
134: return l_date_earned;