1034: --
1035: -- If application id is an hrms application then error, as these should
1036: -- not be removed.
1037: --
1038: IF (hr_general.chk_application_id(l_application_id) = 'TRUE') THEN
1039: --
1040: -- Integrator belongs to HRMS, so disabling it is not allowed
1041: fnd_message.set_name('PER','PER_289190_NO_DISABLE_HR_INTG');
1042: fnd_message.raise_error;
1569: ' AND i.param_defn_app_id = t.application_id ';
1570: */
1571: OPEN l_int_csr FOR
1572: 'SELECT i.param_name, decode(d.datatype, '||
1573: ' 1,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''1''), '||
1574: ' 2,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''2''), '||
1575: ' 3,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''3''), '||
1576: ' hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''1'')), '||
1577: ' t.prompt_left ' ||
1570: */
1571: OPEN l_int_csr FOR
1572: 'SELECT i.param_name, decode(d.datatype, '||
1573: ' 1,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''1''), '||
1574: ' 2,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''2''), '||
1575: ' 3,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''3''), '||
1576: ' hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''1'')), '||
1577: ' t.prompt_left ' ||
1578: ' FROM bne_param_list_items i, bne_param_defns_b d, bne_param_defns_tl t ' ||
1571: OPEN l_int_csr FOR
1572: 'SELECT i.param_name, decode(d.datatype, '||
1573: ' 1,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''1''), '||
1574: ' 2,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''2''), '||
1575: ' 3,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''3''), '||
1576: ' hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''1'')), '||
1577: ' t.prompt_left ' ||
1578: ' FROM bne_param_list_items i, bne_param_defns_b d, bne_param_defns_tl t ' ||
1579: ' WHERE i.application_id = ' || p_application_id ||
1572: 'SELECT i.param_name, decode(d.datatype, '||
1573: ' 1,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''1''), '||
1574: ' 2,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''2''), '||
1575: ' 3,hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''3''), '||
1576: ' hr_general.decode_lookup(''HR_WEB_ADI_TYPES'',''1'')), '||
1577: ' t.prompt_left ' ||
1578: ' FROM bne_param_list_items i, bne_param_defns_b d, bne_param_defns_tl t ' ||
1579: ' WHERE i.application_id = ' || p_application_id ||
1580: ' AND i.param_list_code = ''' || p_param_list_code || ''' ' ||