APPS.PAY_US_GEO_UPD_PKG dependencies on DBMS_SQL

Line 2675: sql_cursor := dbms_sql.open_cursor;

2671: ' SET jurisdiction_code = '''||main_new_juri_code||
2672: ''' WHERE assignment_id = '''||to_char(main_assign_id)||
2673: ''' AND jurisdiction_code = '''||main_old_juri_code||
2674: '''';
2675: sql_cursor := dbms_sql.open_cursor;
2676: dbms_sql.parse(sql_cursor, l_text, dbms_sql.v7);
2677: ret := dbms_sql.execute(sql_cursor);
2678: dbms_sql.close_cursor(sql_cursor);
2679: END IF;

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

2672: ''' WHERE assignment_id = '''||to_char(main_assign_id)||
2673: ''' AND jurisdiction_code = '''||main_old_juri_code||
2674: '''';
2675: sql_cursor := dbms_sql.open_cursor;
2676: dbms_sql.parse(sql_cursor, l_text, dbms_sql.v7);
2677: ret := dbms_sql.execute(sql_cursor);
2678: dbms_sql.close_cursor(sql_cursor);
2679: END IF;
2680:

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

2673: ''' AND jurisdiction_code = '''||main_old_juri_code||
2674: '''';
2675: sql_cursor := dbms_sql.open_cursor;
2676: dbms_sql.parse(sql_cursor, l_text, dbms_sql.v7);
2677: ret := dbms_sql.execute(sql_cursor);
2678: dbms_sql.close_cursor(sql_cursor);
2679: END IF;
2680:
2681:

Line 2678: dbms_sql.close_cursor(sql_cursor);

2674: '''';
2675: sql_cursor := dbms_sql.open_cursor;
2676: dbms_sql.parse(sql_cursor, l_text, dbms_sql.v7);
2677: ret := dbms_sql.execute(sql_cursor);
2678: dbms_sql.close_cursor(sql_cursor);
2679: END IF;
2680:
2681:
2682: --Update element entry values