APPS.QLTNINRB SQL Statements

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

Line: 15

     SELECT * from QA_RESULTS
     WHERE TXN_HEADER_ID = NVL (X_TXN_HEADER_ID, TXN_HEADER_ID )
     AND   Collection_id = NVL( X_COLLECTION_ID, Collection_id );

Line: 22

      SELECT *
      FROM qa_results
      WHERE txn_header_id = x;

Line: 27

      SELECT *
      FROM qa_results
      WHERE collection_id = x;

Line: 33

      SELECT *
      FROM qa_results
      WHERE plan_id = planID
      AND collection_id = col_id
      AND occurrence = occ;

Line: 583

    IF X_COL_NAME = 'LAST_UPDATE_DATE' THEN
       return(to_char(table_rec.LAST_UPDATE_DATE));

Line: 587

    IF X_COL_NAME = 'QA_LAST_UPDATE_DATE' THEN
       return(to_char(table_rec.QA_LAST_UPDATE_DATE));

Line: 591

    IF X_COL_NAME = 'LAST_UPDATED_BY' THEN
       return(to_char(table_rec.LAST_UPDATED_BY));

Line: 595

    IF X_COL_NAME = 'QA_LAST_UPDATED_BY' THEN
       return(to_char(table_rec.QA_LAST_UPDATED_BY));

Line: 615

    IF X_COL_NAME = 'LAST_UPDATE_LOGIN' THEN
       return(to_char(table_rec.LAST_UPDATE_LOGIN));

Line: 1583

    IF X_COL_NAME = 'LAST_UPDATE_DATE' THEN
       table_rec.LAST_UPDATE_DATE:=qltdate.any_to_date(return_value);

Line: 1587

    IF X_COL_NAME = 'QA_LAST_UPDATE_DATE' THEN
       table_rec.QA_LAST_UPDATE_DATE:=(return_value);

Line: 1591

    IF X_COL_NAME = 'LAST_UPDATED_BY' THEN
       table_rec.LAST_UPDATED_BY:=to_number(return_value);

Line: 1595

    IF X_COL_NAME = 'QA_LAST_UPDATED_BY' THEN
       table_rec.QA_LAST_UPDATED_BY:=to_number(return_value);

Line: 1615

    IF X_COL_NAME = 'LAST_UPDATE_LOGIN' THEN
       table_rec.LAST_UPDATE_LOGIN:=to_number(return_value);