APPS.AHL_WF_MAPPING_PVT SQL Statements

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

Line: 138

              Update_Wf_Mapping (
                p_api_version ,
                p_init_msg_list,
                p_commit,
                p_validation_level,
                l_x_Wf_Mapping_tbl(i),
                x_return_status,
                x_msg_count,
                x_msg_data);

Line: 150

              Delete_wf_mapping (
                   p_api_version,
                   p_init_msg_list,
                   p_commit,
                   p_validation_level,
                   x_return_status,
                   x_msg_count,
                   x_msg_data,
                   p_x_Wf_Mapping_tbl(i).Wf_Mapping_Id,
                   p_object_version);

Line: 254

      SELECT Ahl_Wf_Mapping_S.NEXTVAL
      FROM   dual;

Line: 258

      SELECT 1
      FROM   dual
      WHERE EXISTS (SELECT 1
                    FROM   AHL_Wf_Mapping
                    WHERE  WF_Mapping_ID = x_id);

Line: 266

      select ITEM_TYPE
      from WF_RUNNABLE_PROCESSES_V
      where PROCESS_NAME = p_wf_mapping_rec.WF_PROCESS_NAME;

Line: 272

	      SELECT LOOKUP_CODE
	      FROM FND_LOOKUPS
	      WHERE MEANING = l_Wf_Mapping_rec.APPLICATION_USG
	      AND LOOKUP_TYPE = 'AHL_APPLICATION_USAGE_CODE';

Line: 410

       Ahl_Debug_Pub.debug( l_full_name ||':Insert');

Line: 416

   Ahl_Wf_Mapping_Pkg.insert_row (
     X_ROWID                 => l_rowid,
     X_WF_Mapping_ID         => l_Wf_Mapping_rec.WF_Mapping_ID,
     X_OBJECT_VERSION_NUMBER => 1,
     X_CREATION_DATE         => SYSDATE,
     X_CREATED_BY            => Fnd_Global.USER_ID,
     X_LAST_UPDATE_DATE      => SYSDATE,
     X_LAST_UPDATED_BY       => Fnd_Global.USER_ID,
     X_LAST_UPDATE_LOGIN     => Fnd_Global.LOGIN_ID,
     X_ACTIVE_FLAG           => l_Wf_Mapping_rec.ACTIVE_FLAG,
     X_WF_PROCESS_NAME       => l_wf_mapping_rec.wf_process_name,
     X_APPROVAL_OBJECT       => l_Wf_Mapping_rec.APPROVAL_OBJECT,
     X_ITEM_TYPE             => l_Wf_Mapping_rec.ITEM_TYPE,
     X_APPLICATION_USG_CODE  => l_Wf_Mapping_rec.APPLICATION_USG_CODE
      );

Line: 489

PROCEDURE Update_Wf_Mapping (
   p_api_version       IN  NUMBER    := 1.0,
   p_init_msg_list     IN  VARCHAR2  := Fnd_Api.g_false,
   p_commit            IN  VARCHAR2  := Fnd_Api.g_false,
   p_validation_level  IN  NUMBER    := Fnd_Api.g_valid_level_full,
   p_Wf_Mapping_rec     IN  Wf_Mapping_Rec_Type,

   x_return_status     OUT NOCOPY VARCHAR2,
   x_msg_count         OUT NOCOPY NUMBER,
   x_msg_data          OUT NOCOPY VARCHAR2
)
IS
   L_API_VERSION        CONSTANT NUMBER := 1.0;

Line: 502

   L_API_NAME           CONSTANT VARCHAR2(30) := 'Update_Wf_Mapping';

Line: 513

      select ITEM_TYPE
      from WF_RUNNABLE_PROCESSES_V
      where PROCESS_NAME = p_wf_mapping_rec.WF_PROCESS_NAME;

Line: 518

      SELECT LOOKUP_CODE
      FROM FND_LOOKUPS
      WHERE MEANING = l_Wf_Mapping_rec.APPLICATION_USG
      AND LOOKUP_TYPE = 'AHL_APPLICATION_USAGE_CODE';

Line: 526

   SAVEPOINT Update_Wf_Mapping;

Line: 573

         p_validation_mode    => Jtf_Plsql_Api.g_update,
         x_return_status      => l_return_status

      );

Line: 632

       Ahl_Debug_Pub.debug( l_full_name ||':Update');

Line: 636

  Ahl_Wf_Mapping_Pkg. UPDATE_ROW (
     X_WF_Mapping_ID         => l_Wf_Mapping_rec.WF_Mapping_ID,
     X_OBJECT_VERSION_NUMBER => l_Wf_Mapping_rec.OBJECT_VERSION_NUMBER + 1,
     X_LAST_UPDATE_DATE      => SYSDATE,
     X_LAST_UPDATED_BY       => Fnd_Global.USER_ID,
     X_LAST_UPDATE_LOGIN     => Fnd_Global.LOGIN_ID,
     X_ACTIVE_FLAG           => l_Wf_Mapping_rec.ACTIVE_FLAG,
     X_WF_PROCESS_NAME       => l_process_name,
     X_APPROVAL_OBJECT       => l_Wf_Mapping_rec.APPROVAL_OBJECT,
     X_ITEM_TYPE             => l_Wf_Mapping_rec.item_type,
X_APPLICATION_USG_CODE  => l_Wf_Mapping_rec.APPLICATION_USG_CODE
   );

Line: 667

      ROLLBACK TO Update_Wf_Mapping;

Line: 675

      ROLLBACK TO Update_Wf_Mapping;

Line: 683

      ROLLBACK TO Update_Wf_Mapping;

Line: 694

END Update_Wf_Mapping;

Line: 714

    select item_type, process_name from WF_RUNNABLE_PROCESSES_V
    where UPPER(display_name) = UPPER(p_wf_mapping_rec.wf_display_name);

Line: 717

    SELECT /* PARALLEL (B) +*/
           B.ITEM_TYPE item_type,
           B.NAME process_name
    FROM   WF_ACTIVITIES B,
           WF_ACTIVITIES_TL T
    WHERE  B.ITEM_TYPE     = T.ITEM_TYPE
    AND    B.NAME          = T.NAME
    AND    B.VERSION       = T.VERSION
    AND    T.LANGUAGE      = USERENV('LANG')
    AND    B.RUNNABLE_FLAG = 'Y'
    AND    B.TYPE          = 'PROCESS'
    AND    SYSDATE BETWEEN B.BEGIN_DATE AND NVL(B.END_DATE, SYSDATE)
    -- SATHAPLI::Bug# 5359954 fix
    /*
    AND    UPPER(T.DISPLAY_NAME) = UPPER(p_wf_mapping_rec.wf_display_name);

Line: 736

    select item_type, process_name from wf_runnable_processes_v
    -- SATHAPLI::Bug# 5359954 fix
    /*
    where UPPER(display_name) = UPPER(p_wf_mapping_rec.wf_display_name)
    */
    where item_type = p_wf_mapping_rec.item_type
    and UPPER(process_name) = UPPER( p_wf_mapping_rec.wf_process_name) ;

Line: 802

    select 1 from AHL_WF_MAPPING
    where APPROVAL_OBJECT is NULL
				AND APPLICATION_USG_CODE = c_appl_usg_code;

Line: 807

    select wf_mapping_id from AHL_WF_MAPPING where APPROVAL_OBJECT is NULL
				AND  APPLICATION_USG_CODE = c_appl_usg_code;

Line: 811

				select lookup_code from fnd_lookup_values_vl
				where lookup_type like 'AHL_APPLICATION_USAGE_CODE'
				and meaning like c_appl_usg;*/

Line: 848

PROCEDURE Delete_wf_mapping (
   p_api_version       IN  NUMBER    := 1.0,
   p_init_msg_list     IN  VARCHAR2  := Fnd_Api.g_false,
   p_commit            IN  VARCHAR2  := Fnd_Api.g_false,
   p_validation_level  IN  NUMBER    := Fnd_Api.g_valid_level_full,
   x_return_status     OUT NOCOPY VARCHAR2,
   x_msg_count         OUT NOCOPY NUMBER,
   x_msg_data          OUT NOCOPY VARCHAR2,
   p_wf_mapping_id     IN  NUMBER,
   p_object_version    IN  NUMBER
)

IS
   CURSOR c_wf_mapping IS
      SELECT   *
      FROM     Ahl_wf_mapping
      WHERE    wf_mapping_id = p_wf_mapping_id;

Line: 872

   l_api_name    CONSTANT VARCHAR2(30) := 'Delete_wf_mapping';

Line: 877

   SAVEPOINT Delete_wf_mapping;

Line: 901

       Ahl_Debug_Pub.debug( l_full_name ||':Delete');

Line: 917

   DELETE FROM Ahl_wf_mapping
    WHERE  wf_mapping_id = p_wf_mapping_id;

Line: 946

      ROLLBACK TO Delete_wf_mapping;

Line: 954

      ROLLBACK TO Delete_wf_mapping;

Line: 962

      ROLLBACK TO Delete_wf_mapping;

Line: 973

END Delete_wf_mapping;

Line: 1122

    SELECT 1 FROM FND_LOOKUPS
    WHERE meaning =   p_wf_mapping_rec.Application_Usg
    AND LOOKUP_TYPE = 'AHL_APPLICATION_USAGE_CODE';

Line: 1170

      SELECT   *
      FROM     AHL_Wf_Mapping
      WHERE    WF_Mapping_ID = p_Wf_Mapping_rec.WF_Mapping_ID;

Line: 1261

    SELECT LOOKUP_CODE
    FROM FND_LOOKUPS
    WHERE MEANING = p_Wf_Mapping_rec.application_usg
    AND LOOKUP_TYPE = 'AHL_APPLICATION_USAGE_CODE';*/