eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_INTEGRATION_UTILS dependencies on BNE_PARAM_DEFNS_B

Line 785: FROM BNE_PARAM_DEFNS_B

781: -- Have param_defn_code in format :782: l_param_defn_code := substr(l_param_defn_code,instr(l_param_defn_code,':')+1); 783: SELECT PARAM_NAME , DATATYPE 784: INTO l_param_name , l_data_type 785: FROM BNE_PARAM_DEFNS_B 786: WHERE PARAM_DEFN_CODE = l_param_defn_code 787: AND APPLICATION_ID = p_application_id; 788: 789: IF l_data_type <> p_param_type THEN


Line 1533: ' FROM bne_param_list_items i, bne_param_defns_b d, bne_param_defns_tl t ' ||


1529: BEGIN

1530: --

1531: OPEN l_int_csr FOR

1532: 'SELECT i.param_name, d.datatype, t.prompt_left ' ||

1533: ' FROM bne_param_list_items i, bne_param_defns_b d, bne_param_defns_tl t ' ||

1534: ' WHERE i.application_id = ' || p_application_id ||

1535: ' AND i.param_list_code = ''' || p_param_list_code || ''' ' ||

1536: ' AND i.sequence_num = ' || p_number ||

1537: ' AND i.param_defn_code = d.param_defn_code ' ||


Line 1575: ' FROM bne_param_list_items i, bne_param_defns_b d, bne_param_defns_tl t ' ||


1571: /* MODIFIED THIS CURSOR FOR FIXING BUG#4080461

1572: OPEN l_int_csr FOR

1573: 'SELECT i.param_name, decode(d.datatype,1,''Varchar2'',' ||

1574: ' 2,''Number'',3,''Date'',''Varchar2''), t.prompt_left ' ||

1575: ' FROM bne_param_list_items i, bne_param_defns_b d, bne_param_defns_tl t ' ||

1576: ' WHERE i.application_id = ' || p_application_id ||

1577: ' AND i.param_list_code = ''' || p_param_list_code || ''' ' ||

1578: ' AND i.sequence_num = ' || p_number ||

1579: ' AND i.param_defn_code = d.param_defn_code ' ||


Line 1591: ' FROM bne_param_list_items i, bne_param_defns_b d, bne_param_defns_tl t ' ||


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 || ''' ' ||

1594: ' AND i.sequence_num = ' || p_number ||

1595: ' AND i.param_defn_code = d.param_defn_code ' ||


Line 1632: ' FROM bne_param_list_items i, bne_param_defns_b d, bne_param_defns_tl t ' ||


1628: BEGIN

1629: --

1630: OPEN l_int_csr FOR

1631: 'SELECT i.param_name, d.datatype, t.prompt_left ' ||

1632: ' FROM bne_param_list_items i, bne_param_defns_b d, bne_param_defns_tl t ' ||

1633: ' WHERE i.application_id = ' || p_application_id ||

1634: ' AND i.param_list_code = ''' || p_param_list_code || ''' ' ||

1635: ' AND i.sequence_num = ' || p_number ||

1636: ' AND i.param_defn_code = d.param_defn_code ' ||