DBA Data[Home] [Help]

APPS.HR_INTEGRATION_UTILS dependencies on HR_GENERAL

Line 1051: IF (hr_general.chk_application_id(l_application_id) = 'TRUE') THEN

1047: --
1048: -- If application id is an hrms application then error, as these should
1049: -- not be removed.
1050: --
1051: IF (hr_general.chk_application_id(l_application_id) = 'TRUE') THEN
1052: --
1053: -- Integrator belongs to HRMS, so disabling it is not allowed
1054: fnd_message.set_name('PER','PER_289190_NO_DISABLE_HR_INTG');
1055: fnd_message.raise_error;

Line 1586: ' 1,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''1''), '||

1582: ' AND i.param_defn_app_id = t.application_id ';
1583: */
1584: OPEN l_int_csr FOR
1585: 'SELECT i.param_name, decode(d.datatype, '||
1586: ' 1,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''1''), '||
1587: ' 2,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''2''), '||
1588: ' 3,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''3''), '||
1589: ' hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''1'')), '||
1590: ' t.prompt_left ' ||

Line 1587: ' 2,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''2''), '||

1583: */
1584: OPEN l_int_csr FOR
1585: 'SELECT i.param_name, decode(d.datatype, '||
1586: ' 1,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''1''), '||
1587: ' 2,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''2''), '||
1588: ' 3,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''3''), '||
1589: ' hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''1'')), '||
1590: ' t.prompt_left ' ||
1591: ' FROM bne_param_list_items i, bne_param_defns_b d, bne_param_defns_tl t ' ||

Line 1588: ' 3,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''3''), '||

1584: OPEN l_int_csr FOR
1585: 'SELECT i.param_name, decode(d.datatype, '||
1586: ' 1,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''1''), '||
1587: ' 2,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''2''), '||
1588: ' 3,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''3''), '||
1589: ' hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''1'')), '||
1590: ' t.prompt_left ' ||
1591: ' FROM bne_param_list_items i, bne_param_defns_b d, bne_param_defns_tl t ' ||
1592: ' WHERE i.application_id = ' || p_application_id ||

Line 1589: ' hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''1'')), '||

1585: 'SELECT i.param_name, decode(d.datatype, '||
1586: ' 1,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''1''), '||
1587: ' 2,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''2''), '||
1588: ' 3,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''3''), '||
1589: ' hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''1'')), '||
1590: ' t.prompt_left ' ||
1591: ' FROM bne_param_list_items i, bne_param_defns_b d, bne_param_defns_tl t ' ||
1592: ' WHERE i.application_id = ' || p_application_id ||
1593: ' AND i.param_list_code = ''' || p_param_list_code || ''' ' ||