APPS.HR_ADE_ADI_DATA_SETUP dependencies on BNE_INTERFACE_COLS_B

Line 318: l_bne_value := 'bne_interface_cols_b';

314: ,IN p_user_id
315: , OUT l_interface_code
316: , OUT l_mapping_code;
317: --
318: l_bne_value := 'bne_interface_cols_b';
319: --check interface code
320: OPEN csr_int FOR
321: 'SELECT count(*) ' ||
322: ' FROM ' || l_bne_value ||

Line 360: update bne_interface_cols_b set data_type = decode(l_data_type , 'DATE' , 3 , 'NUMBER' , 1 , 2)

356:
357: loop
358: fetch csr_int into l_col_name , l_data_type;
359: exit when csr_int%NOTFOUND;
360: update bne_interface_cols_b set data_type = decode(l_data_type , 'DATE' , 3 , 'NUMBER' , 1 , 2)
361: where interface_code = l_interface_code and interface_col_name = l_col_name;
362: end loop;
363: close csr_int;
364: --End of Bug# 10348813

Line 628: l_bne_value := 'bne_interface_cols_b';

624: ,IN p_user_id
625: , OUT l_param_list_code
626: , OUT l_interface_code;
627: --
628: l_bne_value := 'bne_interface_cols_b';
629: OPEN csr_int FOR
630: --check interface created and has columns
631: ' SELECT interface_code '||
632: ' FROM '|| l_bne_value ||

Line 1023: l_bne_value := 'bne_interface_cols_b';

1019: , OUT l_param_list_code
1020: , OUT l_interface_code
1021: , OUT l_mapping_code;
1022: --
1023: l_bne_value := 'bne_interface_cols_b';
1024: OPEN csr_int FOR
1025: --check interface created and has columns
1026: ' SELECT interface_code '||
1027: ' FROM '|| l_bne_value ||