DBA Data[Home] [Help]

APPS.PAY_PAYWSMEE_PKG dependencies on HR_CHKFMT

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

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

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

1288: --
1289: --
1290: -- sbilling
1291: -- PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value is stored as varchar2(60),
1292: -- hr_chkfmt.changeformat() could return a 80 byte string which
1293: -- will not fit on PAY_ELEMENT_ENTRY_VALUES_F.screen_entry_value,
1294: -- therefore use substrb() to truncate this to 60 characters before
1295: -- storing on dB,
1296: -- nb. substrb() must be used as the dB could be set up as multibyte,

Line 1300: substrb(hr_chkfmt.changeformat(

1296: -- nb. substrb() must be used as the dB could be set up as multibyte,
1297: -- in which case each byte must be returned as 2 bytes
1298: --
1299: fetched_entry_value.screen_entry_value :=
1300: substrb(hr_chkfmt.changeformat(
1301: fetched_entry_value.screen_entry_value,
1302: fetched_entry_value.uom,
1303: p_input_currency_code), 1, 60);
1304: --

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

1301: fetched_entry_value.screen_entry_value,
1302: fetched_entry_value.uom,
1303: p_input_currency_code), 1, 60);
1304: --
1305: fetched_entry_value.default_value := hr_chkfmt.changeformat(
1306: fetched_entry_value.default_value,
1307: fetched_entry_value.uom,
1308: p_input_currency_code);
1309: --