APPS.PAY_US_GEO_UPD_PKG dependencies on DBMS_SQL

Line 2968: sql_cursor := dbms_sql.open_cursor;

2964: ' SET jurisdiction_code = '''||main_new_juri_code||
2965: ''' WHERE assignment_id = '''||to_char(main_assign_id)||
2966: ''' AND jurisdiction_code = '''||main_old_juri_code||
2967: '''';
2968: sql_cursor := dbms_sql.open_cursor;
2969: dbms_sql.parse(sql_cursor, l_text, dbms_sql.v7);
2970: ret := dbms_sql.execute(sql_cursor);
2971: dbms_sql.close_cursor(sql_cursor);
2972: END IF;

Line 2969: dbms_sql.parse(sql_cursor, l_text, dbms_sql.v7);

2965: ''' WHERE assignment_id = '''||to_char(main_assign_id)||
2966: ''' AND jurisdiction_code = '''||main_old_juri_code||
2967: '''';
2968: sql_cursor := dbms_sql.open_cursor;
2969: dbms_sql.parse(sql_cursor, l_text, dbms_sql.v7);
2970: ret := dbms_sql.execute(sql_cursor);
2971: dbms_sql.close_cursor(sql_cursor);
2972: END IF;
2973:

Line 2970: ret := dbms_sql.execute(sql_cursor);

2966: ''' AND jurisdiction_code = '''||main_old_juri_code||
2967: '''';
2968: sql_cursor := dbms_sql.open_cursor;
2969: dbms_sql.parse(sql_cursor, l_text, dbms_sql.v7);
2970: ret := dbms_sql.execute(sql_cursor);
2971: dbms_sql.close_cursor(sql_cursor);
2972: END IF;
2973:
2974:

Line 2971: dbms_sql.close_cursor(sql_cursor);

2967: '''';
2968: sql_cursor := dbms_sql.open_cursor;
2969: dbms_sql.parse(sql_cursor, l_text, dbms_sql.v7);
2970: ret := dbms_sql.execute(sql_cursor);
2971: dbms_sql.close_cursor(sql_cursor);
2972: END IF;
2973:
2974:
2975: --Update element entry values