APPS.FF_EXEC dependencies on FND_DATE

Line 505: value := fnd_date.date_to_canonical( p_ctx_info(i).dvalue );

501:
502: value := '';
503: if p_ctx_info(i).data_type = C_DATE then
504: if p_ctx_info(i).dvalue is not null then
505: value := fnd_date.date_to_canonical( p_ctx_info(i).dvalue );
506: end if;
507: elsif p_ctx_info(i).data_type = C_NUMBER then
508: if p_ctx_info(i).nvalue is not null then
509: value := replace(to_char(p_ctx_info(i).nvalue), g_decpoint, '.');

Line 541: value := fnd_date.date_to_canonical( p_dbi_info(i).dvalue );

537:
538: value := null;
539: if p_dbi_info(i).indicator = FF_NOT_NULL then
540: if p_dbi_info(i).data_type = C_DATE then
541: value := fnd_date.date_to_canonical( p_dbi_info(i).dvalue );
542: elsif p_dbi_info(i).data_type = C_NUMBER then
543: value := replace(to_char(p_dbi_info(i).nvalue), g_decpoint, '.');
544: else
545: value := p_dbi_info(i).tvalue;

Line 627: value := fnd_date.date_to_canonical( p_dbi_info.dvalue );

623:
624: value := null;
625: if p_dbi_info.indicator = FF_NOT_NULL then
626: if p_dbi_info.data_type = C_DATE then
627: value := fnd_date.date_to_canonical( p_dbi_info.dvalue );
628: elsif p_dbi_info.data_type = C_NUMBER then
629: value := replace(to_char(p_dbi_info.nvalue), g_decpoint, '.');
630: else
631: value := p_dbi_info.tvalue;

Line 2214: fnd_date.canonical_to_date(l_tvalue);

2210: -- cache.
2211: --
2212: if l_data_type = C_DATE then
2213: p_ctx_info(l_context_id).dvalue :=
2214: fnd_date.canonical_to_date(l_tvalue);
2215: elsif l_data_type = C_NUMBER then
2216: p_ctx_info(l_context_id).nvalue := replace(l_tvalue, '.', g_decpoint);
2217: end if;
2218:

Line 2250: l_dvalue := fnd_date.canonical_to_date(p_inputs(l_in_index).value);

2246: l_in_index := l_in_index + 1; -- Count index of inputs table.
2247:
2248: -- Convert the values from the inputs table as set by user.
2249: if l_data_type = C_DATE then
2250: l_dvalue := fnd_date.canonical_to_date(p_inputs(l_in_index).value);
2251: elsif l_data_type = C_NUMBER then
2252: l_nvalue := replace(p_inputs(l_in_index).value, '.', g_decpoint);
2253: elsif l_data_type = C_TEXT then
2254: l_tvalue := p_inputs(l_in_index).value;

Line 2391: l_value := fnd_date.date_to_canonical(p_d(l_varpos));

2387: /* Get the variable value. */
2388: if l_usage <> 'D' then
2389: if(l_data_type = C_DATE) then
2390: -- Dates converted to apps Canonical format.
2391: l_value := fnd_date.date_to_canonical(p_d(l_varpos));
2392: elsif(l_data_type = C_NUMBER) then
2393: -- Numbers converted to canonical format.
2394: l_value := replace(to_char(p_n(l_varpos)),g_decpoint,'.');
2395: else