APPS.OTA_ADD_TRAINING_SS dependencies on FND_PROFILE

Line 826: l_str_completion_date := to_char(l_completion_date, fnd_profile.value('ICX_DATE_FORMAT_MASK'));

822: l_Type_Meaning := hr_transaction_api.get_varchar2_value
823: (p_transaction_step_id => p_transaction_step_id
824: ,p_name => 'P_TYPE_MEANING');
825:
826: l_str_completion_date := to_char(l_completion_date, fnd_profile.value('ICX_DATE_FORMAT_MASK'));
827:
828:
829: -- Now string all the retreived items into p_add_trg_data
830: --

Line 1222: ,p_completion_date => to_date(l_completion_date,fnd_profile.value('ICX_DATE_FORMAT_MASK'))

1218: ,p_trng_title => l_title
1219: ,p_provider => l_supplier
1220: ,p_type => l_trntype
1221: ,p_centre => l_location
1222: ,p_completion_date => to_date(l_completion_date,fnd_profile.value('ICX_DATE_FORMAT_MASK'))
1223: ,p_award => l_award
1224: ,p_rating => l_score
1225: ,p_duration => l_duration
1226: ,p_duration_units => l_duration_unit

Line 1485: ,p_completion_date => to_date(l_completion_date,fnd_profile.value('ICX_DATE_FORMAT_MASK'))

1481: ,p_trng_title => l_title
1482: ,p_provider => l_supplier
1483: ,p_type => l_trntype
1484: ,p_centre => l_location
1485: ,p_completion_date => to_date(l_completion_date,fnd_profile.value('ICX_DATE_FORMAT_MASK'))
1486: ,p_award => l_award
1487: ,p_rating => l_score
1488: ,p_duration => l_duration
1489: ,p_duration_units => l_duration_unit

Line 1905: ,p_completion_date => to_date(p_completion_date,fnd_profile.value('ICX_DATE_FORMAT_MASK'))

1901: ,p_trng_title => p_trng_title
1902: ,p_provider => p_provider
1903: ,p_type => p_type
1904: ,p_centre => p_centre
1905: ,p_completion_date => to_date(p_completion_date,fnd_profile.value('ICX_DATE_FORMAT_MASK'))
1906: ,p_award => p_award
1907: ,p_rating => p_rating
1908: ,p_duration => p_duration
1909: ,p_duration_units => p_duration_units