APPS.IGS_GE_GEN_001 dependencies on DBMS_SQL

Line 1055: v_cursor := dbms_sql.open_cursor;

1051: v_update_who varchar2(100);
1052: v_update_on date;
1053: v_select_string varchar2(255);
1054: BEGIN
1055: v_cursor := dbms_sql.open_cursor;
1056: v_select_string := 'SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE FROM '||p_table_name||' WHERE rowid=:row_id';
1057:
1058: dbms_sql.parse(v_cursor, v_select_string, dbms_sql.native);
1059:

Line 1058: dbms_sql.parse(v_cursor, v_select_string, dbms_sql.native);

1054: BEGIN
1055: v_cursor := dbms_sql.open_cursor;
1056: v_select_string := 'SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE FROM '||p_table_name||' WHERE rowid=:row_id';
1057:
1058: dbms_sql.parse(v_cursor, v_select_string, dbms_sql.native);
1059:
1060: dbms_sql.bind_variable(v_cursor,'row_id',p_rowid);
1061:
1062: dbms_sql.define_column(v_cursor,1,v_update_who,30);

Line 1060: dbms_sql.bind_variable(v_cursor,'row_id',p_rowid);

1056: v_select_string := 'SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE FROM '||p_table_name||' WHERE rowid=:row_id';
1057:
1058: dbms_sql.parse(v_cursor, v_select_string, dbms_sql.native);
1059:
1060: dbms_sql.bind_variable(v_cursor,'row_id',p_rowid);
1061:
1062: dbms_sql.define_column(v_cursor,1,v_update_who,30);
1063: dbms_sql.define_column(v_cursor,2,v_update_on);
1064: v_no_rows := dbms_sql.execute_and_fetch(v_cursor, false);

Line 1062: dbms_sql.define_column(v_cursor,1,v_update_who,30);

1058: dbms_sql.parse(v_cursor, v_select_string, dbms_sql.native);
1059:
1060: dbms_sql.bind_variable(v_cursor,'row_id',p_rowid);
1061:
1062: dbms_sql.define_column(v_cursor,1,v_update_who,30);
1063: dbms_sql.define_column(v_cursor,2,v_update_on);
1064: v_no_rows := dbms_sql.execute_and_fetch(v_cursor, false);
1065: dbms_sql.column_value(v_cursor,1,v_update_who);
1066: dbms_sql.column_value(v_cursor,2,v_update_on);

Line 1063: dbms_sql.define_column(v_cursor,2,v_update_on);

1059:
1060: dbms_sql.bind_variable(v_cursor,'row_id',p_rowid);
1061:
1062: dbms_sql.define_column(v_cursor,1,v_update_who,30);
1063: dbms_sql.define_column(v_cursor,2,v_update_on);
1064: v_no_rows := dbms_sql.execute_and_fetch(v_cursor, false);
1065: dbms_sql.column_value(v_cursor,1,v_update_who);
1066: dbms_sql.column_value(v_cursor,2,v_update_on);
1067: p_update_who := v_update_who;

Line 1064: v_no_rows := dbms_sql.execute_and_fetch(v_cursor, false);

1060: dbms_sql.bind_variable(v_cursor,'row_id',p_rowid);
1061:
1062: dbms_sql.define_column(v_cursor,1,v_update_who,30);
1063: dbms_sql.define_column(v_cursor,2,v_update_on);
1064: v_no_rows := dbms_sql.execute_and_fetch(v_cursor, false);
1065: dbms_sql.column_value(v_cursor,1,v_update_who);
1066: dbms_sql.column_value(v_cursor,2,v_update_on);
1067: p_update_who := v_update_who;
1068: p_update_on := v_update_on;

Line 1065: dbms_sql.column_value(v_cursor,1,v_update_who);

1061:
1062: dbms_sql.define_column(v_cursor,1,v_update_who,30);
1063: dbms_sql.define_column(v_cursor,2,v_update_on);
1064: v_no_rows := dbms_sql.execute_and_fetch(v_cursor, false);
1065: dbms_sql.column_value(v_cursor,1,v_update_who);
1066: dbms_sql.column_value(v_cursor,2,v_update_on);
1067: p_update_who := v_update_who;
1068: p_update_on := v_update_on;
1069: dbms_sql.close_cursor(v_cursor);

Line 1066: dbms_sql.column_value(v_cursor,2,v_update_on);

1062: dbms_sql.define_column(v_cursor,1,v_update_who,30);
1063: dbms_sql.define_column(v_cursor,2,v_update_on);
1064: v_no_rows := dbms_sql.execute_and_fetch(v_cursor, false);
1065: dbms_sql.column_value(v_cursor,1,v_update_who);
1066: dbms_sql.column_value(v_cursor,2,v_update_on);
1067: p_update_who := v_update_who;
1068: p_update_on := v_update_on;
1069: dbms_sql.close_cursor(v_cursor);
1070: END genp_get_audit;

Line 1069: dbms_sql.close_cursor(v_cursor);

1065: dbms_sql.column_value(v_cursor,1,v_update_who);
1066: dbms_sql.column_value(v_cursor,2,v_update_on);
1067: p_update_who := v_update_who;
1068: p_update_on := v_update_on;
1069: dbms_sql.close_cursor(v_cursor);
1070: END genp_get_audit;
1071:
1072:
1073: FUNCTION genp_get_cmp_cutoff(