APPS.CSF_REQUIRED_SKILLS_PKG dependencies on DBMS_SQL

Line 103: l_cur := dbms_sql.open_cursor;

99: end if;
100: close c_obj;
101:
102: -- declare a cursor for dynamic SQL
103: l_cur := dbms_sql.open_cursor;
104: -- parse query (constant 1 = dbms_sql.native)
105: dbms_sql.parse(l_cur,l_qry,1);
106: -- bind query input value
107: dbms_sql.bind_variable(l_cur,'b_skill_id', p_skill_id);

Line 104: -- parse query (constant 1 = dbms_sql.native)

100: close c_obj;
101:
102: -- declare a cursor for dynamic SQL
103: l_cur := dbms_sql.open_cursor;
104: -- parse query (constant 1 = dbms_sql.native)
105: dbms_sql.parse(l_cur,l_qry,1);
106: -- bind query input value
107: dbms_sql.bind_variable(l_cur,'b_skill_id', p_skill_id);
108: l_cnt := dbms_sql.execute_and_fetch(l_cur,false);

Line 105: dbms_sql.parse(l_cur,l_qry,1);

101:
102: -- declare a cursor for dynamic SQL
103: l_cur := dbms_sql.open_cursor;
104: -- parse query (constant 1 = dbms_sql.native)
105: dbms_sql.parse(l_cur,l_qry,1);
106: -- bind query input value
107: dbms_sql.bind_variable(l_cur,'b_skill_id', p_skill_id);
108: l_cnt := dbms_sql.execute_and_fetch(l_cur,false);
109: dbms_sql.close_cursor(l_cur);

Line 107: dbms_sql.bind_variable(l_cur,'b_skill_id', p_skill_id);

103: l_cur := dbms_sql.open_cursor;
104: -- parse query (constant 1 = dbms_sql.native)
105: dbms_sql.parse(l_cur,l_qry,1);
106: -- bind query input value
107: dbms_sql.bind_variable(l_cur,'b_skill_id', p_skill_id);
108: l_cnt := dbms_sql.execute_and_fetch(l_cur,false);
109: dbms_sql.close_cursor(l_cur);
110: if l_cnt <> 1
111: then

Line 108: l_cnt := dbms_sql.execute_and_fetch(l_cur,false);

104: -- parse query (constant 1 = dbms_sql.native)
105: dbms_sql.parse(l_cur,l_qry,1);
106: -- bind query input value
107: dbms_sql.bind_variable(l_cur,'b_skill_id', p_skill_id);
108: l_cnt := dbms_sql.execute_and_fetch(l_cur,false);
109: dbms_sql.close_cursor(l_cur);
110: if l_cnt <> 1
111: then
112: return false;

Line 109: dbms_sql.close_cursor(l_cur);

105: dbms_sql.parse(l_cur,l_qry,1);
106: -- bind query input value
107: dbms_sql.bind_variable(l_cur,'b_skill_id', p_skill_id);
108: l_cnt := dbms_sql.execute_and_fetch(l_cur,false);
109: dbms_sql.close_cursor(l_cur);
110: if l_cnt <> 1
111: then
112: return false;
113: end if;