24: SELECT resp_application_id, responsibility_id
25: FROM hr_adi_intg_resp
26: WHERE intg_application_id || ':' || integrator_code = p_intg_code;
27: --
28: l_curr_resp_id number := fnd_global.resp_id;
29: l_curr_resp_app_id number := fnd_global.resp_appl_id;
30: l_found boolean := false;
31: l_count number := 0;
32: --
25: FROM hr_adi_intg_resp
26: WHERE intg_application_id || ':' || integrator_code = p_intg_code;
27: --
28: l_curr_resp_id number := fnd_global.resp_id;
29: l_curr_resp_app_id number := fnd_global.resp_appl_id;
30: l_found boolean := false;
31: l_count number := 0;
32: --
33: BEGIN
889: END IF;
890: CLOSE csr_int;
891: --
892: -- Get user
893: SELECT fnd_global.user_id
894: INTO l_user_id
895: FROM dual;
896: --
897: -- Store SQL in BNE schema
1350: --
1351: BEGIN
1352: --
1353: --
1354: SELECT fnd_global.user_id
1355: INTO l_user_id
1356: FROM dual;
1357: --
1358: -- Check for NULLS - Both Application and Integrator Name must have