APPS.HR_TRANSACTION_API dependencies on FND_DATE

Line 1088: varchar2_value || fnd_date.date_to_canonical(date_value) || number_value current_value, --ns

1084: l_original_value varchar2(2000);
1085: --
1086: cursor csr_hatv is
1087: select hatv.transaction_value_id,
1088: varchar2_value || fnd_date.date_to_canonical(date_value) || number_value current_value, --ns
1089: original_varchar2_value || fnd_date.date_to_canonical(original_date_value) || original_number_value original_value
1090: from hr_api_transaction_values hatv
1091: where hatv.transaction_step_id = p_transaction_step_id
1092: and hatv.name = l_name;

Line 1089: original_varchar2_value || fnd_date.date_to_canonical(original_date_value) || original_number_value original_value

1085: --
1086: cursor csr_hatv is
1087: select hatv.transaction_value_id,
1088: varchar2_value || fnd_date.date_to_canonical(date_value) || number_value current_value, --ns
1089: original_varchar2_value || fnd_date.date_to_canonical(original_date_value) || original_number_value original_value
1090: from hr_api_transaction_values hatv
1091: where hatv.transaction_step_id = p_transaction_step_id
1092: and hatv.name = l_name;
1093: --

Line 1140: if ((NVL(p_varchar2_value||fnd_date.date_to_canonical(p_date_value)||p_number_value,'X') <> NVL(l_current_value,'X'))

1136: ,p_original_number_value => p_original_number_value -- remove from RH API interface --ns
1137: ,p_original_date_value => p_original_date_value); -- remove from RH API interface --ns
1138: else
1139: -- call the row handler to update the transaction value
1140: if ((NVL(p_varchar2_value||fnd_date.date_to_canonical(p_date_value)||p_number_value,'X') <> NVL(l_current_value,'X'))
1141: OR (NVL(p_original_varchar2_value||fnd_date.date_to_canonical(p_original_date_value)||p_original_number_value,'X') <> NVL(l_original_value,'X')))
1142: then
1143: g_update_flag := 'Y';
1144: hr_trv_upd.upd

Line 1141: OR (NVL(p_original_varchar2_value||fnd_date.date_to_canonical(p_original_date_value)||p_original_number_value,'X') <> NVL(l_original_value,'X')))

1137: ,p_original_date_value => p_original_date_value); -- remove from RH API interface --ns
1138: else
1139: -- call the row handler to update the transaction value
1140: if ((NVL(p_varchar2_value||fnd_date.date_to_canonical(p_date_value)||p_number_value,'X') <> NVL(l_current_value,'X'))
1141: OR (NVL(p_original_varchar2_value||fnd_date.date_to_canonical(p_original_date_value)||p_original_number_value,'X') <> NVL(l_original_value,'X')))
1142: then
1143: g_update_flag := 'Y';
1144: hr_trv_upd.upd
1145: (p_validate => false