APPS.GMA_LOCK_RECORD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 3

  FUNCTION lock_record(V_Table_name VARCHAR2,V_Column_name VARCHAR2,V_Column_val NUMBER,V_Last_update_date DATE) RETURN NUMBER IS

    X_Col_val varchar2(32);

Line: 9

    X_Last_update_date DATE;

Line: 10

    X_Select_statement varchar2(200);

Line: 13

    X_Select_statement := 'SELECT '||V_Column_name||' FROM '||V_Table_name || ' WHERE '||V_Column_name
                                   || ' = :V_Column_val '||' FOR UPDATE OF '|| V_Column_name ||' NOWAIT ';

Line: 27

      dbms_sql.parse(X_Cur_lock_hdr,X_Select_statement,0);

Line: 46

      X_Select_statement:='SELECT Last_update_date FROM '||V_Table_name||' WHERE '||V_Column_name || '=:V_Column_val';

Line: 48

      dbms_sql.parse(X_Get_who_hdr,X_Select_statement,0);

Line: 49

      dbms_sql.define_column(X_Get_who_hdr, 1, V_Last_update_date);

Line: 57

        dbms_sql.column_value(X_Get_who_hdr,1,X_Last_update_date);

Line: 62

      IF X_Last_update_date <> V_Last_update_date THEN
        ROLLBACK;