APPS.JTF_RS_CONC_REPMGR_PUB SQL Statements

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

Line: 27

   select /*+ parallel(rrel) */ rrel.role_relate_id
   from JTF_RS_ROLE_RELATIONS rrel
   where rrel.role_resource_type = 'RS_GROUP_MEMBER';

Line: 70

 jtf_rs_rep_mgr_denorm_pvt.insert_rep_manager_migr
      ( P_API_VERSION     =>     1.0,
        P_ROLE_RELATE_ID  =>     l_role_relate_id,
        X_RETURN_STATUS   =>     x_return_status,
        X_MSG_COUNT       =>     x_msg_count,
        X_MSG_DATA        =>     x_msg_data
 );

Line: 134

            SELECT  role_relate_id,
                    operation_flag,
                    rowid row_id
              FROM  JTF_RS_CHGD_ROLE_RELATIONS
          ORDER BY  creation_date ;

Line: 152

                   JTF_RS_REP_MGR_DENORM_PVT.INSERT_REP_MANAGER
                          ( P_API_VERSION     => 1.0,
                            P_INIT_MSG_LIST   => l_init_msg_list,
                            P_COMMIT          => FND_API.G_TRUE,
                            P_ROLE_RELATE_ID  => l_role.role_relate_id,
                            X_RETURN_STATUS   => l_return_status,
                            X_MSG_COUNT       => l_msg_count,
                            X_MSG_DATA        => l_msg_data);

Line: 174

                JTF_RS_REP_MGR_DENORM_PVT.UPDATE_REP_MANAGER
                            ( P_API_VERSION => 1.0,
                              P_INIT_MSG_LIST  => l_init_msg_list,
                              P_COMMIT        =>  FND_API.G_TRUE,
                              P_ROLE_RELATE_ID  => l_role.role_relate_id,
                              X_RETURN_STATUS   => l_return_status,
                              X_MSG_COUNT       => l_msg_count,
                              X_MSG_DATA        => l_msg_data);

Line: 195

		      JTF_RS_REP_MGR_DENORM_PVT.DELETE_MEMBERS
                                  ( P_API_VERSION     => 1.0,
                                    P_INIT_MSG_LIST   => l_init_msg_list,
                                    P_COMMIT          => FND_API.G_TRUE,
                                    P_ROLE_RELATE_ID  => l_role.role_relate_id,
	     		            X_RETURN_STATUS   => l_return_status,
			            X_MSG_COUNT       => l_msg_count,
			            X_MSG_DATA        => l_msg_data);

Line: 216

       DELETE FROM JTF_RS_CHGD_ROLE_RELATIONS
       --WHERE  CURRENT OF c_get_role ;