DBA Data[Home] [Help]

APPS.PAY_PAYWSMEE_PKG dependencies on HR_CHKFMT

Line 65: l_formatted_value := hr_chkfmt.changeformat (l_db_value, p_uom, p_input_currency_code);

61: if p_lookup_type is null
62: and p_value_set_id is null
63: then
64: -- Convert the default value from database to display format
65: l_formatted_value := hr_chkfmt.changeformat (l_db_value, p_uom, p_input_currency_code);
66: elsif p_lookup_type is not null then
67: -- Get the user meaning for the lookup code stored
68: l_formatted_value := hr_general.decode_lookup (p_lookup_type, l_db_value);
69: elsif p_value_set_id is not null then

Line 1316: -- hr_chkfmt.changeformat() could return a 80 byte string which

1312: --
1313: --
1314: -- sbilling
1315: -- PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value is stored as varchar2(60),
1316: -- hr_chkfmt.changeformat() could return a 80 byte string which
1317: -- will not fit on PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value,
1318: -- therefore use substrb() to truncate this to 60 characters before
1319: -- storing on dB,
1320: -- nb. substrb() must be used as the dB could be set up as multibyte,

Line 1324: substrb(hr_chkfmt.changeformat(

1320: -- nb. substrb() must be used as the dB could be set up as multibyte,
1321: -- in which case each byte must be returned as 2 bytes
1322: --
1323: fetched_entry_value.screen_entry_value :=
1324: substrb(hr_chkfmt.changeformat(
1325: fetched_entry_value.screen_entry_value,
1326: fetched_entry_value.uom,
1327: p_input_currency_code), 1, 60);
1328: --

Line 1329: fetched_entry_value.default_value := hr_chkfmt.changeformat(

1325: fetched_entry_value.screen_entry_value,
1326: fetched_entry_value.uom,
1327: p_input_currency_code), 1, 60);
1328: --
1329: fetched_entry_value.default_value := hr_chkfmt.changeformat(
1330: fetched_entry_value.default_value,
1331: fetched_entry_value.uom,
1332: p_input_currency_code);
1333: --